convert data automatically?

If your intention is to bring code: SHIFT and start date to all the columns, then see the attachment and try this; you may not require a macro.

Using a formula bring these to the right side columns (highlighted in red color)


Select the area 'I4:J9488'

Press ^G (Go to), select Special and then select Blanks

Now you selected all the blank cells in the range I4:J9488

From the active cell, type a formula to take the upper cell content. ie if your active cell is J4, type '=J3' there.

Now instead of striking enter, press ^Enter (Control+Enter) to copy the formula to all the blank cells selected

You can copy paste all these formulas as values and do the required sorting you need.

rgds

johnjohns

Thanks for the idea. but its not reliable that much cause I need to change the formulas on each dates. But still I really appreciate your help.

It should not take more than 3-4 min to do this. You can filter for the dates and apply the formula at one go.


rgds

johnjohns

Or if you are looking for a macro to fill up the dates and codes, then try this

Please Login or Register  to view this content.

or see the attachment

rgds

johnjohns

thanks a bunch this will make my life easier.!!!!