Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I think what I am trying to do is not that difficult, but I just can't
get it. I have a spreadsheet with a range of H:10 to DD:267 the work "Pack" appears it is an assignment. I amtry to number each occurence of "Pack" i.e. Pack1, Pack2 up to Pack41. When the code finds the word I want it to fill in the next 8 cells to the right with the name Pack and the incremented number. It should loop through all of the rows repeating the same pattern until it reachs Pack41, it should then start over at Pack1 and continue to loop to the end of the range. Is this very complicated? I'm trying for...next, do until... nothing works Thanks Attachment filename: numberpack.xls Download attachment: http://www.excelforum.com/attachment.php?postid=411038 --- Message posted from http://www.ExcelForum.com/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
find and replace numeric strings in larger text strings | Excel Worksheet Functions | |||
How to find number of pairs of strings from list of strings? | Excel Worksheet Functions | |||
How can I count strings within strings | Excel Worksheet Functions | |||
Finding strings within strings | Excel Programming | |||
Finding strings within strings | Excel Programming |