Thread: [Solved] Importing/Exporting data using Excel and some specific rules
View Single Post
 
Old 03-27-2014, 08:58 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
The workflow, with a separate sheet for each week, makes this unnecessarily difficult. Given that a single Excel worksheet can handle 1,048,576 rows, there is no good reason all the data can't go onto one sheet from where extraction would be a simple task. On top of that, you're trying to use Excel as both a database and a database report generator, a task for which Access is much better suited. With all the data on a single Excel sheet, though, report generation via mailmerge would be a reasonable alternative.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote