copy and paste

[MickkyB]

i currently use Excel 2003 and have a copy and paste query.

i have a spreadsheet called "Orders Wk1" that has tabs for each day of the week and each tab has several column headings i.e Customer 1, Customer 2, Customer 3 etc.
I would like a macro that identifies a particular column heading (i.e Customer 2) and then copies the contents of that single column into a separate spreadsheet called "Order Summary"; this needs to be done for each day of the week.
The idea is to build up a history of daily orders for Customer 2.

Also. each time the macro is activated the data needs to be copied into the "Order Summary" in the next available column.

The "Order Summary" spreadsheet will be used all the time but the Orders spreadsheet will change each week i.e "Order Wk1", "Orders Wk2" etc.

TIA for all your help




--------------= Posted using GrabIt =----------------
------= Binary Usenet downloading made easy =---------
-= Get GrabIt for free from http://www.shemes.com/ =-

 

[Otto Moehrbach]

MickkyB

I can help you with this but I really don't understand what you
want this macro to do. You say that you have a workbook (WB) named "Orders
Wk1.xls" and that a new WB will be created by you each week. Do you want
this macro to work on a bunch of such workbooks each time it runs or just
one? Whether you want the macro to work on one WB or a bunch, it will have
to work on one at a time, so let's go with one WB.

You say the week WB has column headers something like Customer
1, Customer 2, Customer 3 etc., and the WB has a separate sheet for each day
of the week. You say that you want a macro that "identifies a particular
column heading.". What do you mean by "identifies"? Do you want the macro
to loop through all the columns and copy/paste each column in turn? Or do
you mean that you want the macro to select a specific column by some
criteria? Clarify "identifies".

You say you have another WB named "Order Summary". You want the
column from the week WB copied and pasted to the Summary WB. Let's say we're
working with Customer 2. Do you want the data for Customer 2 pasted into a
different column for each day of the week or do you want all the data for
Customer 2 for the entire week pasted into one column, each day's data under
the previous day's data?

You say "Also, each time the macro is activated the data needs
to be copied into the "Order Summary" in the next available column."
Clarify "each time". Is this a daily thing? Weekly?

It might help if you wrote down a step-by-step procedure of
exactly what you want this macro to do if you didn't have a macro and had to
do it by hand. Include every little step along the way. Remember that a
macro is infinitely dumb and you have to explain everything. HTH Otto