Automation Assistance

Posted on 2015-01-20
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
  • 2
  • 2
LVL 29

Expert Comment

Comment Utility
You want to bring the values or formulas as well into J to W ?

Author Comment

Comment Utility
Just the values.
LVL 29

Accepted Solution

gowflow earned 500 total points
Comment Utility
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

Comment Utility
Great help, and quick as well.....

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

This article explains in simple steps how to renew expiring Exchange Server Internal Transport Certificate.
A procedure for exporting installed hotfix details of remote computers using powershell
Viewers will learn a basic data manipulation technique of unpivoting data in Power Query for Excel 2013 and the importance of using good data. Start with data in a poor structure: Create a table on your data: Unpivot columns: Rename columns: …
Viewers will learn the basics of the new Quick Analysis feature in Excel 2013.

771 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now