Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to automate process | Excel Discussion (Misc queries) | |||
need to automate process | Excel Discussion (Misc queries) | |||
Automate deletion process | Excel Worksheet Functions | |||
How can I automate the process of copying the first letter of a ce | Excel Worksheet Functions | |||
Automate process via button on form | Excel Worksheet Functions |