filling in a column

R

Ravi

I have exported data which gives me details of invoices by
client, however the client column is populated just once,
while there can be more than one invoice per client. How
can I create a macro that fills in the client column
automatically up to the next client name and then
continues to full the column with this next client until
it finds no other client. I have tried to explain the
issue below

Column 1 Column 2
Client 1 Invoice 1
Invoice 2
Invoice 3
Client2 Invoice 4
Invoice 5
Clientn Invoice x

How can I populate the Column 1 with the client name until
it finds client2 and then uses client 2 to fill it up
until the next.

Many thanks
 
S

Soo Cheon Jheong

Ravi,

1) Select the cells in the column A
2) Press F5
3) Click the Special button, Select Blanks, click OK
4) With the cells selected, Type an equal sign (=)
5) Press the up arrow on the keyboard
6) Hold the Ctrl key and press Enter
7) Select the entire column
8) Choose Edit - Copy
9) Choose Edit - Paste Special, Select Values, click


--
Regards,
Soo Cheon Jheong
Seoul, Korea
_ _
^¢¯^
--
 
Top