I've attached the file (i think) to make thing easier.
I am trying to get look at the first row of numbers for a part and then place in a corresponding number below. There are some examples already there such as 10 has 910 under it, and 5 has 400 under it.
I was currently playing around with this code:
But i don't know that this is the right direction to take with it and it doesn't seem to want to cooperate with me. Any suggestions?
Please Login or Register to view this content.
Last edited by abertrand; 01-13-2009 at 10:47 AM.
Attach an example workbook
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
I keep getting a database error when attaching the zip file. It's a pretty big file 2.3MB zipped, but that is still under the size limit. I've tried 5 times.
I uploaded a smaller sample version of the file.
Last edited by abertrand; 01-13-2009 at 10:48 AM.
I don't know about anyone else, but I'm struggling to understand what you want to do and how it is determined. Can you expand on what you're doing?
No Problem.
I currently have a list of parts with numbers that correspond to work centers stretched out horizontally after the part number. I would like a macro that will search these work center numbers and add a new number below the old.
An example is how I have 10 with 910 below or 5 with 400 below. I did that by hand, but I have thousands of parts to work through and would like for it to be accomplished automatically.
So do you have a list of part numbers and numbers that go below them? If so, could you not use a LOOKUP formula?
I do have a list of work centers and the new work centers I would like below. However the list is horizontal and not vertical, so a LOOKUP doesn't work, that's why I was trying to use FIND REPLACE.
There is an HLOOKUP formula...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks