vb question

[macangc]

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

 

[Zwahlav]

This can be easily done. turn on autofilter on the header of your table. Into the first cell which is blank but you would like to contain the name put a formula like this (i.e. the first blank cell is "A2") ="A1". Then copy this cell (Ctrl+C), then filter out all blank cells in column "A", select them and paste (Ctrl+V).

I hope that my explanation is understandable... )

 

[macangc]

Thanks for the prompt response, it is appreciated.

The problem I have is that the column has numerous names within it, and i would like the blank cells under each individual to populate untill it reaches the next name and then carry on with the new name etc etc untill it reaches the bottom of the sheet

 

[Zwahlav]

If you copy the cell with formula ("=A1") then Excel puts automaticaly the value of above cell, so there should be no problem...

Here is a sample:

Sešit1
	A	B	C	D
1	Name	Remarks
2	Ricardo	---
3	Ricardo	---
4	Ricardo	---
5	Ricardo	---
6	Bart	---
7	Bart	---
8	Bart	---
9	Bart	---
10	Helene	---
11	Helene	---
12	Helene	---
13	Helene	---
14	Helene	---
List1

 

[macangc]

Excel Question

Thanks

i get it now.. appreciated