Thanks, guys !!
I think what you've posted will help considerably. To clarify, in case there are better options once clarified:
I have data in column A (variable number of rows). I have functions in cells B3 and C3. I have a function in cell E3 that utilizes the info in cell D3. I was hoping to insert a defined function in cell D3 that accomplishes what the posted macro is designed to do: copy values only from cell C3.
(I see in the preview that my "columns" below are going to get lost in the forum, but I think the intent will be evident
Before Sorting on Column D:
A B C D E
BA33.DXF BA33 33BA 33BA BA33
BA34.DXF BA34 34BA 34BA BA34
BB33.DXF BB33 33BB 33BB BB33
After Sorting on Column D:
A B C D E
BA33.DXF BA33 33BA 33BA BA33
BA34.DXF BA34 34BA 33BB BB33
BB33.DXF BB33 33BB 34BA BA34
Column A are filenames pasted from clipboard, typically 500 rows, for example.
Column B has the extension stripped from the filenames.
Column C inverts the filename which is actually a part name.
Column D should be the
value obtained from the formula in column C.
Column E is the part name put back together correctly.
Columns B & E are the sorted data that I will work with.
Columns C & D could actually be eliminated after B & E are obtained, but I prefer to see the intermediate steps.
I use the spreadsheet, among other things, to sort column D, which produces Column E sorted by number rather than by alpha character. This is done, because ba33, for example, is a part that is detailed on sheet 33. I need my list sorted with parts on the same sheet grouped together before proceeding to parts on the next sheet.
If I were able to insert the required function into cell D3, I would need only to highlight cells B3 to E3 and autofill down to accomodate whatever data is in column A.
If you see a way to define a function in this way, and could post it, it would be greatly appreciated. Otherwise, the posts you have already made will be a great help to me.
Thank you very much !!!