View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
pcor pcor is offline
external usenet poster
 
Posts: 148
Default Find and print last row

I would like to have a macro on a Button on sheet 3 that would do the following
Go to B1 on sheet 1 and find the lAST entry on col B
Now I want the Data that appears on the last row of col b to be printed on
Sheet 3 cell A!
Thanks