|
|
#2
06-28-2018, 12:16 PM
|
||||
|
||||
If, for example, you placed you value in cell D4 of the sheet then your links would all look like:
=MonthsElapsed!$D$4 so do a search for these cells (Ctrl+f to bring up the Find dialogue): Then you can click Next repeatedly which will jump to the cells one at a time, and while the dialogue box is still open you'll be able to drag or edit the cells concerned, then click Next again. Or you can Find All and work your way down the list with the mouse. Oh, I forgot, you've got to Look in: Formulas 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| for visible cells (filtered), how find value lowest than 4.00 and return the cell number | murfy69 | Excel | 6 | 08-03-2017 12:03 AM |
| Select Cell Text to paste into Find/Replace | CBarry | Word VBA | 2 | 02-16-2017 04:37 AM |
| Trying to find a macro that will copy a cell and paste that value to a specific sheet | bryans88 | Excel Programming | 1 | 12-23-2015 01:40 PM |
| Lock Linked Cells And Unlinked Cells In A Row | paulkaye | Excel | 5 | 07-14-2014 10:20 PM |
 Doing a linked paste within a linked spreadsheet
|
tkondaks | Word | 1 | 08-17-2012 12:23 AM |
Windows 10 
Office 2016
Threaded Mode