-
Re: I need to create a "Favorite search" that has almost a thousand drawing numbers, is there a way to paste all the numbers into a search list? I currently have to paste them one at a time into the variable value cell!
Create a formula in Excel and copy and paste from there.
-
Re: I need to create a "Favorite search" that has almost a thousand drawing numbers, is there a way to paste all the numbers into a search list? I currently have to paste them one at a time into the variable value cell!
I already have the spreadsheet with all the drawing numbers, the problem is that Search will not let me paste the entire list at once. I have to copy and paste each number one at a time into the value cell after choosing the variable.
-
Re: I need to create a "Favorite search" that has almost a thousand drawing numbers, is there a way to paste all the numbers into a search list? I currently have to paste them one at a time into the variable value cell!
I would create a search card with that variable as a text box.
Then in Excel, create a space separated list from your drawing number column. This solution would work, just replace the comma with a space. Then all you need to do is copy and paste from Excel into your textbox.
-
Re: I need to create a "Favorite search" that has almost a thousand drawing numbers, is there a way to paste all the numbers into a search list? I currently have to paste them one at a time into the variable value cell!
We do this frequently.. it would look something like this:
Once you have the formula typed in... just drag and copy it to the cells below it. You should see your list grow, each part number with space between the next. then copy the long list of the last cell and paste it into the EPDM search.
Hope that helps!
-
-
-
-
Re: I need to create a "Favorite search" that has almost a thousand drawing numbers, is there a way to paste all the numbers into a search list? I currently have to paste them one at a time into the variable value cell!
Hi Kirk, I'm just curious why do you need this? Maybe there are other simpler ways to get what you need?
