Need to select and past data between two cells

[chugerknot]

Point List Detail
I need to copy and paist only the cells between the lists below. The list numbers are in a different collume than the rest of the data. The lists are never the same length so I need to find the best way to capture the data and view it on another sheet. I dont want to have to select the range each time I do this. There are several hundered lists to filter.

Thanks for any input.






List No: L313 Description: LVL 1


Point Custom Point Label


M1-118-0 LVL 1 CORR BY 104
M1-119-0 LVL 1 CORR BY . 72
M1-120-0 LVL 1 DATA 10A
M1-121-0 LVL 1 CORR 100A
M1-122-0 LVL 1 CORR 124
M1-123-0 LVL 1 CORR
M1-124-0 LVL 1 CORR 175
M1-125-0 LVL 1 CORR BY
M1-126-0 LVL 1 CORR BY
M1-127-0 LVL 1 CORR BY E.S.
M1-128-0 LVL 1 ELEV #5 LOBBY E.S. SOIL.
M1-129-0 LVL 1 CORR BY CHANGING
M1-130-0 LVL 1 CORR BY CHANGING
M1-131-0 LVL 1 CORR BY JANITOR
M1-132-0 LVL 1 CORR WEST OF LOCKERS
M1-133-0 LVL 1 CORR 1317
M1-134-0 LVL 1 CORR BY
M1-135-0 LVL 1 CORR BY
M1-136-0 LVL 1 CORR WEST OF
M1-137-0 LVL 1 CORR BY TOILET
M1-138-0 LVL 1 CORR BY EXAM
M1-139-0 LVL 1 CORR BY WKRM-
M1-140-0 LVL 1 CORR BY
M1-141-0 LVL 1 CORR BY STAFF WORKROOM
M1-142-0 LVL 1 CORR BY OFF-
M1-143-0 LVL 1 CORR BY \
M1-144-0 LVL 1 CORR BY ROOM
M1-146-0 LVL 1 CORR BY
M1-149-0 LVL 1 ROOM 1285
M1-150-0 LVL 1 ROOM 1316








Point List Detail

List No: L314 Description: LVL 1

Point Custom Point Label


M1-78-0 LVL 1 MECH 1005
M1-81-0 LVL 1 MECH 1005
M1-84-0 LVL 1 MECH 1005
M1-87-0 LVL 1 MECH 1005 WATERFLOW SWITCH P1 ELEC
M1-104-0 LVL 1 NW STAIR 1
M1-151-0 LVL 1 MECH RM 1005 MAIN RISER

[FDibbins]

Hi and welcome to the forum

i would suggest you upload a sample work book, (all sensitive data removed), showing what data you are working with, a few examples of what your expected outcome is, and how you arrived at that
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[chugerknot]

I need to capture the data that is greyed out and populate a form with a dropdown list or button perhaps. I hope to capture only the list selected.


Thanks

[FDibbins]

I think you missed this part...

showing what data you are working with, a few examples of what your expected outcome is, and how you arrived at that

[chugerknot]

FDibbins........ "I think you missed this part
showing what data you are working with, a few examples of what your expected outcome is, and how you arrived at that"

Um-mm.. I'm not trying to be rude and I'm not sure I missed anything, but..if you open the example you will see.




List No: L312 Description: LVL 1 PULLS 256 Point List Pseudo


Point Custom Point Label Device Type Point Type


M1-55-0 LVL 1 Test point ADRPUL PULL
M1-62-0 LVL 1 Test point2 ADRPUL PULL
M1-68-0 LVL 1 Test point55 ADRPUL PULL
M1-95-0 LVL 1 Test point555 ADRPUL PULL
M1-109-0 LVL 1 Test point ADRPUL PULL
M1-145-0 LVL 1 Test point55 ADRPUL PULL
M1-147-0 LVL 1 Test point ADRPUL PULL
M1-148-0 LVL 1 Test point ADRPUL PULL


As well as several other lists of varying lengths.





How can I state this clearer?
The data I'm trying to capture reads like this.......

List No: L312 Description: LVL 1 PULLS 256 Point List Pseudo


Point Custom Point Label Device Type Point Type


M1-55-0 LVL 1 Test point ADRPUL PULL
M1-62-0 LVL 1 Test point2 ADRPUL PULL
M1-68-0 LVL 1 Test point55 ADRPUL PULL
M1-95-0 LVL 1 Test point555 ADRPUL PULL
M1-109-0 LVL 1 Test point ADRPUL PULL
M1-145-0 LVL 1 Test point55 ADRPUL PULL
M1-147-0 LVL 1 Test point ADRPUL PULL
M1-148-0 LVL 1 Test point ADRPUL PULL

..but sometimes the full list is longer so the solution needs to adjust for that.

Now, the data below this line "(List No: L312 Description: LVL 1 PULLS 256 Point List Pseudo)" this is what I need to automatically populate a form or a box or some way of consolidating the list I want to view and or print. Sorry I'm not sure what the end result will look like also I can not tell how it will get there maybe a macro or a formula I really don't care either way. Also if you view the attached file and look at the first page there is an example of the box I speak of. Its on the tab that reads FORM. So please tell me what more I can do to explain this clearer for the excel savvy people here. I would not be here asking for help on this if I were a pro and knew all the proper words to use. Again I'm not trying to be rude this is my best layman's explanation I can come up with.


Thanks to anyone who can help.

[chugerknot]

Got ya all stumped too I see.

[FDibbins]

All i see on sheet1 is "DATA HERE……Some how?"

If I missed something, sorry, but where did you put your sample answers?