Excel Macro or Function to pull data from other saved wrkbk

April 27, 2012 at 05:17:15
Specs: Windows XP
I am working on making an auto updating spreadsheet. I pull a report every week called the weekly.xlsm and on that workbook i use the tabe Delinq_detail i then filter the data to my specifics. Then i manually copy and paste certain columns to another workbook book1.xlsm on the weekly tab. Is there anyway to have a function or macro auto pull this data from weekly.xlsm and insert into my cells on book1.xlsm weekly tab? If so what would the function or macro look like?

See More: Excel Macro or Function to pull data from other saved wrkbk

Report •

#1
May 8, 2012 at 08:53:17
Try using the record macro function in excel. Turn the record on and go through your normal process of copying, pasting, and filtering. Once you are done stop recording the macro. From there you can edit the macro you recorded and see what the code is for the different operations you are preforming and adjust to meet your needs.

Hope that helps


Report •
Related Solutions


Ask Question