Copying Data to Sheets

  • Thread starter Thread starter Mycotopian
  • Start date Start date
M

Mycotopian

Hi guys. This is my first post here but so far I have gotten alot of
questions asked just by searching. Here is my prediciment.

I have team totals that I refresh everyday and what I would like to do
is only update a hidden data sheet and have excel pull all of the
relivant data onto each teams sheet for a more detailed view. The
problem I am having is that the number of entries will vary from day to
day so I cannot set it to be static to individual cells. It would be
nice if I could pull an entire line of data based on the content of one
cell but I dont know of that is possible. This should give you an idea
of what I am working with. Let me know if I need to clarify


Date--Team--TeamMember--$--Product
 
Mate,

Need more info. What format does the data come in? Are you saying tha
the input data has, say, a combination of 100 posible cells and yo
could have any amount of these with values in them but you can't alig
them daily? Like, team A cells 1-10, team B cells 11-20 etc?

If so, you may have to look at the way you are capturing the dat
initially - sounds a little elementary, so if it's not that get bac
with more comprehensive information. Maybe load up a spreadsheet on ho
data arrives (for format) and let's look at the main spreadsheet wher
you hold the data for detailed view, as well. Then I might be able t
get you out of your relevant predicament (sorry)
 
Rocky,

Basically I run a sql query to get the updated sales figures for eac
day and I want to break each teams sales figures out into individua
sheets. Currently all the data on 1 sheet is 5 columns by 600 rows an
it grows every day. I want to basically go through the team column an
pull all of the rows for team a and put them on a seperate sheet and d
the same with team b. Does that help
 
Hi

they don't you just create an individual SQL query for each team (with
the team identifier as selection criteria)??

Frank
 
Mate,

Does the data sheet have the date for each line of data ,in the first
column?

Does the Team sheets reference this information in the first column
(column A)?

I am assuming that your data is broken into columns for each team on
the data sheet.

If so, and with the info you have provided, do this.

On your data sheet, select all the the data including your headings.
Press Cntrl+F3, enter a name for the range, say TeamNames.
In the "Refers to:" box paste

=OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$1:$1),1)

(This will allow for data to increment on your data sheet without
having to re-scope your range name. Sheet1 = name of the sheet. Change
if it isn't.)

Then simply use a vlookup and the range name to get the info you are
looking for;

i.e.say you want team B data, (reference for date is in column A on
Team B sheet, and data info for Team B on column C of the data sheet)
then

= vlookup (a2,teamname,3,0).

Do this in your Team B sheet and copy down to the end of your date
column.
 
Back
Top