Copy&Paste Value data of daily base transactions using MACRO

[mikoski]

Hi guys,

Any of you could help me figure this is out? Basically, the objectives are - I have a list of accounts in which it accumulates per daily transaction. At the end of the day or before the next day starts, I need to copy and paste values the data from that date to the summary report and automatically clear the contents of that accounts. Dates and Weeks should be accurate and correct based on the what date it was transacted and what Week number shall it fall. Please see attachment. I hope someone could help me. It will greatly help ease my daily transaction recording and it will be a good start for me formulating my Macro file for this task.Thank you very much. Macro.xlsxMacro.xlsxMacro.xlsx

[mikoski]

please help me

[mikoski]

anyone?

[cemregunay]

You look for this kind of application?

[mikoski]

thank you for the suggestion. what i'm aiming for is still an excel formula for VBA wherein data from certain date should lookup for a specific date matching it's date header and copy paste value the data to that column. if its that possible