View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tony Tony is offline
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