fill down specific columns with specific text

Hello

I need to fill down certain columns in a spreadsheet - I have a original spreadsheet, which I have reorganised by other VBA codes - but now I just need the last thing - I have converted the spreadsheet to a table.

Now I just need to fill in like 7 columns with text, not the header though.

So How do I fill in for example column I from row 2 down to a row which should depend on another column, E for example?

Can anyone help in this matter?

Kind regards

Maybe:

Please Login or Register  to view this content.

okay thanks - i've asked in another thread, couldn't figure out how to delete it.
I have created a sheet called job1 where my original data has to be put in.
then I need to change it to a table - I just used the recorder - but what if I want it to use column E as reference for how many rows there are, and it needs to take 120 columns, what needs to change so that I always targets the sheet called job1 and count the rows that one has in E and make a table of 120 columns (with headers) and count it down to the last row in E?

Please Login or Register  to view this content.

this is the code I have to insert the values in the different columns - but it fails at the start..

Please Login or Register  to view this content.

Originally Posted by JOHN H. DAVIS

Maybe:

Please Login or Register  to view this content.

how to I put in the value that I need the different columns to have.
For example column 25 needs to have the word "test" from row 2 down to the last row, which is defined by column E...

Originally Posted by JOHN H. DAVIS

Maybe:

Please Login or Register  to view this content.

how to I put in the value that I need the different columns to have.
For example column 25 needs to have the word "test" from row 2 down to the last row, which is def

this one works partly:

Please Login or Register  to view this content.

But it doesn't stop at the last row, so it just fills in way to many rows..how to make it stop when column E doesn't have text/value in the cells anymore, ie. when the blank starts..?

"For example column 25 needs to have the word "test" from row 2 down to the last row, which is def

this one works partly:

Please Login or Register  to view this content.

But it doesn't stop at the last row, so it just fills in way to many rows..how to make it stop when column E doesn't have text/value in the cells anymore, ie. when the blank starts..? "

Maybe?

Please Login or Register  to view this content.

Not sure what you're after. Post 6 should have worked. Maybe you want this instead?

Please Login or Register  to view this content.

Originally Posted by JOHN H. DAVIS

Not sure what you're after. Post 6 should have worked. Maybe you want this instead?

Please Login or Register  to view this content.

yea exactly, thanks a lot thank you !

You're welcome. Glad to help out and thanks for the feedback. Please mark this thread as solved.