• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

all you excel experts looking for some help

M

MrPShah

Member
looking for a way to do a vlookup dynamically. Basically, everday I have a spreadsheet that needs to link to values from a spreadsheet created the prior day. Then tomorrow I will have the same spreadsheet link to today's values, and so on and so forth. Now, this obviously works as a normal vlookup, but then tomorrow, it will pull in not today's values(which are the prior day's), but instead it will pull in the prior prior. Is there a way I can automate the links to know that it needs the prior day's sheet for every day going forward?
 
Maybe use a macro to look at the new cell range for the current days data and replace that range in the existing formula?
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top