Generating a report list and statistic worksheet in Excel from other workbooks

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hello-

I am trying to put together a reporting function, and I have little
experience working with Excel programming. I have multiple workbooks
set aside for different users, who update the information in list
format on a daily basis. These are project lists, so they require
daily text and numerical input, and the length of the lists vary as the
projects close or open. I am trying to make a master workbook that
brings all of these lists together onto a single list. On this master
workbook is a worksheet that needs to update and add a row of
statistical data on a daily basis. Additionally, it would be nice to
add a macro button to these update worksheets, so when they are moved
from "open" to "close", the entire row is moved to a new worksheet
called "Closed Projects". How should I start on this?

Thanks

.

Relevant Pages

  • Re: Show do I share a dynamic list for data validation?
    ... KarenF wrote: ... "Dave Peterson" wrote: ... If the lists only change when you're doing the import--the user or you don't ... Dim MstrNamesWkbk As Workbook ...
    (microsoft.public.excel.misc)
  • Re: Show do I share a dynamic list for data validation?
    ... tells me it can't use a range from another sheet or workbook. ... Then each time workbook2.xls opens, it opens workbookA.xls, copies the data and ... lists into each workbook when the workbook opens is a good one. ... recording a macro to copy and paste the master lists' data into the ...
    (microsoft.public.excel.misc)
  • Re: Show do I share a dynamic list for data validation?
    ... tells me it can't use a range from another sheet or workbook. ... Then each time workbook2.xls opens, it opens workbookA.xls, copies the data and ... lists into each workbook when the workbook opens is a good one. ... recording a macro to copy and paste the master lists' data into the ...
    (microsoft.public.excel.misc)
  • Re: Show do I share a dynamic list for data validation?
    ... KarenF wrote: ... "Dave Peterson" wrote: ... tells me it can't use a range from another sheet or workbook. ... I've already created the lists as per ...
    (microsoft.public.excel.misc)
  • Re: Show do I share a dynamic list for data validation?
    ... "Dave Peterson" wrote: ... tells me it can't use a range from another sheet or workbook. ... Then each time workbook2.xls opens, it opens workbookA.xls, copies the data and ... I've already created the lists as per ...
    (microsoft.public.excel.misc)