What I've done is do the summary in a different workbook, with linked data, that is closed when I update the table. Close the table book and open the sumary book. The links will still be intact.
I want to be able to use "drag and drop" editing to move data in a spreadsheet, but I would like the formulas that access the data to pick the data from the same place.
The application is a project tooling budget by part and by month. When the schedule moves, I would like to simply...
Interested in another approach? Instead of using "text to columns", make a new column with the following formula in it:
=MID(A1,FIND(" ",A1)+1,20)
Assuming your names are in column A, this finds the space in the name and uses text from that point on to fill the new column...
