Values from a range showing on another sheet if cell is not blank

[gokica]

Hello,

I have a file with two sheets.

In the first sheet there are 3 columns and many rows. The first column is left blank and the following two have values.

When a user populates a cell in the first column (which at the beginning is left blank) than the values from column 2 and 3 of that same row in which the populated cell belongs should appear in sheet 2.

An example:

Column A in sheet 1 is blank. Column B and C have values. When the user types "1" in cell A3 I need the values from B3 and C3 to be copied into sheet 2. If the user decides to type "1" in cell A5 than I need the values of cells B5 and C5 to be copied in the second sheet.

The user will be allowed to populate just one cell from column A at a time.

I tried the IF(ISBLANK - function but only works on the same row. If I like the result to show up in a different row or sheet than I receive #VALUE!.

Thank you so much for your help.

[mcmahobt]

Can you provide a sample workbook?

[boopathiraja]

Hil Welcome to the forum,

In b

Please Login or Register  to view this content.

In C

Please Login or Register  to view this content.

[boopathiraja]

Hi, Refer the atatchment

[gokica]

Can you provide a sample workbook?

Sure. Here is a very simplified one. Thank you.

Hi, Refer the atatchment

Thank you so much. It seems that the formula works by replicating the values on Sheet 2 on the equivalent row from Sheet 1. This is very helpful. I just wanted to add that I need the values from Sheet 1 into specifically defined cells in Sheet 2 and not the equivalents of Sheet 1. For example I need Cell A1 in Sheet 2 to show the value of Cell B15 in Sheet 1.

Once again thank you so much.

[mcmahobt]

Try this in cell B1 on Sheet 2:

Please Login or Register  to view this content.

Format as date.

Try this in cell B2:

Please Login or Register  to view this content.

Format as Currency.

Hope this helps.

[gokica]

Try this in cell B1 on Sheet 2:

Please Login or Register  to view this content.

Format as date.

Try this in cell B2:

Please Login or Register  to view this content.

Format as Currency.

Hope this helps.

This works like a charm. Thank you so much.