dukeofscouts
Board Regular
- Joined
- Jan 19, 2009
- Messages
- 146
ok long story short:
-I currently use a macro to insert date for an entry in to a database. Part of that entry is states what kind of entry it is. I use the sort function to sort the datebase by this field.
-I have a series of Pivot tables set up that show for each type, what entries are under that catgorie. Each time I run the macro to insert the new record. I have set that the pivot tables update and thus as the new record enters the database and is sorted to mach the type field, the corrisponding pivot table also shows a new entry.
- I have se that each pivot table list is a name. However, I would like to have the range expand as I enter new records automatically.
I've heard that there is a VBA code that will do this. Does any one happen to have it?
Thank you in advance,
DukeofScouts
-I currently use a macro to insert date for an entry in to a database. Part of that entry is states what kind of entry it is. I use the sort function to sort the datebase by this field.
-I have a series of Pivot tables set up that show for each type, what entries are under that catgorie. Each time I run the macro to insert the new record. I have set that the pivot tables update and thus as the new record enters the database and is sorted to mach the type field, the corrisponding pivot table also shows a new entry.
- I have se that each pivot table list is a name. However, I would like to have the range expand as I enter new records automatically.
I've heard that there is a VBA code that will do this. Does any one happen to have it?
Thank you in advance,
DukeofScouts