If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
filling in a column
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 |
#2
|
|||
|
|||
filling in a column
Hi
See: http://www.contextures.com/xlDataEntry02.html regards, Hans -----Original Message----- 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 . |
#3
|
|||
|
|||
filling in a column
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 _ _ ^ąŻ^ -- |
Thread Tools | |
Display Modes | |
|
|