oh... ok...
i can only think of hard-coding the columns...
ToSheet.Range("A" & ToRow).Value = FromSheet.Range("A"
FromRow).Value
...
ToSheet.Range("F" & ToRow).Value = FromSheet.Range("E"
FromRow).Value
Not so neat, huh?....
vect98 Wrote:
Not quite,
the Mat No. is in column B in both sheets. I want to copy column A, C,
which are same for both sheets, but theres also one column in column
of the new sheet which is in column E of the master sheet.
If that makes sense so i want only selected parts of the row tha
correspond to that Mat No. which was found.
Thanks heaps
--
T-容
-----------------------------------------------------------------------
T-容x's Profile:
http://www.excelforum.com/member.php...fo&userid=2657
View this thread:
http://www.excelforum.com/showthread.php?threadid=39884