Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need Major Help on the Macro
Hello:
I need your help desperately. Transpose the columns into rows with a condition. For example, Q R S T U V X Y Z AA AB Row 26 6 A1 B1 C1 D1 1:1 1:2 12:2 Row 27 5 B2 C1 -- -- --- -- So, here are the steps what I would like to you help me, (1) if row 26, col Q has 6, copy 6 columns from V to AB (ie. # column copy = number enter in row 26 col Q. (2) Tranpose and put in col AZ, row 26 (starting on row 26) (3) Skip 2 rows, (4) then repeat for row 27. So, if row 27, col Q has 5, copy 5 columns from V to AA. Tranpose, skip 2 rows and repeat that up to row 1000. Your help is greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need some major help | Excel Discussion (Misc queries) | |||
Major Help Needed Asap | Excel Worksheet Functions | |||
I need major help fast!!!!! | Excel Discussion (Misc queries) | |||
Major help needed | Excel Discussion (Misc queries) | |||
Major cost of time. | Excel Worksheet Functions |