Posted to microsoft.public.excel.misc
|
|
way to automate this process
Basically, an excel file gets generated like the info below
Sales rep, Sales amt
Joe, $5
So, what i want to do is take the sales amt column for each file that gets
generated and put the columns in a new worksheet
rep, week1, week2
Joe, $5, $10,
"Don Guillett" wrote:
You don't say which is the source column. Also, is the info in only ONE
column?
If desired, send your file to my address below along with this msg and
a clear explanation of what you want and before/after examples.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"rodchar" wrote in message
...
hey all,
i have a excel sales summary report that comes out every week. i was
wondering if there was a way to extract the Current Order Amount column
from
the report and place it in a new excel worksheet in say column A.
Then when the next report comes out take that same column in put it column
B
to see a comparison of the Current Order Amounts?
And is there a way to do this automagically?
thanks,
rodchar
|