Copying New Data And Having The Rows Going Down Each Time Ur

Morrissey

Board Regular
Joined
Mar 8, 2002
Messages
85
Hello I have a problem.

Ok I have a macro that copies data to another worksheet

However I want everytime the macro copies this data to move it down to the next cell for example:

One time when I copy the data from the cell 'B11' I copy it to a new worksheet to the cell 'A2' however the next time I copy the data from 'B11' want it to copy the data to 'A3' and so on
 

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.
Hi there

There are many ways to do this, but as a starter try this:

On your other worksheet, in any cell not in column A (say D1) put this formula

="A"&COUNTA(A:A)+1

D4 now shows the address of the next blank cell in Column A (provided you have no gaps). First get your macro to select this sheet then select the required cell using code like this:
Range(Range("D4").Value).Select
Now return to you first sheet, copy your data, select the second sheet and use the code
ActiveSheet.Paste.
This will paste it into the cell you have previously selected

hope this helps, if not use the search function here as this has come up many times
regards
Derek
Der
 
Upvote 0
Here's a more detailed code if you are still stuck. Modify for sheet names.

Sub CopyThis()
Application.ScreenUpdating = False
Sheets("Sheet1").[B11].Copy
Sheets("Sheet2").Select
[A65536].End(xlUp).Offset(1, 0).PasteSpecial (xlPasteAll)
Application.CutCopyMode = False
Sheets("Sheet1").Select
Application.ScreenUpdating = True
End Sub
 
Upvote 0

Forum statistics

Threads
1,213,482
Messages
6,113,915
Members
448,532
Latest member
9Kimo3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top