Hi guys,
I am making an excel file as a compilation file from other excel files. However i have no clue as how to make this work.
In column A, i have a list of store names which is also happen to be the file names for each store sales record
In column B i intend to "read" the name for each store name in column A, cell D10 (which is uniform in each store files).
When i copy to next row, a window pops up which i must choose individual files. This defeats the purpose of copying the formulas. I did it once using openoffice but turnsout i havent found a way in ms excel.
How do i solve this issue? I am not familiar with macro fyi. Thank you in advance.
I am making an excel file as a compilation file from other excel files. However i have no clue as how to make this work.
In column A, i have a list of store names which is also happen to be the file names for each store sales record
In column B i intend to "read" the name for each store name in column A, cell D10 (which is uniform in each store files).
When i copy to next row, a window pops up which i must choose individual files. This defeats the purpose of copying the formulas. I did it once using openoffice but turnsout i havent found a way in ms excel.
How do i solve this issue? I am not familiar with macro fyi. Thank you in advance.