#1
|
|||
|
|||
what method to find all cells paste linked to a certain cell ?
Hi,
I have a cell in which I enter months elapsed since calendar year started that I paste link to some sheets in my workbook to assist in working out average spending. I have a sheet named MonthsElapsed in which I alter the number when I remember to ! Having created a 2018 cell there I wish to move the link in these various sheets from the 2017 cell to the 2018 cell. I need to find where this number has been paste linked to. How is that done ? Its also useful to know for other paste links I have. DBenz |
#2
|
||||
|
||||
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 |