Script that will combine data from different sheets

Hello everyone,

I have a document with multiple Worksheets (in the example i attached there are only 3), each Worksheet has the same type of data in the same format.

I would like a script that can do the following in a different Worksheet:

- Copy some of the data from each sheet into a new one
- Separate the data from each sheet by one row and have that particular row named as the name of the worksheet of which the data will be next (if it is HC then the row that separates the RH issues from HC issue be named HC)

I have attached an example of what i am talking about.

New Microsoft Excel Worksheet.xlsx

Thanks you in advance for your help,
-Alex

Ok guys so ... the script that you gave me worked on that example excel file but when i tried to add it to my document i noticed something:

- The script needs to identify the number of issues on each sheet, This can depend on the data i supply to that worksheet (let`s say that on the H worksheet i have 5 , on the RH i have 10 and on the HC i have 22)
- If WS.Name <> "Example" Then this statement will not work as i have multiple worksheets in the original document. so i need to address this formula to only 5 specific worksheets

Can you help me out here also?

Sorry for any inconvenience. I really appreciate all of you help with this

Thanks,
-Alex

Try

Please Login or Register  to view this content.

Hello YasserKhali,

I am sorry but i was off on the formating of the pages that i want the data pulled from.

The pages contain data from web pages. Below you can find an exact replica of the worksheets formating of the pages. Maybe this is why the script you created did not work as expected.

Sorry again about this.

model.xlsx

Thank you again for your help.

Cheers,
-Alex

YasserKhalil you have my thanks. It worked like a charm

You sir are a life saver.

Thanks a million