Thanks a lot! while waiting I just did below code, and working which is
like your one.
With cs
.Range("A1").CurrentRegion.sort _
Key1:=.Range("B2"), Order1:=xlAscending, _
Key2:=Range("G2"), Order2:=xlDescending, _
Header:=xlYes
End With
Thanks agian!
On Friday, 10 Apri
Put this in your code before end keyword.
ActiveWorkbook.Worksheets("Consolidate").UsedRange.Sort
key1:=ActiveWorkbook.Worksheets("Consolidate").Range("b:b"),
order1:=xlAscending, Header:=xlYes
On Tuesday, April 14, 2015 at 11:23:35 AM UTC+5:30, TAWHID wrote:
>
> Hi Vaibhav,
> I was
>
> Wond
Hi Vaibhav,
I was
Wondering , If I could sort the consolidated table by Code (Column B) ?
Thanks
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
Hi Vaibhav Bhai.
Superb.!!
Regards
Ashish
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor th
Wow! That's really Great! Thanks a lot Vaibhav !
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 wor
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
10 matches
Mail list logo