Prev: can i sort certain entries from a big excel sheet
Next: MS Query problem
From: WLMPilot on 13 May 2010 06:52
Within the QA Master workbook, the boss will have a list of questions
(criteria) that will be mirrored in all employee workbooks and the QA
Template. If the boss adds a criteria in the QA Master workbook, I need to
add it to the QA Template workbook and all employee workbooks so he does not
have to go through 80+ workbooks individually. If you can provide the code to
do this for one cell in QA Master and place it in QA Template, I believe I
can figure out how to
get it to the employee workbooks.

Also, will I need to open each workbook in order to place the new criteria
into it or can they all remain closed?

A variable will hold the value of the workbook that I will place the data in.

Thanks,
Les
From: Ron de Bruin on 13 May 2010 16:16
Hi Les

See
http://www.rondebruin.nl/copy4.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm



"WLMPilot" <WLMPilot(a)discussions.microsoft.com> wrote in message news:E1197543-F687-4429-A323-711FCFEE1D0A(a)microsoft.com...
> Within the QA Master workbook, the boss will have a list of questions
> (criteria) that will be mirrored in all employee workbooks and the QA
> Template. If the boss adds a criteria in the QA Master workbook, I need to
> add it to the QA Template workbook and all employee workbooks so he does not
> have to go through 80+ workbooks individually. If you can provide the code to
> do this for one cell in QA Master and place it in QA Template, I believe I
> can figure out how to
> get it to the employee workbooks.
>
> Also, will I need to open each workbook in order to place the new criteria
> into it or can they all remain closed?
>
> A variable will hold the value of the workbook that I will place the data in.
>
> Thanks,
> Les
 | 
Pages: 1
Prev: can i sort certain entries from a big excel sheet
Next: MS Query problem