Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations MintJulep on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: tcampbe1
- In -Engineering spreadsheets
- Content: Threads, Posts
- Order by date
-
Lock excel formulas from changing
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.- tcampbe1
- Post #2
- Forum: -Engineering spreadsheets
-
Drag and Drop
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...- tcampbe1
- Thread
- Replies: 8
- Forum: -Engineering spreadsheets
-
Excel column join
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...- tcampbe1
- Post #3
- Forum: -Engineering spreadsheets
