way to automate this process
 

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

way to automate this process
 

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

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

way to automate this process
 

Assuming source sheet is named sheet1 and destinationsheet is sheet2. This
should do it

Sub copycolbtonextcolinsheet2()
With Sheets("sheet2")
dlc = .Cells(2, Columns.Count).End(xlToLeft).Column + 1
Sheets("sheet1").Columns(2).Copy .Cells(1, dlc)
End With
End Sub
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"rodchar" wrote in message
...
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

way to automate this process
 

thanks for the help,
rod.

"Don Guillett" wrote:

Assuming source sheet is named sheet1 and destinationsheet is sheet2. This
should do it

Sub copycolbtonextcolinsheet2()
With Sheets("sheet2")
dlc = .Cells(2, Columns.Count).End(xlToLeft).Column + 1
Sheets("sheet1").Columns(2).Copy .Cells(1, dlc)
End With
End Sub
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"rodchar" wrote in message
...
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