Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default How to report changes in a spreadsheet (not track changes)

Hi folks,

I have a spreadsheet with say products and their ID's and a column
with no. of customers who have purchased that product. This sheet changes
quite often and I was wondering if there's a way to say create a report of
all the changes (in a separate sheet if possible)
Now, the number of customers for each product could change, but also there
could be new products added to this sheet.
If I could have changes in say the 'product' and 'ID' columns in one sheet
and the changes in 'customer' column in another sheet it would solve another
issue although it's not very important.
I don't want to use Track changes since it gives the information in a more
random way when asked to produce a new sheet reporting changes.
Anyways, please help me if you can... desperately need this one

Thanks a lot in advance,

Epoch


Reply
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
to report change in wrksheet in another sheet, not usin track chan Epoch Excel Discussion (Misc queries) 0 June 26th 08 10:04 PM
Designing a spreadsheet to track workflow Karl Excel Worksheet Functions 4 October 12th 06 05:00 PM
Designing a spreadsheet to track workflow Karl Excel Worksheet Functions 0 October 12th 06 10:51 AM
Help with spreadsheet to track membership dues... bigtime Excel Discussion (Misc queries) 0 May 3rd 06 03:07 PM
I need to track my daily activities on a spreadsheet . Chic Charts and Charting in Excel 1 June 26th 05 04:24 PM


All times are GMT +1. The time now is 05:56 PM.

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

About Us

"It's about Microsoft Excel"