Advertisement

07.18.2008 at 11:44AM PDT, ID: 23577800 | Points: 250
[x]
Attachment Details

Copy certain rows from an excel file and paste into all the excel files in a folder

Asked by Minnainsf in VB Script, Microsoft Excel Spreadsheet Software

Tags: Microsoft, Excel, 2000, Excel Macro

Hi,

I thought it must be a simple macro and tried to look for macro scrips on the web and could not find it so far.

I want to copy certain rows (A22:N24) from an excel file in "Sheet A" and paste into the same location in all the excel files ("Sheet A") in a folder.

I would save my time for searching if anyone could write me a script.

Thank you so much.

Minna

Start Free Trial
[+][-]07.18.2008 at 02:49PM PDT, ID: 22040099

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.18.2008 at 03:29PM PDT, ID: 22040368

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.18.2008 at 03:43PM PDT, ID: 22040448

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.21.2008 at 08:15AM PDT, ID: 22051275

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628