required pasteing

[Noctos]

could i create a macro which would collect information from fixed cells
everytime it was initiated and the when it came tp paste th information
say in b1 it would move down a cell and paste the info each time the
macro was initiated

 

[Peter Atherton]

Yes, smething like the following.

Sub MyPaste()
set data= Range("G24") 'the fixed cell
dest = application.worksheetfunction.counta(range("B:B")+1
dest =data

End Sub

Not tested

Regards
Peter