| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel vlookup function with complex copy and paste
Hello,
I have a spreadhseet with listings of all 50 states and its populations and than I have a 2nd sheet that has each of these states listed but seperated by 6 rows. What I would like to do is use vlookup to bring in the populations from sheet 1 to sheet2 but paste them seperated by 6 rows. For example. Sheet1: State Populations Alabama 1 mil Alaska 80,000 Arizona 10 mil Sheet2: State Populations Alabama 1 mil - - - - - - Alaska 80,000 - - - - - - Arizona 10 mil thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Complex copy and paste in excel | Excel Programming | |||
| Complex Copy/Paste HELP.... | Excel Programming | |||
| Complex Copy/Paste help | Excel Programming | |||
| Complex Copy/Paste help | Excel Programming | |||
| complex copy and paste | Excel Programming | |||
Threaded Mode
