Hi All,
I am wondering if you can help with the following.
I have a workbook that records weekly Income and Expenses.
Each workbook consists of 4 or 5 sheets that make up the month.
All Income for the week is recorded in Cell A1 to V33 in the appropriate weekly sheet.
All Expenses for the week is recorded in Cell A39 to V59 (Total of 21 rows) in the appropriate weekly sheet. Row 60 in the individual Sheets is a Total Line which has the word “TOTAL” in D60.
Is it possible to have a sheet that will copy all Expenses rows that have input in it from all the Sheet1 thru Sheet5?
Example
If Sheet1 has data in rows 39 and 40, Sheet2 has data in rows 39 to 46, Sheet3 has no data in rows 39 to 59, Sheet4 has data in only row 39 and Sheet5 has data in rows 39 to 65 (this allows for the User to insert extra lines for Expenses as and when required.
Proposed Solution
What I would like is to have a sheet called "Monthly Expenses" to have data from Sheet1, rows 39 and 40, data from Sheet2 rows 39 to 46, nothing from Sheet3 as it has no input, data from Sheet4 row 39 and finally data from Sheet5 rows 39 to 65. Row 1 in Sheet "Monthly Expenses" will have always have headings as those in Row 38 on Sheets1 -Sheets 5.
Row 60 in the individual Sheets is a Total Line which has the word “TOTAL” in D60. This might assist in identifying the range.
Cells C39 to C59, H39 to H59 and I39 to I59 (H and I are merged Cells) have Dropdowns.
Hoping someone can help.
I am wondering if you can help with the following.
I have a workbook that records weekly Income and Expenses.
Each workbook consists of 4 or 5 sheets that make up the month.
All Income for the week is recorded in Cell A1 to V33 in the appropriate weekly sheet.
All Expenses for the week is recorded in Cell A39 to V59 (Total of 21 rows) in the appropriate weekly sheet. Row 60 in the individual Sheets is a Total Line which has the word “TOTAL” in D60.
Is it possible to have a sheet that will copy all Expenses rows that have input in it from all the Sheet1 thru Sheet5?
Example
If Sheet1 has data in rows 39 and 40, Sheet2 has data in rows 39 to 46, Sheet3 has no data in rows 39 to 59, Sheet4 has data in only row 39 and Sheet5 has data in rows 39 to 65 (this allows for the User to insert extra lines for Expenses as and when required.
Proposed Solution
What I would like is to have a sheet called "Monthly Expenses" to have data from Sheet1, rows 39 and 40, data from Sheet2 rows 39 to 46, nothing from Sheet3 as it has no input, data from Sheet4 row 39 and finally data from Sheet5 rows 39 to 65. Row 1 in Sheet "Monthly Expenses" will have always have headings as those in Row 38 on Sheets1 -Sheets 5.
Row 60 in the individual Sheets is a Total Line which has the word “TOTAL” in D60. This might assist in identifying the range.
Cells C39 to C59, H39 to H59 and I39 to I59 (H and I are merged Cells) have Dropdowns.
Hoping someone can help.