$$Excel-Macros$$ Re: Multiple Sheets data consolidation into one sheet VBA

2015-04-12 Thread TAWHID
It's working perfect. Hats Off ! Thanks a lot On Friday, 10 April 2015 07:36:48 UTC+3, TAWHID wrote: > > Dear Experts, > > Could you please help me on this one. > > I have four sheets named (Location 1,2, 3, 4) , I want to consolidate data > in to one sheet. I have a ready put some VBA. It works

$$Excel-Macros$$ Re: Multiple Sheets data consolidation into one sheet VBA

2015-04-12 Thread Mandeep Baluja
cHANGE THIS LINE IN YOUR CODE BUT PLEASE DON'T CHANGE YOUR CRITERIA AGAIN AND AGAIN FIRST IT WAS NAMED AS LOCATION , THEN YOU CHANGED IT TO TEST ,IF YOU ARE CHANGING YOUR SHEET NEED YOU NEED TO CHANGE THAT IN YOUR CODE TOO BRO. If ws.Name <> "Consolidate" And ws.Name <> "Read Me" And ws.Name <

$$Excel-Macros$$ Re: Multiple Sheets data consolidation into one sheet VBA

2015-04-12 Thread Mandeep Baluja
it is giving correct result. please cross check again. as I checked combining only APU NSC LOKI JUBA On Monday, April 13, 2015 at 12:14:55 AM UTC+5:30, TAWHID wrote: > > If you see at the bottom, It's adding all others sheets too. (Read Me, > test 1, test 2 ect are being added at the bottom

$$Excel-Macros$$ Re: Multiple Sheets data consolidation into one sheet VBA

2015-04-12 Thread TAWHID
If you see at the bottom, It's adding all others sheets too. (Read Me, test 1, test 2 ect are being added at the bottom. On Friday, 10 April 2015 07:36:48 UTC+3, TAWHID wrote: > > Dear Experts, > > Could you please help me on this one. > > I have four sheets named (Location 1,2, 3, 4) , I want

$$Excel-Macros$$ Re: Multiple Sheets data consolidation into one sheet VBA

2015-04-12 Thread Mandeep Baluja
It's already working bro what is required now ??? On Sunday, April 12, 2015 at 9:40:24 PM UTC+5:30, TAWHID wrote: > > Dear Experts, > Still I am straggling to finish it up. > > I just want to consolidate Sheets ( APU, NSC, LOKI, JUBA) these four > sheets. > > > Any help please? > > > > > > O