Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
auto-fill information
I have a list of SSNs (social security numbers) along with various line
of information that looks something like this: 123456789 , 1 , 64A , 114 , 75.11 , 1.7180 _________, 2 , 65A , 207 , 30.34 , 0.6050 Each of the commas represent a different cell. In other words, the SSNs do not extend down for each line, and ther are multiple lines for each SSN. This is quite an extensive list and need the appropriate SSN to extend to each line that is associated wit it so that it would look like this: 123456789 , 1 , 64A , 114 , 75.11 , 1.7180 123456789 , 2 , 65A , 207 , 30.34 , 0.6050 How would I write a macro to do this? I've tried using a loop but it refused to work so I scrapped the entir thing. Any help would be greatly appreciated!! ti -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I use auto fill to add information from an existing source? | New Users to Excel | |||
Drop down tabs that can auto fill certain information? | Excel Worksheet Functions | |||
Auto-fill information while typing | Excel Discussion (Misc queries) | |||
Auto fill-in text and importing information | Excel Discussion (Misc queries) | |||
how to auto fill information from a table to another sheet | Excel Worksheet Functions |