LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 114
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Array Manipulation with VBA coding Joe Excel Discussion (Misc queries) 5 April 20th 07 02:04 AM
meaning of : IF(Switch; Average(array A, array B); array A) DXAT Excel Worksheet Functions 1 October 24th 06 06:11 PM
coding maisy1 Excel Discussion (Misc queries) 1 August 6th 06 08:58 PM
"=ROW()-1" type of coding doesn't appear in a filter / is there coding that does? StargateFan[_3_] Excel Programming 10 October 6th 05 01:18 PM
Implant macro coding into ASP coding Sam yong Excel Programming 5 September 15th 05 10:37 AM


All times are GMT +1. The time now is 04:03 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"