Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how the link of Excel is updated automatically using workgroup LAN | Excel Discussion (Misc queries) | |||
Keeping track of results of refreshed/updated data | Excel Worksheet Functions | |||
Need to track cells that haven't been updated | Excel Discussion (Misc queries) | |||
Link not updated everytime spreadsheet opened | Excel Worksheet Functions | |||
How to link a daily updated table data on website to Excel? | Excel Worksheet Functions |