Hi,

I am trying to get a macro to work that will take the contents of column
B and copy it to the rows below until there is another piece of data in
column B. That new data is then copied to all subsequent rows until
there is more data in B. It should also delete all rows which
originally contained data in column B.

Any ideas????

Example:
ORIGINAL:
A B C
1 Olive
2 Data1 Smooth
3 Data2 Rough
4 Data3 Smooth
5 Green
6 Data4 Rough
7 Data5 Sticky

DESIRED:
A B C
1 Data1 Olive Smooth
2 Data2 Olive Rough
3 Data3 Olive Smooth
4 Data4 Green Rough
5 Data5 Green Sticky

Thanks in advance!!!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!