Re: $$Excel-Macros$$ combining data in one worksheet from other worksheets

Woh... Great Noorain Sir. Regards, Kuldeep Singh On Tue, Aug 28, 2012 at 3:53 PM, NOORAIN ANSARI wrote: > Dear Kuldeep, > > We can also use below alternative solution in pivot table.. > > Manually Create a Union Query > > If you can't combine your data on a single worksheet, another solution is

Re: $$Excel-Macros$$ combining data in one worksheet from other worksheets

Dear Kuldeep, We can also use below alternative solution in pivot table.. Manually Create a Union Query If you can't combine your data on a single worksheet, another solution is to create named ranges in an Excel file, and use MS Query to combine the data. There are sample files here: http://www

Re: $$Excel-Macros$$ combining data in one worksheet from other worksheets

Yes Noorain Sir, Pivot Table is great solution for this query. Code 16-08-12 17-08-12 18-08-12 4656113 7402 8231 7231 4656114 7403 8232 7232 4656115 7404 8233 7233 4656116 7405 8234 7234 4656117 7406 8235 7235 4656118 7407 8236 7236 4656119 7408 8237 7237 4

Re: $$Excel-Macros$$ combining data in one worksheet from other worksheets

- >>>>> >> For sht = 1 To Sheets.Count >>>>> >> If (Sheets(sht).Name <> dSheet) Then >>>>> >> Sheets(sht).Select >>>>> >> Sheets

Re: $$Excel-Macros$$ combining data in one worksheet from other worksheets

;>> >> For R = 1 To LastRow >>>> >> If (Sheets(sht).Cells(R, "A").Value & "X" <> "X") >>>> Then >>>> >> If (Not Dict_Code.exists(Sheets(sht).Ce

Re: $$Excel-Macros$$ combining data in one worksheet from other worksheets

To LastRow >>> >> If (Sheets(sht).Cells(R, "A").Value & "X" <> "X") Then >>> >> If (Not Dict_Code.exists(Sheets(sht).Cells(R, >>> >> "A").Value)) Then >>> >> >>> >> '----

Re: $$Excel-Macros$$ combining data in one worksheet from other worksheets

, 2012 2:40:11 PM Subject: Re: $$Excel-Macros$$ combining data in one worksheet from other worksheets Dear Kuldeep, But if the location of any code is change then linking will not showing correct results. Can you give me other solution for the same. Thanks & Regards, CA KSAGAR On Fri, Au

Re: $$Excel-Macros$$ combining data in one worksheet from other worksheets

lue = >> >> Sheets(sht).Cells(R, "A").Value >> >> Dict_Code.Add Sheets(sht).Cells(R, >> >> "A").Value, >> >> nRows >> >> >> >> '-

Re: $$Excel-Macros$$ combining data in one worksheet from other worksheets

gt;> Else >> >> '--- >> >> Sheets(dSheet).Cells(Dict_Code.Item(Sheets(sht).Cells(R, "A").Value), sht >> + >> 1).Value = _ >> Sheets(sht).Cells(R, "B").Value >> >> 

RE: $$Excel-Macros$$ combining data in one worksheet from other worksheets

Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: 17 August 2012 8:41 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ combining data in one worksheet from other workshe

Re: $$Excel-Macros$$ combining data in one worksheet from other worksheets

; 1).Value = _ > Sheets(sht).Cells(R, "B").Value > > '--- > End If > End If > Next R > End If > Next sht > M

Re: $$Excel-Macros$$ combining data in one worksheet from other worksheets

-     End If     End If     Next R     End If     Next sht     MsgBox "Finished" End Sub   Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you c

Re: $$Excel-Macros$$ combining data in one worksheet from other worksheets

You can use Pivot Table. Regards, Kuldeep Singh On Fri, Aug 17, 2012 at 7:41 PM, SAGAR KASANGOTTUWAR < sagarkasangottu...@gmail.com> wrote: > Dear Friends, > > I want combine the data from other worksheets to one specific worksheet so > kindly give me the fastest way to do same task. > > Note. I

$$Excel-Macros$$ combining data in one worksheet from other worksheets

Dear Friends, I want combine the data from other worksheets to one specific worksheet so kindly give me the fastest way to do same task. Note. I HAVE NEAR ABOUT 200 worksheets which I WANT to combine. THANKS IN ADVANCE, Regards, CA KSAGAR -- Join official facebook page of this forum @ http