Cannot associate info. from one cell to another, repeatedly

[ashvin83]

Hey guys,

I'm trying to associate information from a cell of one column to a cell of another column of the same row. An example is below:

cell A1: x
cell B1: y

This would be easy to do if i had just one set of these associations (and not necessarily just x and y) but given that I will likely have up to a thousand, I need an alternative to copying and pasting. I looked into macros but no luck there. By the way, i'm using 2003.

[NBVC]

Welcome to the forum,

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

PLEASE PM WHEN YOU HAVE DONE THIS AND I WILL DELETE THIS POST

[Rahul Nagar]

Hi

Can you please attach the sample file for more details?
And please give us the result what you want in that file.

Regards
Rahul

[ashvin83]

Hi Rahul,

I've attached an xls file in which I put a comment. It will give you a simplified understanding of what I'm trying to do.

Thanks,
Ashvin

[NBVC]

You can easily use Autofilter.

Go to Data|Filter|Autofilter.

A bunch of drop down arrows will occupy top row.

Go to column M and select "Unquarantinable.... etc", then go to column B and select "Tracheophyta"..

This will be your filtered list.

You can copy/paste it elsewhere if desired.

[ashvin83]

The top down arrows stop at column G. From the instructions you put, I don't think this is supposed to happen. Any ideas?

[NBVC]

Then select the entire range first including the headers.. then invoke the filtering.... you must have blank columns or something not normal

[ashvin83]

Then select the entire range first including the headers.. then invoke the filtering.... you must have blank columns or something not normal

Ok, I got filtering figured out but I wanted to do is get excel to associate data that's in a given cell with another data-containing cell, automatically. I guess i didn't explain myself enough, so here's an example.

F1 contains family name. L1 contains pest type.

I want excel to remember this association so that when I enter a family name (in any given row) along with a pest type, the next time I enter this family name excel will have stored this association and will enter the pest type on its own. I'm thinking that an "if then else" rule may apply here. What do you think?

[NBVC]

I think that will involve macros.. which is not my strength...

If you want something stored in memory, you will need macro to "call" it.

If you have a separate table of unique families vs. pests, then you could use a Vlookup type formula to lookup the pest once you enter the family... this will not involve any macros.

[ashvin83]

I think that will involve macros.. which is not my strength...

If you want something stored in memory, you will need macro to "call" it.

If you have a separate table of unique families vs. pests, then you could use a Vlookup type formula to lookup the pest once you enter the family... this will not involve any macros.

This is getting too complicated for the work at hand. I'm gonna give you props 'cause you provided good suggestions. Thanks!