i have a file that has 2 worksheets in it. one is the data entry tab the other is the data base tab. the data entry tab has information entered in it throughout the day. i need to extract that information daily at 6pm to get the final entries andput it in the data base sheet in a new column to keep a running total of these numbers. ok…the data entry sheet is wiped out everymorning to start the new day. the data base field has more than 500 part numbers in it. i need the running totals to access the data entry sheet every afternoon and look up what part numbers are listed there then get the mold totals from a column in the data entry sheet that corresponds to that part number and put them in the data base totals column, and do thisdaily without the totals column losing the original number brought over each morning when they wipe out the data entry sheet. bottom line i need to keep a running total on mold totals by part number, and do this when the daily numbers are wiped outevery morning. if this is not confused everybody…i would appreciate any help…thanks
steve
