I have a tab called "Task Overview" with 2 columns. Column B has a
description in it, column A has a label such as Creative, Advertising, etc.

On my tab called "Data Input" in column F I have those same descriptions as
in the "Task Overview" tab. I'd like the cells in Tab B to auto populate the
labels from "Task Overview" (Creative, Advertising, etc). That way, if those
labels ever change, I only need to change them in the "Task Overview" tab and
they will automatically update the other tabs. I've been trying for hours, I
don't know what formula to use. Can someone help please??? : )

On Apr 7, 2:36*pm, KC <K...@discussions.microsoft.com> wrote:
> I have a tab called "Task Overview" with 2 columns. *Column B has a
> description in it, column A has a label such as Creative, Advertising, etc..
>
> On my tab called "Data Input" in column F I have those same descriptions as
> in the "Task Overview" tab. *I'd like the cells in Tab B to auto populate the
> labels from "Task Overview" (Creative, Advertising, etc). *That way, if those
> labels ever change, I only need to change them in the "Task Overview" tab and
> they will automatically update the other tabs. *I've been trying for hours, I
> don't know what formula to use. *Can someone help please??? : )

On the first cell of your data on your Task Overview sheet, starting
at the top number in column B (I'll assume B1), type

='Data Input'!F1

Changing the F1 to the topmost row of info on your Data Input sheet.
Using the fill handle, drag this formula down as far as the data in
the F column goes and it should automatically update.

HTH

~Shadow