MrExcel Publishing
Your One Stop for Excel Tips & Solutions

VISUAL Basic i guess copy+paste

Posted by Jonny D on December 29, 2001 2:26 PM

I have a report that need to have two cloums last data paste over to another sheet, but how can i find two rows if the will be different?

Data on Col A A34 = Design
Data on Col B B4 = Staff 6

so need to return these but tommorow the rows will cahnge as i add data so cold be A40 and B4 - Please help


Posted by Jacob on December 29, 2001 3:45 PM


To get the last data try this



Posted by Jonny D on December 30, 2001 3:05 AM

jacob so simple ill try thanks