Prev: Breaking Links - BUT WHERE ARE THEY???
Next: Can I add to a cell value without manual calculation?
From: Diddy on 31 Mar 2010 06:27
Hi everyone,

I have 2 sheets containing data

Sheet 1 A1-AT623 and Sheet 2 A1-AF822.

Where I already have data in Sheet 1 I would like to be able to delete (or
extract to a 3rd sheet) that row in Sheet 2.

If anyone could help that would be fantastic!

Cheers
Diddy
From: Don Guillett on 31 Mar 2010 08:44
Examples and criteria?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"Diddy" <Diddy(a)discussions.microsoft.com> wrote in message
news:82655AA2-5EAA-4B87-809A-88F4C624A63C(a)microsoft.com...
> Hi everyone,
>
> I have 2 sheets containing data
>
> Sheet 1 A1-AT623 and Sheet 2 A1-AF822.
>
> Where I already have data in Sheet 1 I would like to be able to delete (or
> extract to a 3rd sheet) that row in Sheet 2.
>
> If anyone could help that would be fantastic!
>
> Cheers
> Diddy

From: Diddy on 31 Mar 2010 09:37
Sorry meant to say :-(

The value on which to look for duplicates is in C in both sheets and is a
string 12-14 long with letters and numbers.

e.g. F200797863807A

Many thanks
Diddy



"Don Guillett" wrote:

> Examples and criteria?
>
> --
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguillett(a)gmail.com
> "Diddy" <Diddy(a)discussions.microsoft.com> wrote in message
> news:82655AA2-5EAA-4B87-809A-88F4C624A63C(a)microsoft.com...
> > Hi everyone,
> >
> > I have 2 sheets containing data
> >
> > Sheet 1 A1-AT623 and Sheet 2 A1-AF822.
> >
> > Where I already have data in Sheet 1 I would like to be able to delete (or
> > extract to a 3rd sheet) that row in Sheet 2.
> >
> > If anyone could help that would be fantastic!
> >
> > Cheers
> > Diddy
>
> .
>
From: Don Guillett on 1 Apr 2010 11:15
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"Diddy" <Diddy(a)discussions.microsoft.com> wrote in message
news:D0BA33C8-EE76-427D-AEB6-B40DB86AADDA(a)microsoft.com...
> Sorry meant to say :-(
>
> The value on which to look for duplicates is in C in both sheets and is a
> string 12-14 long with letters and numbers.
>
> e.g. F200797863807A
>
> Many thanks
> Diddy
>
>
>
> "Don Guillett" wrote:
>
>> Examples and criteria?
>>
>> --
>> Don Guillett
>> Microsoft MVP Excel
>> SalesAid Software
>> dguillett(a)gmail.com
>> "Diddy" <Diddy(a)discussions.microsoft.com> wrote in message
>> news:82655AA2-5EAA-4B87-809A-88F4C624A63C(a)microsoft.com...
>> > Hi everyone,
>> >
>> > I have 2 sheets containing data
>> >
>> > Sheet 1 A1-AT623 and Sheet 2 A1-AF822.
>> >
>> > Where I already have data in Sheet 1 I would like to be able to delete
>> > (or
>> > extract to a 3rd sheet) that row in Sheet 2.
>> >
>> > If anyone could help that would be fantastic!
>> >
>> > Cheers
>> > Diddy
>>
>> .
>>

 | 
Pages: 1
Prev: Breaking Links - BUT WHERE ARE THEY???
Next: Can I add to a cell value without manual calculation?