Take value from same cell daily and fill date wise

[s_komail]

Hello Dears

I'm a assistant in finance dept, I have a excel sheet which automatically calculate current cash available, taking data from several sources. I need a sheet which daily look that cell and record the value date wise. so at the end of month, it enables me to find cash available date wise and i will also become able to find average, max min etc

Regards

[natefarm]

Here's a starter for you. Create a sheet called "MonthToDate" with A1 = "Date" and B1 = "Value".

In the VBA window's ThisWorkbook module, paste the following code, which will run each time the workbook is saved:

Please Login or Register  to view this content.

Be sure to save the workbook as a .xlsm (macro-enabled workbook) if it's not already.

[s_komail]

What if I need mutiple cell values

[natefarm]

Please Login or Register  to view this content.

The above line was just to get you started. Take it from there and do whatever you need.

Examples:

Please Login or Register  to view this content.

[s_komail]

is there any way to do it without vba or macro?

[natefarm]

Maybe I didn't understand your initial request. I thought you wanted to have a sheet that, each day, recorded the date and the value of that day's cash available, so that at the end of the month you would have a list of the cash available at the end of each day. I don't see any other way to do it.

[s_komail]

okay, thanks, i'll perform it using code