Hello
Im trying to create a way of transferring data from an input sheet int
another worksheet. The tricky part is to get the macro to identify th
correct column in which to insert itself in in the worksheet

Let me explain clearer.

I will receive a sheet that can be pasted into an empty worksheet. Let
call it WS1. I have a second worksheet, in which i wishe to collect th
data from a number of sheets, lets call it WS2.

The input will be something like this:

Green 1 2
Blue 2 4
Red 4 4

they are all in seperate columns. I want the data to be in this forma
here in WS2:

Green (merged cells over 2 columns below)

1 2

and next to this i want another 2 columns for the data for Blue and s
on.

A problem is that the order of green, blue and red are not always th
same. so the macro must be able to identify itself with the left han
side cell in WS1 to find the correct column in WS2. The data wil
always be in the same cells but in a different category order in WS1

I have several of these sheets that i have to input you see so to spee
the whole thing up would be nice. I know how to make the macro go t
first empty row in the data column in WS2 so that is no problem. I hav
considered If statment but i didnt get it to work.


If you would like i could attach the fil

--
Message posted from http://www.ExcelForum.com