New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

[SOLVED] Copy data from spreadsheets

Macros, VBA, Excel Automation, etc.

[SOLVED] Copy data from spreadsheets

Postby marreco » Sun Jan 22, 2012 11:45 am

hi...

Take to the worksheet "Result" all data from spreadsheets "S1, S2, S3"


Would anyone know how to help me .. thank you!
  • 0

You do not have the required permissions to view the files attached to this post.
Last edited by marreco on Sun Jan 22, 2012 1:25 pm, edited 1 time in total.
marreco
Regular
 
Posts: 51
Joined: Jan 13, 2012
Reputation: 0

Re: Copy data from spreadsheets to a single 3 spreadsheet

Postby charles » Sun Jan 22, 2012 1:04 pm

Hi,

I used a filter to move the "Completed" data from worksheets to Result" sheet. You will see a button. Click it and the results will be displayed.
  • 0

You do not have the required permissions to view the files attached to this post.
There are other ways too do this but...

Be kind let us know if you posted somewhere else!



Charles
charles
Excel Badass
 
Posts: 632
Joined: Dec 10, 2011
Location: Mississippi
Reputation: 1
Excel Version: Excel 2003, 2007 and Mac 2011

Re: Copy data from spreadsheets to a single 3 spreadsheet

Postby marreco » Sun Jan 22, 2012 1:24 pm

hi..

Thank you your help was very gracious.

thank you
  • 0

marreco
Regular
 
Posts: 51
Joined: Jan 13, 2012
Reputation: 0


Return to Macros and VBA Questions

Who is online

Users browsing this forum: No registered users and 120 guests