WOrksheets

  • Thread starter Thread starter Smirlface
  • Start date Start date
S

Smirlface

I have one file with two worksheets. They are both the same, but one
worksheet needs to be re arranged to be easier to read alter information
while the other has to remain in a certain format so it can be uploaded into
my accounting system.

They have been successfully linked, but when I g to re arrange the first
worksheet, it automatically re arranges the second worksheet when I dont want
it to.

The current formula I have is =Worksheet!$D$2

Thanks
 
unfortunately the second worksheet with the formula in it has to remain in
that format as it needs to be uploaded into an accounting system

macropod said:
Hi Smirlface,

Re-arrange the second worksheet instead.

--
Cheers
macropod
[Microsoft MVP - Word]


Smirlface said:
I have one file with two worksheets. They are both the same, but one
worksheet needs to be re arranged to be easier to read alter information
while the other has to remain in a certain format so it can be uploaded into
my accounting system.

They have been successfully linked, but when I g to re arrange the first
worksheet, it automatically re arranges the second worksheet when I dont want
it to.

The current formula I have is =Worksheet!$D$2

Thanks
Click to expand...
.
Click to expand...
 
Back
Top