Merging of 2 differently formated sheets into summary

**dem86** · 03-04-2011, 12:53 PM

Hi all, I have been lurking out here for a while and using a lot of the info from this forum to help manipulate many spread sheet. However, I am now stuck and looking to the community for help (which I hope to gain enough knowledge to be able to repay someday).

I have 2 input spread sheets that are project resource tracking files. I need to merge them into a summay file. Here are my notes on what I am trying to do.

1 - Copy data from sheets (Group A and Group B) into a summary sheet
2 - Rows 2 through 13 will always be in the same order. No additioanl rows will be added in this section.
3 - Group A project columns need to be added first. Append Group B after last Group A column.
4 - Roles section (row 14 and below) need to be sorted by Role (These need to be read from Group A & B sheets and put into summary in role order).
5 - number of projects in columns will change
6 - number of resources in rows will change

I have attached a sampe of my sheets and what I want them to look like when done.

Any help or guidance would be geratly appreciated.

I am using 2003.

**dem86** · 03-08-2011, 10:42 AM

I have the code working to pull the top section of the columns together. I am running into problems with adding the rows by sorted type. I don't know if I have to 'reset' the input sheets or if I have a flaw in my coding. Again, any help would be appreciated.

Thanks.
Doug

**dem86** · 03-08-2011, 03:56 PM

I have been reading and trying to teach myself how to code (ordered a few books so I can get smarter) but I could use some help from some pro's.

I have been able to get part 1 & 2 working. I have tried many different ways to get part 3 working but I am just striking out. Any guidance would be appreciated.

Please Login or Register  to view this content.

**jaslake** · 03-08-2011, 10:33 PM

Hi dem86
In your sample file, please include on the Summary Sheet what you expect this to look like

4 - Roles section (row 14 and below) need to be sorted by type (1 or more of each type on each of the 2 input sheets).

There is no field called "type".

**dem86** · 03-10-2011, 09:15 AM

Hi John, thanks.

I have updated the above items so #4 reads better.

I need to copy the rows from the 2 input sheets into the summary sheet. I think I need to loop through the 1st sheet for find everything with Role 1, write it to summary and then move to 2nd input sheet. Once all role 1's are written to summary I need to go back through input sheets to find Role 2, etc through the last type of role.

One additional item. The rows must align with the columns that they were associated with in the input files. Thus anything from Group B sheet must be put on the summary sheet after the Group A columns.

Thanks in advance for help and thoughts.

Doug

**jaslake** · 03-10-2011, 05:57 PM

Hi Doug
So, based on your sample file, what will your Summary Sheet (rows 14 and below) look like after we've done all of this? Unless I totally misunderstand ( a REAL possibility), your sample file doesn't reflect this. Show me.

**dem86** · 03-10-2011, 06:04 PM

That was pretty strange. I have made some progress but still need help. I will be updating the sample sheet tonight and will try again tomorrow.

Doug