Populate Column

Melissa_

I have a sheet named GROCERYSTORE and a column named PRODUCE. 

I have another sheet named PANTRY and a column named VEGGIES. 

I want to reference column PRODUCE so those values are pulled into my VEGGIES column. If I later add a entry to the PRODUCE column, I want it to automatically show in my VEGGIES column.

Thank you in advance.

kioshi43

Are you working off of a set list of veggies and you're looking to do a count between the two?

Melissa_

Hi Kioshi43, Thank you for the reply. No, I don't need to do a count, I need to do a reference to an entire column.

Paul Newcome

Are you able to provide some mocked up screenshots with data manually entered that shows what you are working with and what you are hoping to accomplish?

Melissa_

Hi Paul - Thank you for your reply. Please see example below of how I would like to reference a column in another sheet:

Paul Newcome

Ok. What is the end goal for this process? Are you going to have multiple sheets pulling from the PRODUCE column or just the one?

Melissa_

Just the one sheeting pulling from the Produce column is all that is needed at this time. Thank you.

Paul Newcome

Have you looked into a report?

Melissa_

Yes, I did look into reports and they weren't a good solution. I would like to get this working within a sheet. If it's not possible within the program right now, I'll stop working on this issue. Thanks.

Paul Newcome

Why exactly do you need to replicate this column in another sheet like this?