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
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 <
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
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
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