Solved

Automation Assistance

Posted on 2015-01-20
4
69 Views
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.
SITE-PROGRESS.xlsm
0
Comment
Question by:DougDodge
[X]
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
4 Comments
 
LVL 30

Expert Comment

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

Author Comment

by:DougDodge
ID: 40561675
Just the values.
0
 
LVL 30

Accepted Solution

by:
gowflow earned 500 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.
gowflow
SITE-PROGRESS-V01.xlsm
0
 

Author Closing Comment

by:DougDodge
ID: 40562902
Great help, and quick as well.....
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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 the different options available in the Backstage view in Excel 2013.
Viewers will learn a basic relationship technique in Power Pivot for Excel 2013.

729 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