Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array Coding
I receive the following information as an attachment to an Email. The
attachment opens in Notepad. 4100,WM7886,255,1404 4100,WM5589,255,1473 4100,WM6458,253,1230 4100,WM6467,254,966 4100,WM13163,255,1371 4100,WM4241,255,1371 4100,WM10256,255,1323 4100,WM1696,255,1578 4100,WM1695,255,1467 4100,WM6909,255,1435 4100,WM6332,255,993 4100,WM2899,255,1018 4100,WM1349,243,1712 Always ignore the 1st part of the array e.g.4100, this is the code of the site. The 2nd part of the array is always in column "A" and it could be on any row within 25 sheets all with different Tab Names. The maximum number of rows used on each sheet is 35. The final 2 parts of the array need to enter the 1st and 2nd empty columns on the row that is selected by the 2nd part of the array is it possible to code into Excel. At the moment I am doing Text to Columns then cut and pasting after finding the correct row in column "A" that matches the second part of the array. I hope I have explained the above properly -- I am using XP Office. -- Many thanks hazel |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array Manipulation with VBA coding | Excel Discussion (Misc queries) | |||
meaning of : IF(Switch; Average(array A, array B); array A) | Excel Worksheet Functions | |||
coding | Excel Discussion (Misc queries) | |||
"=ROW()-1" type of coding doesn't appear in a filter / is there coding that does? | Excel Programming | |||
Implant macro coding into ASP coding | Excel Programming |