Solved

Automation Assistance

Posted on 2015-01-20
4
68 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 29

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 29

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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

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…
Video by: Zack
Viewers will learn about various customizable options in Excel 2013.
Viewers will learn how to create a PivotTable and make basic changes to it in Excel 2013.

726 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