Hello
My 1st post.
I am pretty good at excel, but not good at macro programming.
Trying to create a spreadsheet with a couple of things going on so hopefully I will explain it well.
-Have a datatable with 6 columns and data in one of the columns repeats frequently
-Have several different tabs labeled as the frequently repeated data (6 total)
-Have another tab labeled "other" which will store data not corresponding to the other 6 tabs.
My desire is to have one spot for new data entry (6 columns worth) and have it sort the new data (based off of one column of data that frequently repeats) into one of the existing tabs. This data needs to be copied into the next available line in these preexisting tabs as well as a copy into an "universal" tab that holds all the data that has been entered.
Its like a complex search and "copy if new" type of functionality.
Not even sure if this could be done, and if it can would I be qualified enough to do it.
Like I stated before, I'm pretty good @ excel but not excellent.
Thanks in advance for any help I receive.
My 1st post.
I am pretty good at excel, but not good at macro programming.
Trying to create a spreadsheet with a couple of things going on so hopefully I will explain it well.
-Have a datatable with 6 columns and data in one of the columns repeats frequently
-Have several different tabs labeled as the frequently repeated data (6 total)
-Have another tab labeled "other" which will store data not corresponding to the other 6 tabs.
My desire is to have one spot for new data entry (6 columns worth) and have it sort the new data (based off of one column of data that frequently repeats) into one of the existing tabs. This data needs to be copied into the next available line in these preexisting tabs as well as a copy into an "universal" tab that holds all the data that has been entered.
Its like a complex search and "copy if new" type of functionality.
Not even sure if this could be done, and if it can would I be qualified enough to do it.
Like I stated before, I'm pretty good @ excel but not excellent.
Thanks in advance for any help I receive.