Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Ken
 
Posts: n/a
Default use data on master worksheet for sorting

Hi,
I was wondering if you got a solution to your excel issue
within the group. I wish I could help.

For me, I need the VBA code that copies from multiple
sheets to one sheet and was wondering if you could help me
with that, as well as instructions.
I just started with a new company and they want me to fix
a problem they have with some linked excel sheets. They
have 7 different sheets maintained by 7 different people
and there is a Master sheet from where all reports are
generated. But recently, whenever a new record is created
by one of the 7 sheets, the Master sheet loses a record.
Please help, if you could. I am a rookie excel user.
Thanks!


Kenneth
Canada



-----Original Message-----

The data is a list of people, the projects they are

working on, the
completion date, who they work for, their skill set,

etc. My manager
wants this data sorted several different ways ie by skill

set,
completion date and manager.

Several different people will be updating the data and I

don't want to
rely on them to copy and paste it to the additional

worksheets then
sort it properly.

I saw some VBA code on this site that copies from

multiple sheets to
one sheet. How would I copy one sheet to multiple sheets

then sort the
data every time it is changed.


--
cwjohn
----------------------------------------------------------

--------------
cwjohn's Profile:
http://www.excelforum.com/member.php?
action=getinfo&userid=16049
View this thread:

http://www.excelforum.com/showthread...hreadid=275088

.

  #2   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

Ron de Bruin has instructions for copying multiple sheets to a master sheet:

http://www.rondebruin.nl/copy2.htm

Ken wrote:
Hi,
I was wondering if you got a solution to your excel issue
within the group. I wish I could help.

For me, I need the VBA code that copies from multiple
sheets to one sheet and was wondering if you could help me
with that, as well as instructions.
I just started with a new company and they want me to fix
a problem they have with some linked excel sheets. They
have 7 different sheets maintained by 7 different people
and there is a Master sheet from where all reports are
generated. But recently, whenever a new record is created
by one of the 7 sheets, the Master sheet loses a record.
Please help, if you could. I am a rookie excel user.
Thanks!


Kenneth
Canada




-----Original Message-----

The data is a list of people, the projects they are


working on, the

completion date, who they work for, their skill set,


etc. My manager

wants this data sorted several different ways ie by skill


set,

completion date and manager.

Several different people will be updating the data and I


don't want to

rely on them to copy and paste it to the additional


worksheets then

sort it properly.

I saw some VBA code on this site that copies from


multiple sheets to

one sheet. How would I copy one sheet to multiple sheets


then sort the

data every time it is changed.


--
cwjohn
----------------------------------------------------------


--------------

cwjohn's Profile:
http://www.excelforum.com/member.php?

action=getinfo&userid=16049

View this thread:


http://www.excelforum.com/showthread...hreadid=275088

.




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with data not getting plotted Scott Ehrlich Excel Discussion (Misc queries) 2 January 25th 05 06:17 AM
How To Refresh Chart Data Without Calculating The Worksheet Carl Bowman Charts and Charting in Excel 5 January 19th 05 10:28 PM
How to use outline data (grouped rows) in a protected worksheet? biometris Excel Discussion (Misc queries) 1 January 17th 05 11:51 PM
Macro does not run when data refreshed Larry Lehman Excel Discussion (Misc queries) 0 January 16th 05 08:31 PM
Copy data into a NEW worksheet Krefty Excel Discussion (Misc queries) 1 December 22nd 04 02:53 PM


All times are GMT +1. The time now is 02:37 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"