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.

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Rick" wrote in message
...
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.