Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default Trying to keep track of updated link data in an excel spreadsheet

Hi everyone,

I am new to this, so bear with me.
At work we are switching to using an enfold desktop type filesharing
system, and I am housing a testing results spreadsheet that looks at
all other sheets (using links) and updates the cells upon opening. I
am using a simple link to the URL since these are on a web server.
When the page opens, I click update, and it populates the dates tested
for each piece of equipment. Is there anyway I can:
1) track these changes after updating?(i.e. once update is hit, all
new changes are flagged)
or
2) sort all the new changes (by last column in each row) with the most
recent testing dates at the top?

And possibly do both of these at once?

I am fairly new to this VBA thing and had this thrown in my lap, any
help would be appreciated. I have searched and not found much that I
can use/understand!

Thanks!
Tony

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
how the link of Excel is updated automatically using workgroup LAN Excel link updated through LAN workgroup Excel Discussion (Misc queries) 1 October 22nd 06 03:30 PM
Keeping track of results of refreshed/updated data vitaleca Excel Worksheet Functions 1 August 3rd 06 03:45 AM
Need to track cells that haven't been updated telewats Excel Discussion (Misc queries) 2 January 24th 06 07:16 PM
Link not updated everytime spreadsheet opened Olivier D. Excel Worksheet Functions 0 September 28th 05 01:48 PM
How to link a daily updated table data on website to Excel? heatwave Excel Worksheet Functions 0 August 8th 05 01:50 PM


All times are GMT +1. The time now is 08:49 PM.

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

About Us

"It's about Microsoft Excel"