You are reading a single comment by @cyberyark and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
cyberyark
I’m writing some VBA to automate a process I’ve inherited at work. It involves updating a couple of ‘master’ excel files with various bits of data from a scheduled Business Objects report which is then compared with previous year data pulled from archived reports. There is one part that has me stumped, and I’d be grateful for any suggestions – I’m fairly new to VBA so it’s likely I’m missing something obvious.
One sheet has a column on the left hand side populated with week-beginning dates. I need to find a way programmatically to look for the date in said column closest to “today’s” (as in the day I’m running the process) date and then populate a corresponding cell with a value from the scheduled report. I’ll be running the process on a Monday, apart from on bank holidays.
So for example when I run it next Monday it would find “today’s” cell (or the nearest preceding one) which happens to be A44 (4/7/16) and populate Q44, Z44, AI44 and AR44 with various values from the scheduled report.
Any ideas?