Automation Assistance

Posted on 2015-01-20
Medium Priority
Last Modified: 2015-01-21
The attached spreadsheet has a detail section and a summary section.
Summary is from Column J to W
Detail section is from Column AG to GA
The columns are static and will not change.
Cell C2 has the Key Date.
I am trying to figure out a way that when the user changes the date in C2, the detail section would change the HLOOKUP so that the dates and values would align so the key date would be in the current week range (Columns Q to W) and previous week would be in Columns J to P.
Question by:DougDodge
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
LVL 31

Expert Comment

ID: 40561445
You want to bring the values or formulas as well into J to W ?

Author Comment

ID: 40561675
Just the values.
LVL 31

Accepted Solution

gowflow earned 2000 total points
ID: 40562676
Is this what you want ?
Enable macros and change the date in C2 and see how it changes the whole data last week this week. Were not able to test real data as you hv blanks all over except for date but if you plug your figures I guess it will reveal !!!

It is all based on Cell C2 and C3 I fixed formula on cell C3 it was wrong. so pls do not change those 2 cells (I mean they need to be c2 and c3

AH by the way I stopped this hiding process that is non sense (if date = to today hide columns) it keep flickering and its useless and annoying) If you need it we can code something.

Author Closing Comment

ID: 40562902
Great help, and quick as well.....

Featured Post

What’s Wrong with Your Cloud Strategy ?

Even as many CIOs are embracing a cloud-first strategy, the reality is that moving to the cloud is a lengthy process and the end-state is likely to be a blend of multiple clouds—public and private. Learn why multicloud solutions matter in this webinar by Nimble Storage.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
: Microsoft Office Collaborate for free and online versions of Microsoft  Word, Excel, Powerpoint, OneNote, Onedrive , Email, Calendar etc. In short we can say that Microsoft office is a suite of servers, applications and services developed by  Micr…
Viewers will learn a basic relationship technique in Power Pivot for Excel 2013.
Viewers will learn the basics of printing in Excel 2013 and how to adjust some common settings.

649 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question