Prev: Pick numbers
Next: User Form Date Field disappeared!
From: BAC on 21 Mar 2010 11:29
Please can anyone help with me with some VBA Coding for an excel spreadsheet.

I need to extract the year 2010 data from a master file copy it to a new
spreadsheet, and need to keep it linked. They have set up the spreadsheet
with blank rows and also wants to keep the all the formatting. Paste linking
does not work for her.

Can anyone please help me with some VB Coding to do this job, as I am really
not sure how to even start this.

Any help would be appreciated.
--
Thanks
BAC
From: Dennis Tucker on 21 Mar 2010 11:42

BAC

I can help. I will need the following items.
1. A copy of the "master file".
2. The name of the "new spreadsheet" you want the data copied too.
3. The pathname(location) where item 1 resides on your computer.
4. The pathname(location) where you want item 2 to reside on your computer.

What version of Excel do you have?

Dennis



"BAC" <BAC(a)discussions.microsoft.com> wrote in message
news:5423EACB-12DD-4882-80F0-989317A56429(a)microsoft.com...
> Please can anyone help with me with some VBA Coding for an excel
> spreadsheet.
>
> I need to extract the year 2010 data from a master file copy it to a new
> spreadsheet, and need to keep it linked. They have set up the spreadsheet
> with blank rows and also wants to keep the all the formatting. Paste
> linking
> does not work for her.
>
> Can anyone please help me with some VB Coding to do this job, as I am
> really
> not sure how to even start this.
>
> Any help would be appreciated.
> --
> Thanks
> BAC

From: BAC on 21 Mar 2010 20:46
Hi Dennis
I am using Office2007, but it is for a person using 2003, for the moment the
reside on the local drive C: How do I get the copy of the file to you

much appreciated

BAC
--
Thanks
BAC


"Dennis Tucker" wrote:

>
> BAC
>
> I can help. I will need the following items.
> 1. A copy of the "master file".
> 2. The name of the "new spreadsheet" you want the data copied too.
> 3. The pathname(location) where item 1 resides on your computer.
> 4. The pathname(location) where you want item 2 to reside on your computer.
>
> What version of Excel do you have?
>
> Dennis
>
>
>
> "BAC" <BAC(a)discussions.microsoft.com> wrote in message
> news:5423EACB-12DD-4882-80F0-989317A56429(a)microsoft.com...
> > Please can anyone help with me with some VBA Coding for an excel
> > spreadsheet.
> >
> > I need to extract the year 2010 data from a master file copy it to a new
> > spreadsheet, and need to keep it linked. They have set up the spreadsheet
> > with blank rows and also wants to keep the all the formatting. Paste
> > linking
> > does not work for her.
> >
> > Can anyone please help me with some VB Coding to do this job, as I am
> > really
> > not sure how to even start this.
> >
> > Any help would be appreciated.
> > --
> > Thanks
> > BAC
>
> .
>
From: Dennis Tucker on 21 Mar 2010 21:12
dennis13030(a)cox.net
Just attach it.

I still need the following items.
1. A copy of the "master file".
2. The name of the "new spreadsheet" you want the data copied too.
3. The pathname(location) where item 1 resides on your computer.
Please be specific. I.e. "C:\MyFolder\MySubFolder"
4. The pathname(location) where you want item 2 to reside on your computer.
Please be specific. I.e. "C:\MyFolder\MySubFolder"

"BAC" <BAC(a)discussions.microsoft.com> wrote in message
news:49AF3971-29AA-4194-9768-642285628FB4(a)microsoft.com...
> Hi Dennis
> I am using Office2007, but it is for a person using 2003, for the moment
> the
> reside on the local drive C: How do I get the copy of the file to you
>
> much appreciated
>
> BAC
> --
> Thanks
> BAC
>
>
> "Dennis Tucker" wrote:
>
>>
>> BAC
>>
>> I can help. I will need the following items.
>> 1. A copy of the "master file".
>> 2. The name of the "new spreadsheet" you want the data copied too.
>> 3. The pathname(location) where item 1 resides on your computer.
>> 4. The pathname(location) where you want item 2 to reside on your
>> computer.
>>
>> What version of Excel do you have?
>>
>> Dennis
>>
>>
>>
>> "BAC" <BAC(a)discussions.microsoft.com> wrote in message
>> news:5423EACB-12DD-4882-80F0-989317A56429(a)microsoft.com...
>> > Please can anyone help with me with some VBA Coding for an excel
>> > spreadsheet.
>> >
>> > I need to extract the year 2010 data from a master file copy it to a
>> > new
>> > spreadsheet, and need to keep it linked. They have set up the
>> > spreadsheet
>> > with blank rows and also wants to keep the all the formatting. Paste
>> > linking
>> > does not work for her.
>> >
>> > Can anyone please help me with some VB Coding to do this job, as I am
>> > really
>> > not sure how to even start this.
>> >
>> > Any help would be appreciated.
>> > --
>> > Thanks
>> > BAC
>>
>> .
>>
 | 
Pages: 1
Prev: Pick numbers
Next: User Form Date Field disappeared!