Macro for move and fill

Suzie1956

New Member
Joined
Feb 4, 2014
Messages
1
I have a spreadsheet with several columns. I have a number in Column B with several rows of tasks and dates under that apply to that number and then another number with rows under it (often not the same number of rows as above.) And so on for 100's of lines. I want to add a column and move the number to that column or replace the job number column with the number. I want to fill the number down until the next number comes up and fill it down until the next number comes up and so on. The reason is to allow for pivots and use in other Microsoft software apps. Right now if I try to sort or do something with the data, I can't tell what goes where. I recorded a macro for the first number and tried to modify it. I tried using ranges for the specified fields but can't seem to get it right.

col Acol Bcol C
Number and taskDate
job numberAZ123
sell5/27/2013
market5/25/2013
work5/21/2013
start5/20/2013
job numberAQ456
sell5/30/2013
market5/30/2013
start 5/29/2013
job numberAD890
resell5/1/2013
rework4/15/2013
return4/1/2013
comment4/1/2013
sell4/1/2013
start3/1/2013
 

Some videos you may like

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

Watch MrExcel Video

Forum statistics

Threads
1,122,842
Messages
5,598,394
Members
414,234
Latest member
grlevesq

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top