Compiling data in excel

Posts
1
Registration date
Friday June 15, 2018
Last seen
June 15, 2018
- - Latest reply: ac3mark
Posts
10909
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
December 7, 2018
- Jun 15, 2018 at 07:18 PM
Hello,

I am working with a large spreadsheet of contact information for people in my industry. I have columns titled with different interest areas for these contacts, with an "x" in the box of the corresponding row, to indicate that a contact has that interest. I would like to have different sheets that compile all contacts that have a given interest area. Is there a way to automatically transfer the information for a contact from sheet 1 (the sheet with all the contacts), to a different sheet for a specific interest area (sheets 2, 3, 4, etc.)?

Thank you!


See more 

Your reply

1 reply

Posts
10909
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
December 7, 2018
0
Thank you
"I am working with a large spreadsheet of contact information for people in my industry." 


That isn't what Excel is for. Excel is for calculations, not data keeping. Use a Database.

Are you familiar with the concept of a Database?

You store values in tables, then report on the values. Exactly what you are trying to do.

May I suggest, you use a value to store the area of interest, instead of just an X. That way you can survey your sampled base and see HOW interested, not just IF they are. Then you can report on users that are interested in a particular area, with a value of X; or N or better.

Just a thought!

If you choose to go the Excel route, it can be done, but how much coding experience do you have? If you have none, then I would suggest learning the concepts of a Database!

Then just write reports on tables. No Coding Needed!

Respond to ac3mark