Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple Inputters into file - Need help
Please...I'd like advice on the most straightforward way of tackling an
upcoming project. I am someone who is pretty good with excel formulas and functionality, but don't know VBA or programming. Here's the situation: Regular reports need to be run on various training data. Data is needed from 30 different trainers who will be providing this data at the end of each week. This file or files will reside on a shared drive. Options: 1) Do I create a masterfile, and manually create (hundreds of) links to 30 input files, one per trainer? 2) Do I create 30 trainer files, and then do some type of file merge each week? 3)Do I create ONE big file with twelve month tabs, that everyone keeps adding to? Concerns: Option 1- I don't have access to that shared drive - I'll have to be creating the work and sending it by email. Would the links still work? This is also very laborious. Option 2- A bit cleaner. Can I merge 30 different files if they're all formatted in the same way? Could a macro be written that will do this merge in the same way every time? Could the "merge into" file have some extra tabs where the reports would reside? Option 3 - The simplest of all. But - I'm afraid of what will happen if more than one person is inputting at the same time. What will happen if two people are trying to enter something on to the same next blank row?! Thank You SO much!!!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import txt file with multiple rows for each record | Excel Discussion (Misc queries) | |||
Multiple columns of data saved in a CSV file appears in a single c | Excel Discussion (Misc queries) | |||
How do I keep file sizes small when using multiple pivot tables? | Excel Discussion (Misc queries) | |||
How to pull data out of an excell file with multiple tabs | Excel Worksheet Functions | |||
Why does Excel create multiple copies of the same file? | Excel Discussion (Misc queries) |