LLEW1
04-07-2009, 07:36 PM
Hi,
I need to copy a specific cell based on a date condition (subject month) and place the data value from the cell next to the date table into another cell <C17> in the same sheet on a monthly basis.
So in the attached example the month is March per <e8> , I need to locate the March data from the monthly History table below and populate its data <c41> in this case "200" into Current Month above to cell <c17>.
The data in History table below will update automatically for each month, I need this sheet to recognise the changed month from Cell <e8> each month and know to select the correct months data below per the History table and place the correct months (correlate to <e8> back to <c17>.
Any thoughts much appreciated.
I need to copy a specific cell based on a date condition (subject month) and place the data value from the cell next to the date table into another cell <C17> in the same sheet on a monthly basis.
So in the attached example the month is March per <e8> , I need to locate the March data from the monthly History table below and populate its data <c41> in this case "200" into Current Month above to cell <c17>.
The data in History table below will update automatically for each month, I need this sheet to recognise the changed month from Cell <e8> each month and know to select the correct months data below per the History table and place the correct months (correlate to <e8> back to <c17>.
Any thoughts much appreciated.