Data Section based on the Date

Hi Everyone,

I have date wise plan for the total month in excel. Every day, i will update the plan as on before day. For example.. im preparing the report on 04.11.11 means, i will update the plan as on 03.11.11. Please help me out to write the macro in such a way that, when i run the macro, based on the system date, report should be updated.


Regards,
Sirisha

What do you mean by 'Report should be updated'? Maybe you can attach a sample workbook with a before and after sheet so we can understand your problem.

Please find the attachment with sample data.

So just to clarify the requirements, if you put in the date as 4th Nov, automatically, the data in column E should add the data for 4th from the previous sheet and the data in column G should reflect the next day's data, right?

If i understood your requirements clearly, find attached the solution. I have made a slight change to your format. I have included a dropdown for the date to make it easier. I have also included 2 helper columns K & L which have been hidden. They should not be deleted. If the month has 31 days, just add an extra value in both the columns.
Let me know if the attached contains what you need.

Hi,

Good Morning.

Absolutely rite. And thank u for the Solution. And one more thing is that, In the column E i will update as you guided. But in Column F, only the selected date plan to be reflected. Means dropdown menu to be added for two columns. in the E column, cumulative quantity should come as u write the code. But in column F only the selected date paln to come.

hi,

Sorry. I have missed the column H. That solution is ok. But the formula is not w.r.t the item code. Sequence may not be the same in both sheets. So please guide how to get the details based on the itemand date.

Originally Posted by Sirisha.P

In the column E i will update as you guided. But in Column F, only the selected date plan to be reflected. Means dropdown menu to be added for two columns. in the E column, cumulative quantity should come as u write the code. But in column F only the selected date paln to come.

Yes, if you check the numbers, column E does contain the cumulative amounts. I have not populated column F as it was not there in the initial requirements and i didnt know what to input there.
Also, i didnt understand the fact why you need 2 dropdowns?

But the formula is not w.r.t the item code. Sequence may not be the same in both sheets. So please guide how to get the details based on the itemand date.

I will need to check this out.