Excel macros database

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

mda

Thread Starter
Joined
Nov 16, 2011
Messages
1
Hi guys, your help would be much appreciated on this as I am at a loss and in need of desperate help. I want to create a macro that will copy and paste data that I input onto a separate sheet.

For example

I would like to enter data into cells a1 to A7 then a macro will copy this data into a different sheet but onto cells A1 to G1 - the macro will then delete the data that I had entered. Also if I type in new date to A1 to A7 again I would like the new information in the different sheet but this time copied to cells A2 to G2, this will continue such as data copied to A3 to G3, a4 to g4 and so on. So the different sheet will be my database and the input sheet will be a form. I know that I can use form but this will be more professional.
 
Joined
Jul 1, 2005
Messages
8,546
Sub test()
x = WorksheetFunction.CountA(Sheets("OtherSheet").Columns(1))
Sheets("OtherSheet").Cells(1, 1).Offset(x).Resize(, 7).FormulaArray = "=TRANSPOSE(Sheet1!R1C1:R7C1)"
Sheets("OtherSheet").Cells(1, 1).Offset(x).Resize(, 7).Value = Sheets("OtherSheet").Cells(1, 1).Offset(x).Resize(, 7).Value
Range("A1:A7").ClearContents
End Sub
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top