Macro request for sequential numbering

[Bjordion]

Hello,

I currently have a macro that copies a set of data on Sheet1, range A1:F300, pastes this data onto Sheet2 and then deletes certain rows based on criteria I have established. This 300 rows of data is whittled down to, for example, ten rows. Previously, the 300 rows were labeled "1", "2"... "300" in column D. Now on Sheet2 I have "27", "43", "66" etc. in column D, but only ten rows.

I would like my macro to be able to renumber each of those values within column D to a sequential number of "1", "2", "3"... "10" based upon the total number of rows with data on Sheet2. If there are five rows it should number them 1 through 5. If there are 200 rows it should number them 1 through 200.

Thank you in advance!

Bjordion

[tlafferty]

This code should be added after your paste routine. Note that it assumes your data begins at A1 and is a continuous block of cells and that you want your numbering to appear in the D column.

Please Login or Register  to view this content.

[watersev]

hi Bjordion, option. If data for sequential numbering starts from F4 and numbers should appear from E4 and down

Please Login or Register  to view this content.