Macros I think

R

Rick

I am trying to put together a function to help automate a really long
process. I need to copy a number from one cell of one workbook to multiple
worksheets of another workbook. The problem is that the cell I need to paste
to is different in each worksheet. In the first destination worksheet it
might need to be pasted to b28 and in the next worksheet it would need to be
pasted to b31 etc. It would be the next blank cell in the column. So if the
last data entered in one worksheet is in b28 I will need the new data pasted
to b29. I hope I have explained this well.
 
D

Don Guillett

something like this.

for each ws in sheets
lr=ws.cells(rows.count,"b").end(xlup).row+1
copy range("sourcerange") ws.cells(lr,2)
next
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top