P
Potsy
I would like to compare quotes and orders for clients.
On both QUOTE and INVOICE sheets within workbook I have following
columns headings which are identical:
QUOTE:
COLUMN H = CLIENT
COLUMN I = 2007
COLUMN J = 2008
COLUMN K = 2009
INVOICE:
COLUMN H = CLIENT
COLUMN I = 2007
COLUMN J = 2008
COLUMN K = 2009
The rows do not correspond with each other between 2 tabs. However, I
would like it to combine data i.e. CLIENT will be merged where
duplicated and then in columns will be 2007, 2008, 2009 quoted and
invoiced.
Is it possible to automatically merge and populate this in order to
calculate a hit ration per client? I have been trying Excel's
Consolidate feature but do not think it is right.
On both QUOTE and INVOICE sheets within workbook I have following
columns headings which are identical:
QUOTE:
COLUMN H = CLIENT
COLUMN I = 2007
COLUMN J = 2008
COLUMN K = 2009
INVOICE:
COLUMN H = CLIENT
COLUMN I = 2007
COLUMN J = 2008
COLUMN K = 2009
The rows do not correspond with each other between 2 tabs. However, I
would like it to combine data i.e. CLIENT will be merged where
duplicated and then in columns will be 2007, 2008, 2009 quoted and
invoiced.
Is it possible to automatically merge and populate this in order to
calculate a hit ration per client? I have been trying Excel's
Consolidate feature but do not think it is right.