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.
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.