Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
espo
 
Posts: n/a
Default combine multiple sheets, each sheet has info in different cells

I am in a football pool. Each week I send out a spread sheet with all of the
games listed across the top. Each person's name is located on the side. I
want to take each spread sheet that i recieve and combine them to a master
sheet. This will aleviat me from having to manually enter everyone's picks.
  #2   Report Post  
Gary''s Student
 
Posts: n/a
Default

A trick to save lots of time is use the person's name on the worksheet tab.
So when you send Trevor his sheet it will have his name on the tab. When you
get the sheets back you can simply copy them into a single workbook.
--
Gary''s Student


"espo" wrote:

I am in a football pool. Each week I send out a spread sheet with all of the
games listed across the top. Each person's name is located on the side. I
want to take each spread sheet that i recieve and combine them to a master
sheet. This will aleviat me from having to manually enter everyone's picks.

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
how do I copy info from one sheet to another via a formula? Trese Excel Worksheet Functions 6 July 28th 05 02:55 PM
Linking sheets to a summary sheet in workbook gambinijr Excel Discussion (Misc queries) 4 December 16th 04 08:13 PM
linking multiple sheets to a summary sheet greg g Excel Discussion (Misc queries) 1 December 16th 04 07:43 AM
HELP -- probably a LOOKUP problem Liz-In-USA Excel Discussion (Misc queries) 3 December 9th 04 12:18 AM
Naming & renaming a sheet tab Cgbilliar Excel Worksheet Functions 1 November 7th 04 05:57 PM


All times are GMT +1. The time now is 02:52 AM.

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"