Hello.
I'm looking for a macro which does the following in the following order:
1. Updates Cell B2 on three worksheets names ('A','B' and 'C') with a =NOW() formula (to give a snapshot of when data has been refreshed).
2. Refreshes the workbook connections to SQL server.
3. Refreshes a single pivot table called 'LISTED' on a tab named 'PIV'
Many thanks for any help.
Some suggestions you may fund useful:
- Our answerers are looking to "help" more often than they are looking to "do an entire project for you for free".
- Jump into this project yourself, when you get stuck on ONE specific hurdle, post that ONE item as a forum question.
- Show us what you've tried in an attached sample workbook and how it's not working for you. When you're doing the work yourself, just writing out a complete example question in a forum often points you to solution before you even finish posting.
- If you can't make any headway at all and no help is forthcoming in the free forum(s), we do have a Commercial Services forum where you can pay for assistance directly from our EF gurus."
Sorry Pepe - I work in a hospital and am trying to make a few of our planning tools a bit easier for the clinicians to use and have some live data. I was rushing / wrongly assumed that what I was asking was going to be a very quick job for someone more skilled, but will give it a go over the weekend.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
RollingStone88 
Register To Reply
Bookmarks