Copy Data from one cell to another cell

Im looking to copy "Total Profit" value from 'Asset Table' to the corresponding month in 'Monthly' depending on current date. I have gotten it to copy that value and date from 'Asset Table' to 'Monthly' with the record function that i made, but its all in one row.

Originally Posted by dilipandey

Hi whtwzzrd88,

welcome to the forum.

I see you uploaded two workbooks so do you want to copy data from one workbook to another workbook ELSE mention which workbook / sheet / range to consider. Thank



Regards,
DILIPandey
<click on below * if this helps>

Totally my bad, its based on asset manager. The data master is only used to update the table information in asset manager. i didnt know if i should have put that or not so just in case i did. You can pretty much ignore Data Master.

That somewhat answered what i needed. I want this to be recorded weekly so each month will have 4 to 5 records (dependent on the month). one for each week in each month. I will check it every week and manually hit record. so May 2013 will have a record for the 3rd, 10th, 17th, 24th and 31st. Im sorry if this is hard to understand.

For instance, Its May 3rd. I open Asset Manager. I hit record, It copies the date and total profit from workbook page 1 and pastes it to workbook page 2 under the correct month (May).

Now May 10th. I hit record it puts in the same area (Under May) just underneath the previous one. So each month will have 4-5 records depending on the month.

Thank you so much for your patience and help, i greatly appreciate it. It worked perfectly.

Yeah, i tried to figure out how to do that, but i have no idea lol