Copy data from multiple sheets to a consolidated sheet.

Did a preview of the post before I posted it and it forced me to enter text, I am therefore entering the original messgae that I had typed.

I am wondering if you experts can help with the following.

I have a workbook that records weekly Income and Expenses.

Each workbook consists of 4 or 5 sheets that record Income and Expenses that makes up the month.

There are also sheets named Monthly Totals, Monthly Receipt No, Lookup and Formula which should be excluded from any processing as they do not contain data that needs to be copied.

All Income for a week is recorded in Cell A1 to V33 in the appropriate weekly sheet.

All Expenses for a 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 (B)” in D60.

The workbook is a Macro Enabled and is created by using a Templated and running macro.

Is it possible to have all Expenses rows that have input in Sheet1 thru Sheet5 copied to sheet called Month Expenses? Month Expenses has headings in Rows 1 thru 3 and the Sheet will always exist.

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

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 60 in the individual Sheets is a Total Line which has the word “TOTAL” in D60. This might assist in identifying the range.

I have populated sheet named Month Expenses as this should help to work out what the final outcome will be.

Cells C39 to C59, H39 to H59 and I39 to I59 (H and I are merged Cells) have Dropdowns.

Sheet called Month Expenses, E3, F3 and G3 contains a formula that should be changed to SUM from E4 to the last row of data in Column A. Same for columns F and G.

Lastly, the print area should be set to A1 V Last Row and the sheet to be print on 1 page.

Maras.

Firstly, many thanks for taking the time to look at the problem I had identified.

A quick test shows that it warks as expected.

I have a funeral to attend to today, and therefore cannot spend further time to test your proposed solution (I am sure it will be work).

I will test it out with more data tomorrow and report back.

Once again thank you for your time.

Regards

Kayslover