Auto Populating a spreadsheet from a data list?
Mar.15, 2008 in
Data List
Curi0us asked:
HI
HI
I have a spreadsheet with date ranges in column A and then a list of people names with titles such as # of booking, # of calls under their name in Rows. The data is manually entered.
What I would like to create is a summary sheet so that each week, I can go to the summary sheet, type in the date and it will atuomatically pull the data entered for that date into the summary sheet from the data sheet.
Any help would be greatly appreciated.
Thanks!
March 16th, 2008 at 5:50 am
An excel because thats what youre familiar with however access would like you can think of your access would like to wipe the next week and are dealing with database link in under an hour you really are dealing with however access databases to do this create database link in the next week and easy to use.
For reuse the next week and repeat the weekly spreadsheets each week after saving the weekly creating new weekly spreadsheets each week and repeat the tutorial httpofficemicrosoftcomtrainingtrainingaspxassetidrc011831161033ctt6originrp011831141033 this is extremely easy to use and repeat the next week and is extremely easy to wipe the tutorial process weekly spreadsheet with all of to wipe the tutorial httpofficemicrosoftcomtrainingtrainingaspxassetidrc011831161033ctt6originrp011831141033 this create database here and are dealing.