Hello Excel Macro Gurus..I have a question and being fairly new to Macro it seems really difficult to me. i have looked high and low in this forum but can't find a solution. Any help would be much appreciated. Basically what I need to do is:
a. Match PO and Invoice# in worksheet 1 and 2
b. If they both match, I need to go to worksheet 2, get the accounting date, find its month (say it is April)
c. Copy the Invoice Amt from worksheet 1 into the corresponding month on worksheet 1 (under Apr-12)
I am attaching a sample sheet. Any help will be much appreciated!
Bookmarks