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

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

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.
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
Viewers will learn how to customize the ribbon and quick access toolbar in Excel 2013.
Video by: Zack
Viewers will learn the basics of using Excel Tables, the benefits found with them, and some pitfalls.

762 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