Prev: How do you randomly generate numbers in Excel 2007?
Next: Custom Views
From: SalesGuy on 7 Apr 2010 15:50
I am trying to move data from one line on one sheet to multiple lines on
another. Basically taking a customer list and converting it to 4x6 notecards
for easy reference on the road. When I try to copy the formula down the
second page it skips 10 lines at a time. the only thing that I have been able
to do is manually delete the cell reference #'s and type the correct ones in.
Is there a way to set the reference to not skip 10 lines at a time? I have
over 500 contacts to do.
From: Luke M on 7 Apr 2010 15:54
Post example of formula please?

--
Best Regards,

Luke M
"SalesGuy" <SalesGuy(a)discussions.microsoft.com> wrote in message
news:E14FF6D4-8DB1-42AC-938F-341188BCC777(a)microsoft.com...
>I am trying to move data from one line on one sheet to multiple lines on
> another. Basically taking a customer list and converting it to 4x6
> notecards
> for easy reference on the road. When I try to copy the formula down the
> second page it skips 10 lines at a time. the only thing that I have been
> able
> to do is manually delete the cell reference #'s and type the correct ones
> in.
> Is there a way to set the reference to not skip 10 lines at a time? I have
> over 500 contacts to do.


 | 
Pages: 1
Prev: How do you randomly generate numbers in Excel 2007?
Next: Custom Views