Add Sheets of Data

[rizmomin]

Hello:

Please open the attached sheet for referance.
Go to Temp Tab
I need VB macro to add data from Sheet in cell D2 to F2.
Please notice that the name of the sheets are numbers.
505
512
519
526
602

Hence if D2 = 512 and F2=526, then add all sheets data in between.
In this case would need to add data from Sheet 512,519 & 526.

Please let me know if any questions.

Thanks for your help.

Riz

[nilem]

Hi Riz, try it

[rizmomin]

Hi Nilem:

You are super...this works great.
Love it.
I have 1 more post titled :Filter and sort by Criteria ...related to the same sheet.
Can you please check and see if you can help on that also.

Thanks a lot

Riz

[Cutter]

If you are satisfied with the solution(s) provided, please remember to mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

[Winon]

@ nilem

Hi nilem,

Again, great Coding!

What I found however is that the last WorkSheet number entered also appears on the last line of the Data pasted.

[rizmomin]

Hi Nilem:

It seems that its not adding all sheets data correctly. ( Its adding only 1st sheet)
Can you check on this.
Also would like to know if I can have Macro button on some other sheet and have data written in Temp sheet.

Thanks

Riz

---------- Post added at 02:06 PM ---------- Previous post was at 01:50 PM ----------

Hi :

Also would like to make sure to tally the Accouny ID.
All Sheets may not have same Account ID data.
Please let me know if you have any questions.

Thanks
Riz

[nilem]

@Winon
Hi, Winon. Thank you for your observation. I myself have typed number of sheets in the data to check if worksheet is filled.

@rizmomin
Riz, all sheets have same Account ID in your example file. Try changing the ID and please check again.

[rizmomin]

Hi Nilem:

I have tried and data is not adding up.
Please have a look.
I have added 1 row after Account ID 2GA029 in Sheet "512" and call it 2GA030.

Now run with selecting 505 to 512.
Data should add up and 2GA030 should be in Temp sheet.
Data in not adding up and 2GA030 is not in Temp sheet.
Please have a look at attahced sheet.

Thanks/
Riz

[nilem]

See row 329 on the sheet Temp

[Winon]

@ nilem,

Thank you for your response

I myself have typed number of sheets in the data to check if worksheet is filled.

Yes, I only saw that afterwards, but my modem lost its signal and I could not inform you that it was not really a "problem". Sorry about that!

Great Coding though!!!

[rizmomin]

Hi Nilem:

Oh i think you misunderstood when i meant adding.
We need to add (Summing) total of each catagory for each Account ID
For Example in the Temp sheet : when adding 505 and 512 sheet

Account ID # of Record # of Full Billable and other fields
2FL001 645+1248 151+242

and so on...
Please have a look and let me know if any qeustions.

Thanks

Riz

[nilem]

Oops, it turns out the "add sheets" and "add data" is translated differently. My English is not the best, sorry.
Are you need to combine the data in the columns of C...K?
What's in the column I?
Are you need to add only those IDs that are on the "Temp", or add all IDs that are found on tabs 502-512?

[rizmomin]

Hi Nilem:
Thank you for your response.
Yes need to combine the data in the columns C to K.
Column I needs to be added too because i may have data in column I.
Add all IDs that are found.
Once this is done, i need to explain you about having another Macro to filter the data.
But i would appreciate if this is first resolved.

Thanks a lot
Riz

[nilem]

try (see attached)

[Winon]

@ nilem,

Absolutely BRILLIANT!!!

[rizmomin]

Hi Nilem:

This works,,,Great ...Thank you so much.
Now one more step to complete and hope you can help me.
Please refer to the attached..
Now i want to filter the data we just created by selecting different catagory from cell C4 and Choose from D4 and E4.
Example:
If we choose # of Full Billable Greater then 10 then only row D records with greater then 10 should show up with other catagory.
Also when displaying, i wanted to sort Account ID Alphabettically.

Please let me know if any questions.

Thank you so much.

Riz