stt01029
04-12-2011, 08:34 AM
Hi all,
I am quite new to VBA and I assume my problem should be particularly easy for the average programmer.
I have two workbooks containing prices - with the format below
date - price 1 - price 2 - etc
I am updating daily the one of the two and I am trying to set up a vba code that copies and pastes automatically all the new prices from the first workbook to the second.
I assume that the main condition here is to match the date horizontally and the name of the price vertically and creat a loop - unfortunately I can't do it on my own - could someone help on that??
Thank you in advance!
I am quite new to VBA and I assume my problem should be particularly easy for the average programmer.
I have two workbooks containing prices - with the format below
date - price 1 - price 2 - etc
I am updating daily the one of the two and I am trying to set up a vba code that copies and pastes automatically all the new prices from the first workbook to the second.
I assume that the main condition here is to match the date horizontally and the name of the price vertically and creat a loop - unfortunately I can't do it on my own - could someone help on that??
Thank you in advance!