Hi, "workbook db" have names sheets (now i have 20). "Workbook day" it's
identical, but not necessarily 20 sheets.
Everyday i make a long table with many entries. each entry belongs to some
other name. I filter with a macro this table so the result is an workbook
with names sheets. Each sheet contain corespondent entry for each name. EX:
sheet John has 18 rows with etries, sheet Mary has 32 rows with entry...etc.
Ex: workbook day:
sheet john - 18 rows with information from this day (04.09.2009)
sheet mary - 32 rows with information from this day (04.09.2009)
.....
Ex: workbook db:
sheet john - rows with information from day (01.09.2009)
rows with information from day (02.09.2009)
rows with information from day (03.09.2009)
sheet mary - rows with information from this day (01.09.2009)
rows with information from this day (02.09.2009)
rows with information from this day (03.09.2009)
.....
I need to add information from this day (04.09.2009) from john to john; from
mary to mary......Workbook day contain today information, workbook db contain
information from the begining of the month, and at the end of each day to add
today to db.
Each sheet represent a name and contain informations for everyday.
Ex: John sheet- informations from 01.09.2009.....04.09.2009....30.09.2009.
Date problem. I don't have a column for date. After i copy from john to
john, i need the macro to add date to next row.
Like your 4 question:
4) If you have one worksheet per month to you want to just copy the data to
the last row of the worksheet?
YES, like this :
Ex: to john
rows with informations
01.09.2009
rows with informations
02.09.2009
rows with informations
03.09.2009........
3) If the sheet doesn't exist do you want to copy the worksheet from
"workbook day" completely into a new sheet in "workbook db".
YES. it's a great ideea. I like this ideea.
Sory i didn't explain more easily.
I can send you an email with the workbooks.
Thanks for you help!
"Joel" a scris: