Prev: macro pointing to wrong folder
Next: Simplifying an If(OR(…)) statement
From: Gord Dibben on 18 Mar 2010 19:03
As posted at bottom of my reply.


gorddibbATshawDOTca change the obvious.


Gord

On Thu, 18 Mar 2010 12:11:03 -0700, Gringarlow
<Gringarlow(a)discussions.microsoft.com> wrote:

>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.
>> >>
>> >> .
>> >>
>>
>> .
>>

First  |  Prev  | 
Pages: 1 2
Prev: macro pointing to wrong folder
Next: Simplifying an If(OR(…)) statement