PDA

View Full Version : Solved: Copy specific cell based on date condition paste to specific cell



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.

MaximS
04-07-2009, 09:27 PM
try formula from cell c17, see attachment for details:

LLEW1
04-08-2009, 02:19 AM
Hi Maxims, this hits the mark, indebited to you again, thanks.