[Solved] Using macro to find information
Posted: Mon Jul 18, 2016 4:00 am
Hi everyone,
I have an online business and I can down load sales information file every day. But, this file missing three important information. So, I thought that I can create macro to find those information from the inventory file. So, first I copy the inventory file in sheet 1 and uploaded sales file in sheet 2. I copied the sku from the sheet 2 and open find window in sheet 1 and paste the sku on it and find it. Then I copied those three information and move to sheet 2 and paste it to the appropriate position. It worked well, but Idea was to change the sales file everyday and do the same process everyday. But my macro is using the same sales file of which the original macro process was saved, even though I uploaded a new sales file to the sheet 2. Is there anyway, macro handle the same process on the new data set?
I have an online business and I can down load sales information file every day. But, this file missing three important information. So, I thought that I can create macro to find those information from the inventory file. So, first I copy the inventory file in sheet 1 and uploaded sales file in sheet 2. I copied the sku from the sheet 2 and open find window in sheet 1 and paste the sku on it and find it. Then I copied those three information and move to sheet 2 and paste it to the appropriate position. It worked well, but Idea was to change the sales file everyday and do the same process everyday. But my macro is using the same sales file of which the original macro process was saved, even though I uploaded a new sales file to the sheet 2. Is there anyway, macro handle the same process on the new data set?