Auto-populate specific data from one sheet to another

**fowlspace** · 06-05-2012, 11:28 PM

Hi everyone,

I've been searching high and low for help regarding this issue. I am somewhat green with Excel, but have been self-teaching as I need to figure things out. This one is a real stumper for me, but to be clear, I'm not any kind of programmer. I wrote (read copied) my firs Macro this afternoon.

I have attached my file here, and what I have is a workbook with 5 primary sheets. This workbook is essentially a donations database including information on each kind of donation contact. One page is a universal mast page that includes every type of donation, but I would like to also have the four other sheets populated by the data but by specific criteria. For instance, there is one donation type called "In Kind," and I have a separate sheet called "In Kind," too. For every time that I input a new In Kind donation type into the "Universal" sheet, I want it to automatically populate all the data in that row associated with that In Kind into the In Kind Sheet. (I'd like all the pieces of information in that row in the Universal to simply be copied over to the In Kind Sheet.)

You'll noticed that under the "Donation Type" column, some cells include multiple types (ie. In Kind, Sponsorship). In this case, I would want the data in that row to be copied to both the In Kind sheet and the Sponsorship sheet.

Any help I can get would be amazing!!
Thanks!

**npamcpp** · 06-05-2012, 11:48 PM

Why do you want to duplicate the data? That is not good practice. What happens if data in the Universal sheet changes? What happens if data gets changed in one of the other sheets?

You could enable autofilter on the Universal sheet and then filter the data by donation type. Since there may be more than one value in a cell, you can use the text filter with the "contains" option.

If you keep only one copy of the data, you know that you have only one version of the truth. duplicating the data over multiple sheets will be a very bad idea.

**fowlspace** · 06-05-2012, 11:51 PM

Ultimately, we want to be able to input the data to keep long-term, but use the separate sorted sheets to reference for creating different mailings based on the donation type. It just is organizational preference.

**arskiracer** · 10-17-2012, 06:48 PM

I'm interested in this as well. I handle failure analysis activities in R&D at my company and there are many different excel sheets that are owned by different individuals and each have various types of useful information about failure modes, locations, root causes, tracking numbers, etc. There is a shared spreadsheet that needs to be updated for feedback to management and I am trying to create a way for it to update itself so that I don't have to waste time copying and pasting information all the time. Ideally we need a database, but it's almost impossible to get new software approved through IT in under a year. In addition, R&D is only handling FA temporarily, so spreadsheets work for now.

I only handle failures that are assigned to my name. I want to use some type of VLOOKUP to find the row of a specific tracking number and then have it fill in other cells from that row with data that is present in another worksheet in the same workbook which I've setup to query data from my own workbook. Any ideas? I'm hoping the response won't be a visual basic solution, but if so I'll have to learn how to use visual basic and where to type the code in my workbook.

Thanks,
Adrian

**Cutter** · 10-17-2012, 09:19 PM

Hello arskiracer, and welcome to the forum.

Unfortunately you have inadvertently broken one of the forum rules. Please read the following and make the necessary change. Thanks.

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.