Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a 500+ row 5 column worksheet IN with each line incrementing by 1 i.e
5 rows by 5 columns would appear 1 21 31 41 51 9 22 32 42 52 66 98 11 86 8 88 9 32 42 52 .. . . . .. . . . .. . . . I need to link each of these rows to worksheet OUT whose rows that do not increment by 1 but with 2 to 5 verticle rows between liked numbers i.e. OUT with correct mapping would look like Col1 A B C D E F All ................ 1 21 31 41 51 ................ 9 22 32 42 52 Malignant neoplasms Type A Version B .............. 66 98 11 86 8 .............. 88 9 32 42 52 Numbers will alway apear after the ........ in the order they appear on the IN worksheet. How can I link uniformly list IN rows to nonuniformly spaced OUT rows. Thanks ahead of time, John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Aling multiple sets of data by header column | Excel Discussion (Misc queries) | |||
variable height variable width stacked bar charts | Charts and Charting in Excel | |||
object variable or with block variable not set | Excel Discussion (Misc queries) | |||
why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? | Excel Worksheet Functions | |||
I Need VBA Assistance for global variable question | Excel Discussion (Misc queries) |