R
ralph
I have a workbook with 2 worksheets, 1 sheet is a simple summary showing the
current months data and the ytd data (the month would be input by the user)
as below. The second sheet will have the month by month information and the
ytd.
How do I get it to lookup according to month inputted and then pick up the
correct corresponding data
WORKSHEET 1
Enter Month "Apr"
Month YTD
Metric 1
Metric 2
metric 3
WORKSHEET 2
Jan Feb Mar APr....... YTD
Metric 1
Metric 2
Metric 3
thanks
Ralph
current months data and the ytd data (the month would be input by the user)
as below. The second sheet will have the month by month information and the
ytd.
How do I get it to lookup according to month inputted and then pick up the
correct corresponding data
WORKSHEET 1
Enter Month "Apr"
Month YTD
Metric 1
Metric 2
metric 3
WORKSHEET 2
Jan Feb Mar APr....... YTD
Metric 1
Metric 2
Metric 3
thanks
Ralph