If Month then...

Hi Guys
This forum seems very active so I just joined, I think I will get some great info here.
Im just a casual user of Excel but enjoy it very much.

I have a question that I did search and cant seem to find the answer for.

Here is my question
I have a "Data" sheet that I enter data in and another sheet that I display this data in.
The Data sheet is broken into several tables with the information
I would like Sheet1 to Display the most recent data from the Data Sheet while the Data Sheet retains all the past data

So in Sheet1 I have several cells that should be updated depending on which month it is, this data should be pulled from the tables in the 'Data Sheet'

So my 'Data Sheet' table looks like this:
Column1______Jan____Feb____Mar
Letter_____abc____def____blank
Number___123____456___blank
Data3_____111____222___blank

In Sheet 1 If the Month is Jan it would look like this
(A2)Letter = abc (DataSheetB2)
(B2)Number = 123 (DataSheetC2)
(C2)Data = 111 (DataSheetD2)

When the month is February would look like this
(A2)Letter=def (DataSheetB3)
(B2)Number=456 (DataSheetC3)
(C2)Data=222 (DataSheetD3)
etc

I hope that makes sense.

Thanks in advance!!

Hi dawolv & welcome to the forum,

It would help if you added a sample file...

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Glad we could help.

The formulas in post #6 pull the rightmost non-zero value.
The assumption was that in November, data will be populated in the November column and then that becomes the rightmost value (thus being pulled into the 'View' sheet).

If that solved your question, please mark this thread as SOLVED.