J
Jerri
I am revisiting a problem, my original post is below, but
I think it was confusing.
Each of the 75 tabs in my workbook reperesent a detailed
description of a salesperson's quota. They are based off
templates (but different templates for managers), so name,
employe # and quota are all in the same cells. Some
people have more than one tab. For those people I need to
sum the quota.
I need to create a summary by name, employee # and quota
for everyone and for those people who have multiple
quotas, I need that summed.
I would even like the logic to read to the person's
position and if it meets a certain criteria it returns a
different cell--since the managers have different
templates.
Ideas?
I have six workbooks with about 75 tabs each. I want to
return the same values from each of the different tabs,
consolidated on to one tab. Right now we are doing it by
clicking the cells, but it is taking way too long and too
prone to error.
Instead, I need a formula (macro maybe) that will help me
return those values across all the different tabs.
Value 1: Is generally unique, but may exist more than
once, I want to see it returned each time (so if it
appears 3 times, I want to see it three times), because
how it relates to Value 2 is very important.
Value 2: Is unique, but must be kept in connection with
value 1
Value 3: Is unique, but must be kept in connection with
value 1
any ideas without me learning VB in the next 24 hours?
I think it was confusing.
Each of the 75 tabs in my workbook reperesent a detailed
description of a salesperson's quota. They are based off
templates (but different templates for managers), so name,
employe # and quota are all in the same cells. Some
people have more than one tab. For those people I need to
sum the quota.
I need to create a summary by name, employee # and quota
for everyone and for those people who have multiple
quotas, I need that summed.
I would even like the logic to read to the person's
position and if it meets a certain criteria it returns a
different cell--since the managers have different
templates.
Ideas?
I have six workbooks with about 75 tabs each. I want to
return the same values from each of the different tabs,
consolidated on to one tab. Right now we are doing it by
clicking the cells, but it is taking way too long and too
prone to error.
Instead, I need a formula (macro maybe) that will help me
return those values across all the different tabs.
Value 1: Is generally unique, but may exist more than
once, I want to see it returned each time (so if it
appears 3 times, I want to see it three times), because
how it relates to Value 2 is very important.
Value 2: Is unique, but must be kept in connection with
value 1
Value 3: Is unique, but must be kept in connection with
value 1
any ideas without me learning VB in the next 24 hours?