Prev: macro pointing to wrong folder
Next: Simplifying an If(OR(…)) statement
From: Gringarlow on 16 Mar 2010 12:13
I know very little about VBA and the only way I have created Macros is by
having Excel follow my mouse and Recording the Macro, then modifying the
reults as needed.
Here is what I've been asked to do:
I have a spread sheet with several columns of data in various formats.
Each time a row of data is added, that data needs to be copied onto a
Template that is on another tab in the workbook.
Each time a new row of data is added, a new Template is to be created. The
old Templates must remain as they were.
So if I have 10 Rows of data, I should have 10 unique Templates.
From: Gord Dibben on 16 Mar 2010 14:14
What, in this context, is a Template on another tab in the workbook?

Templates are usually workbooks saved as a Template filetype.

Does not sound like you want that to happen.


Gord Dibben MS Excel MVP

On Tue, 16 Mar 2010 09:13:01 -0700, Gringarlow
<Gringarlow(a)discussions.microsoft.com> wrote:

>I know very little about VBA and the only way I have created Macros is by
>having Excel follow my mouse and Recording the Macro, then modifying the
>reults as needed.
>Here is what I've been asked to do:
>I have a spread sheet with several columns of data in various formats.
>Each time a row of data is added, that data needs to be copied onto a
>Template that is on another tab in the workbook.
>Each time a new row of data is added, a new Template is to be created. The
>old Templates must remain as they were.
>So if I have 10 Rows of data, I should have 10 unique Templates.

From: Gringarlow on 17 Mar 2010 12:54
The Template I'm referring to is a Excel Worksheet formatted to look like a
Form.


"Gord Dibben" wrote:

> What, in this context, is a Template on another tab in the workbook?
>
> Templates are usually workbooks saved as a Template filetype.
>
> Does not sound like you want that to happen.
>
>
> Gord Dibben MS Excel MVP
>
> On Tue, 16 Mar 2010 09:13:01 -0700, Gringarlow
> <Gringarlow(a)discussions.microsoft.com> wrote:
>
> >I know very little about VBA and the only way I have created Macros is by
> >having Excel follow my mouse and Recording the Macro, then modifying the
> >reults as needed.
> >Here is what I've been asked to do:
> >I have a spread sheet with several columns of data in various formats.
> >Each time a row of data is added, that data needs to be copied onto a
> >Template that is on another tab in the workbook.
> >Each time a new row of data is added, a new Template is to be created. The
> >old Templates must remain as they were.
> >So if I have 10 Rows of data, I should have 10 unique Templates.
>
> .
>
From: Gord Dibben on 17 Mar 2010 15:19
You stated "data needs to be copied onto a Template that is on another tab
in the workbook"

Did you mean the "Template" is nothing more than a formatted worksheet
within the workbook?

You want one of these formatted worksheets for every row of data you add to
a Master input sheet?

You would have to have a blank formatted sheet that can be copied for each
row of data to be entered in Master input sheet.

Is that correct?

So let's design and format a worksheet then add code to copy a row from
Master input sheet, copy the blank "template" sheet and paste data into that
sheet.

Keep doing this until we run out of rows on Master input sheet?

What will we name the 10 "template" worksheets we added?

If you want to continue this off-line please email me a copy of the workbook
with some instructions on where to copy the data.

gorddibbATshawDOTca change the obvious.


Gord




On Wed, 17 Mar 2010 09:54:12 -0700, Gringarlow
<Gringarlow(a)discussions.microsoft.com> wrote:

>The Template I'm referring to is a Excel Worksheet formatted to look like a
>Form.
>
>
>"Gord Dibben" wrote:
>
>> What, in this context, is a Template on another tab in the workbook?
>>
>> Templates are usually workbooks saved as a Template filetype.
>>
>> Does not sound like you want that to happen.
>>
>>
>> Gord Dibben MS Excel MVP
>>
>> On Tue, 16 Mar 2010 09:13:01 -0700, Gringarlow
>> <Gringarlow(a)discussions.microsoft.com> wrote:
>>
>> >I know very little about VBA and the only way I have created Macros is by
>> >having Excel follow my mouse and Recording the Macro, then modifying the
>> >reults as needed.
>> >Here is what I've been asked to do:
>> >I have a spread sheet with several columns of data in various formats.
>> >Each time a row of data is added, that data needs to be copied onto a
>> >Template that is on another tab in the workbook.
>> >Each time a new row of data is added, a new Template is to be created. The
>> >old Templates must remain as they were.
>> >So if I have 10 Rows of data, I should have 10 unique Templates.
>>
>> .
>>

From: Gringarlow on 18 Mar 2010 15:11
Ok, What is your e-mail address?

"Gord Dibben" wrote:

> You stated "data needs to be copied onto a Template that is on another tab
> in the workbook"
>
> Did you mean the "Template" is nothing more than a formatted worksheet
> within the workbook?
>
> You want one of these formatted worksheets for every row of data you add to
> a Master input sheet?
>
> You would have to have a blank formatted sheet that can be copied for each
> row of data to be entered in Master input sheet.
>
> Is that correct?
>
> So let's design and format a worksheet then add code to copy a row from
> Master input sheet, copy the blank "template" sheet and paste data into that
> sheet.
>
> Keep doing this until we run out of rows on Master input sheet?
>
> What will we name the 10 "template" worksheets we added?
>
> If you want to continue this off-line please email me a copy of the workbook
> with some instructions on where to copy the data.
>
> gorddibbATshawDOTca change the obvious.
>
>
> Gord
>
>
>
>
> On Wed, 17 Mar 2010 09:54:12 -0700, Gringarlow
> <Gringarlow(a)discussions.microsoft.com> wrote:
>
> >The Template I'm referring to is a Excel Worksheet formatted to look like a
> >Form.
> >
> >
> >"Gord Dibben" wrote:
> >
> >> What, in this context, is a Template on another tab in the workbook?
> >>
> >> Templates are usually workbooks saved as a Template filetype.
> >>
> >> Does not sound like you want that to happen.
> >>
> >>
> >> Gord Dibben MS Excel MVP
> >>
> >> On Tue, 16 Mar 2010 09:13:01 -0700, Gringarlow
> >> <Gringarlow(a)discussions.microsoft.com> wrote:
> >>
> >> >I know very little about VBA and the only way I have created Macros is by
> >> >having Excel follow my mouse and Recording the Macro, then modifying the
> >> >reults as needed.
> >> >Here is what I've been asked to do:
> >> >I have a spread sheet with several columns of data in various formats.
> >> >Each time a row of data is added, that data needs to be copied onto a
> >> >Template that is on another tab in the workbook.
> >> >Each time a new row of data is added, a new Template is to be created. The
> >> >old Templates must remain as they were.
> >> >So if I have 10 Rows of data, I should have 10 unique Templates.
> >>
> >> .
> >>
>
> .
>
 |  Next  |  Last
Pages: 1 2
Prev: macro pointing to wrong folder
Next: Simplifying an If(OR(…)) statement