Actually the blank sheet will have different columns each time. Few columns
may repeat and few may not. Mapping for particular column will be almost same
everytime, but it may change occassionaly. e.g. If there is column "school
name", it will be mapped to "institute name" always. But if "institute name"
doesnt exist in blank sheet, it will be mapped to some other column (say
"college name"). Also in some cases, columns of first sheet need not be
mapped to any column at all.
Can you help me?


"JPW" wrote:


This is possible, but very involved. Do your "blank" sheets always
contain the same columns, or is it different every single time? What
I'm trying to determine is whether or not we would be able to store a
kind of "map" in your blank worksheet to automatically tell the first
worksheet where to put what, rather than designing a complicated
userform.


--
JPW
------------------------------------------------------------------------
JPW's Profile: http://www.excelforum.com/member.php...o&userid=24488
View this thread: http://www.excelforum.com/showthread...hreadid=380809