Re: $$Excel-Macros$$ merge data

Hi Smitha, 1:First paste this macro into any module of any workbook let say workbook1 2:Now run this, now this sub will check if any worksheet exists in workbook except output sheet (manually given name to any of the sheet of workbook 1) 3:If yes any worksheet exist it will copy that and paste

Re: $$Excel-Macros$$ merge data

Hi, Can you explain the macro used On Fri, Jan 11, 2013 at 1:19 PM, Prince wrote: > hi Smitha, > > > please get this > > Public Sub CombineData() > > Public Sub CombineData() > > Dim wks As Worksheet > > For Each wks In ThisWorkbook.Worksheets > If wks.Name = "Index" Or wks.

Re: $$Excel-Macros$$ merge data

hi Smitha, please get this Public Sub CombineData() Public Sub CombineData() Dim wks As Worksheet For Each wks In ThisWorkbook.Worksheets If wks.Name = "Index" Or wks.Name = "Output" Then GoTo lbl Else wks.UsedRange.Copy Wit

Re: $$Excel-Macros$$ merge data

It not working, run time error 1004 appears On Fri, Jan 11, 2013 at 12:23 PM, Prince wrote: > https://groups.google.com/**forum/?hl=en&fromgroups=#!** > searchin/excel-macros/merge/**excel-macros/8T3EPECvA10/**Y3vwNk6wM-YJ

Re: $$Excel-Macros$$ merge data

Hi, Any one please help me in combining the data in two different work sheets in to another worksheet. Its really urgent. On Fri, Jan 11, 2013 at 12:30 PM, Smitha S R wrote: > It not working, run time error 1004 appears > > On Fri, Jan 11, 2013 at 12:23 PM, Prince wrote: > >> https://groups.

Re: $$Excel-Macros$$ merge data

https://groups.google.com/forum/?hl=en&fromgroups=#!searchin/excel-macros/merge/excel-macros/8T3EPECvA10/Y3vwNk6wM-YJ On Friday, January 11, 2013 12:20:39 PM UTC+5:30, Smitha S R wrote: > > NO,PLEASE send it once more > > On Fri, Jan 11, 2013 at 12:14 PM, Prince > > wrote: > >> dear >> >> have y

Re: $$Excel-Macros$$ merge data

NO,PLEASE send it once more On Fri, Jan 11, 2013 at 12:14 PM, Prince wrote: > dear > > have you seen that lik i have provided > > > > On Friday, January 11, 2013 11:58:33 AM UTC+5:30, Smitha S R wrote: > >> HI, >> >> is this possible.. >> >> On Fri, Jan 11, 2013 at 11:28 AM, Smitha S R wrote: >

Re: $$Excel-Macros$$ merge data

dear have you seen that lik i have provided On Friday, January 11, 2013 11:58:33 AM UTC+5:30, Smitha S R wrote: > > HI, > > is this possible.. > > On Fri, Jan 11, 2013 at 11:28 AM, Smitha S R > > wrote: > >> Hi, >> >> Please help >> >> >> On Fri, Jan 11, 2013 at 11:14 AM, Smitha S R >> > wro

Re: $$Excel-Macros$$ merge data

HI, is this possible.. On Fri, Jan 11, 2013 at 11:28 AM, Smitha S R wrote: > Hi, > > Please help > > > On Fri, Jan 11, 2013 at 11:14 AM, Smitha S R wrote: > >> HI, >> >> Is this possible without macros >> >> On Fri, Jan 11, 2013 at 11:12 AM, ashish koul wrote: >> >>> Try this >>> >>> Sub merge

Re: $$Excel-Macros$$ merge data

Hi, Please help On Fri, Jan 11, 2013 at 11:14 AM, Smitha S R wrote: > HI, > > Is this possible without macros > > On Fri, Jan 11, 2013 at 11:12 AM, ashish koul wrote: > >> Try this >> >> Sub merge1() >> Dim i As Long, z As Long >> ' add new sheet at last and name it merge >> Sheets.Add After:=S

Re: $$Excel-Macros$$ merge data

HI, Is this possible without macros On Fri, Jan 11, 2013 at 11:12 AM, ashish koul wrote: > Try this > > Sub merge1() > Dim i As Long, z As Long > ' add new sheet at last and name it merge > Sheets.Add After:=Sheets(Sheets.Count) > Sheets(Sheets.Count).Name = "Merge" > For i = 1 To Sheets.Count

Re: $$Excel-Macros$$ merge data

@S R try this one Sub merge1() Dim i As Long, z As Long ' add new sheet at last and name it merge Sheets.Add After:=Sheets(Sheets.Count) Sheets(Sheets.Count).Name = "Merge" For i = 1 To Sheets.Count - 1 ' add headers from first sheet If i = 1 Then ' find last filled row in the sheet z = Sheets(i).R

Re: $$Excel-Macros$$ merge data

Try this Sub merge1() Dim i As Long, z As Long ' add new sheet at last and name it merge Sheets.Add After:=Sheets(Sheets.Count) Sheets(Sheets.Count).Name = "Merge" For i = 1 To Sheets.Count - 1 ' add headers from first sheet If i = 1 Then ' find last filled row in the sheet z = Sheets(i).Range("a1

Re: $$Excel-Macros$$ merge data

HI, Data for the first jan is in one sheet and data for second jan is another sheet. I have to get data in another worksheet for both dates. On Fri, Jan 11, 2013 at 11:05 AM, NOORAIN ANSARI wrote: > Hi Smitha, > > can share a sample with group. > > > > On Fri, Jan 11, 2013 at 11:04 AM, Smitha S

Re: $$Excel-Macros$$ merge data

Hi Smitha, can share a sample with group. On Fri, Jan 11, 2013 at 11:04 AM, Smitha S R wrote: > Hi, > > How to merge data in two excel worksheets to another work sheet > > -- > Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concis