Auto Populate Text

K

KC

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??? : )
 
S

shadow4166

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top