Consolidate Data from Multiple Forms

[FinancialBalance]

Hello,

I am trying to make a contact sheet for my business leads and need to take select information from columns on one sheet and enter it on another. There are also two columns for addresses (business and personal) which have to be organized (person who input data put all the addresses as personal, but there are business addresses listed in this section as well). I have been doing all of the input manually for the past few hours and want to figure out a formula to automate this process. Can anyone point me in the right direction to do so or possibly offer advice? I have a basic understanding of excel (used it extensively in college, but did not study vba or coding).

I can send you the data sheets to make it easier to see what I am talking about, but would prefer not to post because of sensitivity of information.

Thank you.

[Leith Ross]

Hello FinancialBalance ,

Welcome to the Forum!

How would a business address be distinguished from a personal address?

[FinancialBalance]

Thanks Leith! If the business address matches one of the addresses within a list of ten then it would need to be transferred from the personal address column to a business address column. Essentially, there are multiple locations for one business, but the person who input the data put all of the addresses in the personal column. I appreciate your help.

[jaslake]

Hi FinancialBalance
Please post some sample data (6 to 10 data items) in the same structure and data types as your actual file so we can get a picture of what you have. Include a worksheet of what you'd like it to be...cleanse the data of confidential information. Perhaps one of us can help