Hi All,
Thank you very much in advance for all your help.
I have a work book that does helps me organize my personal accounting. Each week I spend bl**dy ages allocating the values to the corresponding cells in the other work sheet. What I would like to do is develop some code that reads that date value in the relevant cell, reads the Cost / Revenue center value from the relevant cell, copies the currency value from the relevant cell, searches the other workbook, matches the two together and then pastes it in the relevant cell.
I've played around with the logic and have come up with this;
x = cell with currency value.
y = variable that needs to be matched to cell in separate workbook.
z = variable that needs to be matched to cell in separate workbook.
y2 = matching string variable in separate workbook.
z2 = matching string variable in separate workbook.
b = separate workbook
COPY x TO y = y2 AND z = z2 IN b
MsgBox= "Value filed in"_ & y2 &" and "_& z2" in workbook "_b".
*The point I'm confused at is how to define a range based on a variable ... I think?
All help would be HUGELY appreciated!!!
Thanks,
W
Bookmarks