WOrksheets

[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

 

[macropod]

Hi Smirlface,

Re-arrange the second worksheet instead.

 

[Smirlface]

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

Hi Smirlface,

Re-arrange the second worksheet instead.

--
Cheers
macropod
[Microsoft MVP - Word]

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

.