Hi guys, new to VBA and only my 2nd post. Not having much luck, hoping you can help:
I essentially want to achieve a SUMIF combined with a copy & paste-value.
I want to check a date ('T.O.P Summary'!$B$2) and look it up against a column of dates in my data (Customer1!K:K). When it finds the date on the relevant row, copy the data from Column W (Table3), and paste-value in Column X (Table3).
I can’t simply copy & paste-value the entire column, as the data source is live. Prior month’s data will change during the month as this is an Inventory FIFO model. I want this to be triggered when there is a change to cell $I$3 in the Customer1 tab.
I also want the function to work on all Customer sheets, not the whole workbook.
Any help would be much appreciated or even a push in the right direction as I’m lost and can't seem to find what I'm after.
Thanks in advance.
I essentially want to achieve a SUMIF combined with a copy & paste-value.
I want to check a date ('T.O.P Summary'!$B$2) and look it up against a column of dates in my data (Customer1!K:K). When it finds the date on the relevant row, copy the data from Column W (Table3), and paste-value in Column X (Table3).
I can’t simply copy & paste-value the entire column, as the data source is live. Prior month’s data will change during the month as this is an Inventory FIFO model. I want this to be triggered when there is a change to cell $I$3 in the Customer1 tab.
I also want the function to work on all Customer sheets, not the whole workbook.
Any help would be much appreciated or even a push in the right direction as I’m lost and can't seem to find what I'm after.
Thanks in advance.
