$$Excel-Macros$$ Re: Copy data from different sheets to 1 summary sheet (single excel file)

2016-02-11 Thread Mandeep Baluja 
zaks Every thing is possible Except my increment :P !! Elaborate what you 
wish to combine from Every sheet.
@ Devendra :Same process, but for workbooks you need to loop files in 
folder one by one and Consolidate it !!

*Regards, *
*Mandeep baluja *
*https://www.linkedin.com/messaging/thread/6086488646137958400 *
*https://www.linkedin.com/in/mandeep-baluja-b777bb88?trk=hp-identity-name*

-- 
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 thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Re: Copy data from different sheets to 1 summary sheet (single excel file)

2016-02-11 Thread Devendra Sahay 
Hi Mandeep,


If we have multiple files, then how can we make a consolidated sheet using
a macro ?

Thanks,

On Thu, Feb 11, 2016 at 2:09 PM, Mandeep Baluja 
wrote:

> Worksheets Combine  !! Run this macro Hope you're aware about how to run a
>> macro !! if not try this
>>
>> https://support.office.com/en-us/article/Run-a-macro-5e855fd2-02d1-45f5-90a3-50e645fe3155
>
>
> Sub Simple_Combine()
>
> Application.ScreenUpdating = False
> Application.DisplayAlerts = False
>
> On Error Resume Next
> For Each sht In ActiveWorkbook.Sheets
> If sht.Name = "Collated" Then sht.Delete
> Next
> Dim i As Long
> Sheets.Add.Name = "Collated"
> Set ws = Sheets("Collated")
> For Each sht In ActiveWorkbook.Sheets
> If sht.Name <> "Collated" Then
> sht.UsedRange.Copy ws.Range("A" & Cells(Rows.Count,
> 1).End(xlUp).Offset(1, 0).Row)
> End If
> Next
>
>
> Application.ScreenUpdating = True
> Application.DisplayAlerts = True
> End Sub
>
> Regards,
> Mandeep baluja
>
> --
> 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 thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>



-- 

With Regard !!!
Devendra Rahi

-- 
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 thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Re: Copy data from different sheets to 1 summary sheet (single excel file)

2016-02-11 Thread zaks 
Dear Mandeep,

Thank you so much, it did work very well..

but my question was incomplete. I need only few data from each sheet to be 
copied to 1 summary sheet. 

Is that also possible..



On Thursday, 11 February 2016 11:37:20 UTC+4, zaks wrote:
>
> Is there any way to copy data from different sheets and place it in 1 
> summary sheet (200+ worksheets in 1 excel file)
>
> will be great help if anyone has an answer 
>
> regards
>

-- 
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 thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Re: Copy data from different sheets to 1 summary sheet (single excel file)

2016-02-11 Thread zaks 
Dear Mandeep...

Can understand...& hopefully u will get one soon!

I have attached a sample file with 5 sheets, where 1st sheet is what i am 
looking to get from the original 200+ sheets in my workbook. 

Data is linked for ur understanding...

thanks again for the troubleCheers!

On Thursday, 11 February 2016 13:21:01 UTC+4, Mandeep Baluja wrote:
>
> zaks Every thing is possible Except my increment :P !! Elaborate what you 
> wish to combine from Every sheet.
> @ Devendra :Same process, but for workbooks you need to loop files in 
> folder one by one and Consolidate it !!
>
> *Regards, *
> *Mandeep baluja *
> *https://www.linkedin.com/messaging/thread/6086488646137958400 
>  *
> *https://www.linkedin.com/in/mandeep-baluja-b777bb88?trk=hp-identity-name 
> *
>

-- 
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 thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Re: Copy data from different sheets to 1 summary sheet (single excel file)

2016-02-11 Thread Mandeep Baluja 

>
> Worksheets Combine  !! Run this macro Hope you're aware about how to run a 
> macro !! if not try this 
>
> https://support.office.com/en-us/article/Run-a-macro-5e855fd2-02d1-45f5-90a3-50e645fe3155


Sub Simple_Combine()

Application.ScreenUpdating = False
Application.DisplayAlerts = False

On Error Resume Next
For Each sht In ActiveWorkbook.Sheets
If sht.Name = "Collated" Then sht.Delete
Next
Dim i As Long
Sheets.Add.Name = "Collated"
Set ws = Sheets("Collated")
For Each sht In ActiveWorkbook.Sheets
If sht.Name <> "Collated" Then
sht.UsedRange.Copy ws.Range("A" & Cells(Rows.Count, 
1).End(xlUp).Offset(1, 0).Row)
End If
Next


Application.ScreenUpdating = True
Application.DisplayAlerts = True
End Sub

Regards, 
Mandeep baluja 

-- 
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 thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Re: Copy data from different sheets to 1 summary sheet (single excel file)

2016-02-11 Thread Mandeep Baluja 
Simple use this formula after pressing the button, Without any hassle 
,Clear sheet after doing work. 
>
>
Regards, 
Mandeep baluja 


-- 
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 thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Excel_Macro_Grp.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

$$Excel-Macros$$ Re: Copy data from different sheets to 1 summary sheet (single excel file)

2016-02-11 Thread Mandeep Baluja 

>
> Haha !! Glad to Help Bro :P,Thanks for providing the references otherwise 
>> it will be cumbersome to look values !! 
>>
>
 
 

Regards, 
Mandeep baluja 
https://www.linkedin.com/messaging/thread/6086488646137958400 
https://www.linkedin.com/in/mandeep-baluja-b777bb88?trk=hp-identity-name

-- 
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 thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Re: Copy data from different sheets to 1 summary sheet (single excel file)

2016-02-11 Thread zaks 

Oops...forgot to attach it..

here it is...
On Thursday, 11 February 2016 13:48:35 UTC+4, Mandeep Baluja wrote:
>
> Where are sample files ?? :(
>>
>>

-- 
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 thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Excel_Macro_Grp.xlsx
Description: MS-Excel 2007 spreadsheet

$$Excel-Macros$$ Re: Copy data from different sheets to 1 summary sheet (single excel file)

2016-02-11 Thread zaks 
Dear Mandeep,

This is fabulous!! unbelievable

many thanksYou saved 5 days for me... :)

regards


On Thursday, 11 February 2016 11:37:20 UTC+4, zaks wrote:
>
> Is there any way to copy data from different sheets and place it in 1 
> summary sheet (200+ worksheets in 1 excel file)
>
> will be great help if anyone has an answer 
>
> regards
>

-- 
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 thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.