Merging or Appending Multiple Worksheets to one Worksheet

Hi kopico

Welcome to the Forum!

If I understand your issue, this Code appears to do as you require. You'll need to play with the Formating of the output. I've demonstrated how to do that in the second to last line of the Code

Please Login or Register  to view this content.

Hi kopico

It'd be much simpler to clear the Summary Sheet and rerun the Code on the updated files...is this acceptable?

Hi kopico

If any Column Header exists in Sheets 1 or 2 or 3 and it also exists in Summary Sheet it'll get populated (as long as the Spelling is the SAME).

Hi kopico

There will actually be a lot of data so it would work out better if I didn't have to erase the summary sheet every time I wanted to update. If there is a way to make it update, I would greatly appreciate it

This can be done but I'll need to add a Marker Column to each Source Worksheet so the Code will know Marked Records have already been processed. Otherwise the Code will need to do a Record by Record search to see if it's already in Summary. If you have a lot of data this will not work efficiently. It would be more efficient to clear and rerun. Pick your poison...you let me know.

I know what's causing this and have fixed it

How come when I run the code sheet 2 column app does not populate on summary sheet correctly

Hi kopico

This Code clears Sheet Summary and re-populates it with Data from the Source Files. The Code also handles this

How come when I run the code sheet 2 column app does not populate on summary sheet correctly

Let me know what you decide about adding a Marker Column to each of the Source Worksheets. This is not a big deal in terms of Code...the question is, can I add an additional Column to each of your Source Worksheets (not Summary).

Please Login or Register  to view this content.

Hi kopico

Please don't quote entire posts, quote only relevant parts of the post.
You don't say what line of Code is throwing the Error but let's move past that for the moment.

This Code adds a Marker Column to each Source Worksheet. It then Filters on that Marker Column to see if any new items have been added. If it finds new items they're processed; if not that Source worksheet is skipped. Let me know of issues.

Please note...the CODE ADDS the Marker Column...don't add them manually...the Marker Column will ALWAYS be the last Column on the Source Worksheet and is labeled "Processed". If you ADD additional Columns to any of the Source worksheets they MUST be inserted to the left of the Marker Column.

Please Login or Register  to view this content.

Hi kopico

Well, run the Code on

if I have a lot of data in the worksheets how will that affect the worksheets

then you tell me...we won't really know until you try it. You may see a slight degradation of the speed with which the Code completes the task but probably nothing to be disconcerted about.

The proof is in the pudding...try it...let me know.

Hi kopico

I'd suggest it depends on what you wish to do. If you wish to change ANY field then I'd recommend going back to the original concept of rebuilding the file.

If you wish to change specific, limited fields then you need to define what it is you wish to do...Code requires definition else it can't do as you require.

What do you have in mind?

Hi kopico

Please post a file that demonstrates this

On each sheet i made columns where it will divide the net by number of days in a month that has passed and in another column divide the net by the number of days in the year that has passed.

I'd like to "see" what's happening...