copy a cell from 1 file to another when data changes

		Microsoft Office Forums > Microsoft Excel > Excel
copy a cell from 1 file to another when data changes

FAQ

Thread Tools

Display Modes

01-19-2016, 08:50 PM

macropod

Windows 7 64bit copy a cell from 1 file to another when data changes

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,359

The number of analysis sheets is of no consequence; it's how they're configured with formulae, etc. to reference the data sheet that matters. Correctly done, you might at most need a single cell somewhere to set the year value (or two cells to set a date range) for all the analysis sheets.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copy calendar to outlook data file	Alpas83	Outlook	0	05-04-2015 10:31 AM
Copy matching data from one report cell to another cell report	mbesspiata	Excel	9	01-15-2015 01:49 PM
copy data from outlook attached excel file into a local one	s_samira_21	Outlook	4	09-17-2014 11:46 PM
How to copy automatically data from Excel file to Word file?	fuchsd	Word	6	10-25-2011 05:52 AM
Copy all comments & cell contents (i.e. data) to word?	IanM	Excel	0	07-03-2010 11:14 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:44 AM.