LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 4th 17, 10:31 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
First recorded activity by ExcelBanter: Apr 2017
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.

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

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 03:13 PM
formula copies value from original cell only smaem Excel Worksheet Functions 2 March 20th 08 08: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 10:08 PM

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

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

About Us

"It's about Microsoft Excel"


Copyright © 2017