Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-27-2018, 03:46 AM
DBenz DBenz is offline what method to find all cells paste linked to a certain cell ? Windows 7 64bit what method to find all cells paste linked to a certain cell ? Office 2010 32bit
Advanced Beginner
what method to find all cells paste linked to a certain cell ?
 
Join Date: Dec 2014
Posts: 48
DBenz is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 06-28-2018, 12:16 PM
p45cal p45cal is offline what method to find all cells paste linked to a certain cell ? Windows 10 what method to find all cells paste linked to a certain cell ? Office 2016
Expert
 
Join Date: Apr 2014
Posts: 528
p45cal is a splendid one to beholdp45cal is a splendid one to beholdp45cal is a splendid one to beholdp45cal is a splendid one to beholdp45cal is a splendid one to beholdp45cal is a splendid one to beholdp45cal is a splendid one to behold
Default

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
Reply With Quote
Reply

Thread Tools
Display Modes


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
what method to find all cells paste linked to a certain cell ? Doing a linked paste within a linked spreadsheet tkondaks Word 1 08-17-2012 12:23 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:03 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft