Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I am very new to Programming, I need assistance. Well, I have three columns in sheet one, [ date, name of MFR, no of documents], second sheet [has date, Name of MFR, No.of documents, and many more columns] but, my query is, every day, some Manufactures documents are downloaded, may be some 20 or 30 mfrs per day, those numbers need to be updated in sheet two every day, sheet two will have list of THOUSAND Manufactures ]...how do i go ahead updating it every day, can i automate it by using a macro or should i use ACCESS simple database, where i enter the value in sheet one every day, and it updates automatically based on date field. please advise. thanks, Nanda |