Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

copying relative references from filtered list

Status
Not open for further replies.

Marita

Technical User
Oct 24, 2003
7
US
I have a download file that changes monthly, ie the rows are with the related data will not be the same. I filter it by business group and P&L type and paste value it into various spreadsheets. I would like to automate this process. However, even using relative reference recording, the macro records a specific cell. How can I overcome this?

Thanks in advance for any help.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top