Search results

OH I get it!!! O.k. makes sense. Wow that looks good. I will try it and let you know. /PureCoffee

I know some VBA. It doesn't scare me at any rate..:D. PureCoffee

Currently the Table is like this: Email(this is field1) Email_2(this is field2) purecoffee@gmail.com purecoffee@yahoo.com Here is what I would like to do: Email purecoffee@gmail.com purecoffee@yahoo.com Forget about all the other stuff that will be added...

I think what you want is to do a query that selects all records from the smaller tables to create a new "all together" table which in essence would replace the old table with the new data from the smaller tables... ?

Hi, To Clarify: 1) one large excel sheet containing ALL tables which means ALL field names from ALL tables match each other? 2) Not sure what you mean break it down. Do you want to normalize the data? /Purecoffee

Yes, this is correct. Thank you, PureCoffee

Sorry for not clarifying! Yikes! Yes, a little more background. I am attempting to normalize a "Flat Table". As an example; Record 1 under field "Email" and "Email_2" are filled in with different email addresses. So they belong to the person and I would rather have it so there is ONE field...

I have two cases of this. One with email the other with Category. What I would like to do is take the following: Email Email_2 Record--> purecoffe@gmail.com purecoffee@purecoffee.com (tblemail) Email EmailType Subscribe (checkbox)...