View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DaveAsh DaveAsh is offline
external usenet poster
 
Posts: 49
Default Macro for copying ?

Hi, can someone please advise/help with writing a macro to cut all of the
inputted rows from a master spreadsheet ('MASTER DEPOT & OFFICE v1.3' tab
'ALL') into a separate tab (MASTER) including only the 1 particular site.

Master spreadsheet info:
Headings run from A2 to AH2
First inputted entry on row 3
Last inputted entry on row 7000
Location data of intersest in column AF
I need to do this process for numerous sites.

Please help!

Thanks.