Display history for spreadsheet data

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Display history for spreadsheet data

FAQ

Thread Tools

Display Modes

04-23-2012, 03:58 PM

macropod

Windows 7 64bit Display history for spreadsheet data

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,521

Hi cjaye,

What I said was:

Quote:

You should consider having all the data on a single sheet and, on another sheet, the formulae used for reporting.

With this approach, no macros are needed - it's simply a matter of re-writing the formulae so that they summarize the appropriate month's data from the data sheet. Plus, there's no need to hide anything and, in the longer term, you'll end up having more data for trend analysis, etc.

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

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Displaying cell data in another spreadsheet	Colonel Biggs	Excel	0	07-01-2010 07:37 PM
Client Payment History	GMatos78	Office	0	04-22-2010 03:40 PM
Data Set Display Size - PP 2007	TonyMan	PowerPoint	1	04-14-2010 05:45 AM
Displaying data from spreadsheet in Userform	darklide	Excel	0	03-12-2010 05:42 AM
CAUTION!! Sorting a spreadsheet with hidden columns will trash your data.	psmaster@earthlink.net	Excel	0	11-24-2009 11:54 AM

Other Forums: Access Forums

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