Macro to copy data from 3 different worksheets with different columns and rows of data

**Louise_Hughes** · 05-08-2014, 06:06 AM

Hi

Its been a while since I've done any VBA and to say I'm rusty is an understatement!! I'd be grateful for a bit of assistance in solving, what I'm pretty sure is a really easy syntax solution.
I have a spreadsheet with 3 worksheets of data. Each of the worksheets represents a 'stage' in a process, Identify, Assess, Funnel. I need to be able to view all the data from the 3 sheets in one worksheet. There are common fields across all 3 worksheets but data needs to be excluded from some columns on each worksheet and each worksheet will have a different volume of data in it.
Here's what I've managed to cobble together thus far, only relating to the 1st tab of the spreadsheet -

Please Login or Register  to view this content.

It works o.k. until the 'do until' statement. I'm unable to think how to fix it and to ensure that it will pick up the next row of data and stop once all rows have been copied over.
Can any of you clever people help me with this problem? Many thanks in advance.

**Miroslav R.** · 05-09-2014, 02:17 AM

Hi Louise,

pls upload sample workbook.

Regards

M

**Louise_Hughes** · 05-09-2014, 06:36 AM

Hi

Spreadsheet attached. Any help greatly appreciated!

Many thanks
Louise

**Miroslav R.** · 05-09-2014, 06:57 AM

Hi,
only one check before I start:
Rows on your 3 sheets are unique without any duplicates between sheets and you want only copy data form those 3 sheets in to one summary sheet?

M

**Louise_Hughes** · 05-12-2014, 04:49 AM

Hi

Yes, that is correct. Each row is holds unique data and want to combine into one summary sheet. I only specific fields from each spreadsheet but I think I can handle that!
Also, on one other thing which you might be able to help me with - how can I create a new field for each sheet called 'status'. This should relate to the sheet that the data was taken from. For example, data on the identify page should have a new field inserted in column a called 'identify', assess sheet should have new field called 'assess', and so on. is that possible?

Really appreciate your help with this!

**Miroslav R.** · 05-12-2014, 07:29 AM

Hi Louise,

pls have a look at attached file.
Go to summary sheet and click the 'Merge' button in cell 'A1'.

Works fine on the sample You uploaded, but needs to be tested on larger sample just to be sure if everything is correct.

Pls do also cross-check if all data are merged to sum sheet correctly (You decided not to copy all columns to sum sheet -'Item Type', 'Path'...)- you know why.

STATUSREPORT.xlsm

Source sheet name is in column A...

So I hope you will be satisfied... :-)

Regards

M

**Louise_Hughes** · 05-12-2014, 07:36 AM

Wow! Thank you so much. Really appreciate it.

**Miroslav R.** · 05-12-2014, 07:38 AM

... happy... ;-)

Do not forget to close this thread and add reputation if You want...

Have a nice day

M

Macro to copy data from 3 different worksheets with different columns and rows of data

LinkBack

Thread Tools

Rate This Thread

Display

Macro to copy data from 3 different worksheets with different columns and rows of data

Re: Macro to copy data from 3 different worksheets with different columns and rows of data

Re: Macro to copy data from 3 different worksheets with different columns and rows of data

Re: Macro to copy data from 3 different worksheets with different columns and rows of data

Re: Macro to copy data from 3 different worksheets with different columns and rows of data

Re: Macro to copy data from 3 different worksheets with different columns and rows of data

Re: Macro to copy data from 3 different worksheets with different columns and rows of data

Re: Macro to copy data from 3 different worksheets with different columns and rows of data

Thread Information

Users Browsing this Thread

Similar Threads

Macro to copy data from specific columns and rows to new worksheet.....

Macro copy data range from individual worksheets to new rows in consolidated worksheet

Missing data after copy rows data from different worksheets

[SOLVED] Macro to copy formula to all rows that contain data in columns A:C

Macro simplifying - copy rows to worksheets based on values in 2 different columns

Bookmarks

Bookmarks

Posting Permissions