I do not know how to write any code and have limited Excel skills.
I have a financial spreadsheet (2 pages). 1st page is a Summary sheet showing 3 months of financial information (this is what I want to automate). The 2nd page is Detailed, and shows Jan-Dec values which are manually input. I need to be able to find a script that I can use on the summary page to automatically look up the data, and then roll over to the next months.
i.e.
If the detailed worksheet is for the month of "August" then I need the Summary sheet to show the cells from the Detailed worksheet which contain the financial data for June, July and August.
When next month end occurs the Summary sheet should then show the values for July, August and September. I'm not certain if I can have the headings "July", "August" "September" also automated.
The data is set up in rows.
I was thinking:
If Detailed sheet, Cell Z18 (last cell for December) = Empty
Then Go To Z17
Else (I don't know how to phrase this)
Detailed sheet, Cell Z18 should put that value into Summary sheets, cell D7
Any help would be appreciated. I am out of my element here.
Thanks.
This message was edited by hotcat on 2002-09-29 05:54
This message was edited by hotcat on 2002-09-29 05:56
I have a financial spreadsheet (2 pages). 1st page is a Summary sheet showing 3 months of financial information (this is what I want to automate). The 2nd page is Detailed, and shows Jan-Dec values which are manually input. I need to be able to find a script that I can use on the summary page to automatically look up the data, and then roll over to the next months.
i.e.
If the detailed worksheet is for the month of "August" then I need the Summary sheet to show the cells from the Detailed worksheet which contain the financial data for June, July and August.
When next month end occurs the Summary sheet should then show the values for July, August and September. I'm not certain if I can have the headings "July", "August" "September" also automated.
The data is set up in rows.
I was thinking:
If Detailed sheet, Cell Z18 (last cell for December) = Empty
Then Go To Z17
Else (I don't know how to phrase this)
Detailed sheet, Cell Z18 should put that value into Summary sheets, cell D7
Any help would be appreciated. I am out of my element here.
Thanks.
This message was edited by hotcat on 2002-09-29 05:54
This message was edited by hotcat on 2002-09-29 05:56