A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

formula that copies the formula of a cell in a diffrent spreadsheet.



 
 
Thread Tools Display Modes
  #1  
Old April 4th 17, 10:31 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default formula that copies the formula of a cell in a diffrent spreadsheet.

What I want is a master spreadsheet that I can update and have other 'satellite' spreadsheets copy the cell formula not the result of the corrisponding cell of the master. Basicly, I have made made a sheet and I want to distribute it amongst my employees so they can enter their own data; However, I want to be able to update differant cell formula and have each of theirs follow suite instead of needing to copy and paste a cell 50 times for every tweek I make. My thought was having the cells in the 'satellite' sheets refer to the formula in the 'Master Sheet' almost like a cell refferance but referancing the formula not result.
Ads
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy and Paste in Excel, copies cell and formula, but shows same v ipwil Excel Discussion (Misc queries) 3 January 26th 10 02:13 PM
formula copies value from original cell only smaem Excel Worksheet Functions 2 March 20th 08 07:42 PM
Drag Formula copies values instead TxVics Excel Worksheet Functions 2 July 21st 06 05:55 PM
Is There a Formula that copies another cell exactly in Excel? Dhbomb2k1 Excel Discussion (Misc queries) 3 July 6th 06 08:20 PM
Formula that perfectly copies data from another cell (with color)? Ron Wood[_2_] Excel Programming 1 November 1st 04 09:08 PM


All times are GMT +1. The time now is 01:20 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.