Hi, I have been struggling to find a way to update a summary sheet with daily information. It seems so simple but I haven't been able to use Excel commands. I tried IF with circular references, but it didn't work, so I guess I will need a macro, and that's where I come completely unstuck - I have no macro experience. I have trawled the forum but can't find any similar question.
I would be really grateful for any suggestions as this has been frustrating me. I am using 2013 version of Excel on Windows 10. I have tried to detail what I need below.
Thanks.
Two Sheets – Daily,Summary.
Therequirement: To be able to Paste Values in Summary with data from Dailyduring each day by use of a button labelled “Update Summary” and to reset Dailyfor the next day if a positive response to a further message is received.
Thedetails:
1. To PasteValues to the row in Summary thathas the same date in Column A as cell C5 in Daily,as follows (where n is the row number):
Daily Worksheet Cells Summary Worksheet Cells R70 – X70 AQn - AWn E76 Nn F76 Tn L76 AFn Q76 AMn
2. Display themessage “Do you want to reset Daily? Y / N”
3. If N isselected go to step 4.
If Y is selected Clear Contents inDaily as follows:
Daily Worksheet Cells C9 – L23 C25 – L39 C41 – L58 C60 – C69
Without affecting any of the data onSummary.
4. End the macro.
Reply With Quote