linking data from a row on one sheet

  • Thread starter Thread starter Clark Haddock
  • Start date Start date
C

Clark Haddock

I have a master sheet with all the sales information that
my company tracks. I would like to create seperate
sheets for each sales rep. I have all their initials
listed under one column. Can I take each row and put the
information onto another sheet based on what I put into
the initials colum?

In simple terms: linking data from a row on one sheet
into another sheet
 
Hi Clark
maybe filtering your data is one option (goto 'Data - Filter). You can
copy your results to another sheet (if you like). Maybe you can explain
what you want with the separate sheets.

HTH
Frank
P.S.: please don't multipost to 3 groups as this will scatter your
responses and costs time for the people answering your questions
 
You can also create a summary sheet in excel and perform
a conditional sum for each sales person using the initials
as the condition to sum them up using something like
SUMIF($J$3:$J425,"=HN",N$3:N425)
In this formula I sum the column N based on the value
of column J being =HN
If you continiuosly add rows of data to your master sheet
remember to leave a note in the master sheet in row XXX
reminding me my formulas only covered up to there.

Hope this helps
 
Back
Top