Hi all
I have a spreadsheet that i would like to be able to do the following but not sure how.
I have an exported file that i have set up some very basic vb to collate and sort the data into easily understood info. but what i cant do is on the 1st column it will put the users name and then in the 2nd column it has other information, now the 2nd column can have multiple rows of information but i need the name in the 1st column to be on every row. This is variable and i only want it to have the name in all the rows untill it reaches the next name in the column then stop and do the same with all the names below.
can anyone help please
I have a spreadsheet that i would like to be able to do the following but not sure how.
I have an exported file that i have set up some very basic vb to collate and sort the data into easily understood info. but what i cant do is on the 1st column it will put the users name and then in the 2nd column it has other information, now the 2nd column can have multiple rows of information but i need the name in the 1st column to be on every row. This is variable and i only want it to have the name in all the rows untill it reaches the next name in the column then stop and do the same with all the names below.
can anyone help please