Worksheet Formula Issues

[Smirlface]

I have two worksheets (let's call them a & b) that my accounting program
dumps into excel. They are identical with around 1000 rows of info. Column A
has the title, and Column B has a figure.

I want to link the cells in worksheet 'b' to worksheet 'a' so
data changed in Column B in worksheet 'a' will show in the same cell in
worksheet 'b'.

However, I need to rearrange the rows in worksheet 'a' to be in a format
that my accountant can read, but worksheet 'b' will remain the same as I need
to upload it back into the accounting system.

What do I have to do to make sure the two worksheets are linked properly to
the
correct cells once worksheet 'a' is rearranged?

 

[Simon Lloyd]

the formula to link a cell in another workbook would b
=[Book1]Sheet1!$A$1 no matter how you sort the worsheet that thi
appears on it will always point to A1 of Book

I have two worksheets (let's call them a & b) that my accounting progra
dumps into excel. They are identical with around 1000 rows of info
Column
has the title, and Column B has a figure

I want to link the cells in worksheet 'b' to worksheet 'a' s
data changed in Column B in worksheet 'a' will show in the same cell i
worksheet 'b'

However, I need to rearrange the rows in worksheet 'a' to be in
forma
that my accountant can read, but worksheet 'b' will remain the same a
I nee
to upload it back into the accounting system

What do I have to do to make sure the two worksheets are linke
properly t
th
correct cells once worksheet 'a' is rearranged

--
Simon Lloy

Regards
Simon Lloy
'Microsoft Office Help' (http://www.thecodecage.com

 

[Jacob Skaria]

Take a look at the worksheet function VLOOKUP()

Suppose you have the sheets named as Sheet1 and Sheet2. In sheet2 cell B1
apply the below formula and copy down as required..

=VLOOKUP(A1,Sheet1!A:B,2,0)

 

[Smirlface]

Hi Jacob,

I'm not really familiar with VLOOKUP, so when I tried entering in the
formula, it didn't work. I'll go into more detail about the workbook i have:

A B C D
E F
NAME Account Code Account Type Period 1 Period 2 Period 3
jbloggs ASD ID 1000 100
1000
andsoon ASR ID 110 100
100

What will my VLOOKUP formula be? the current one I have always brings up a
#REF error.

Thanks,

 

[Smirlface]

Thank you, I just figured out the reason why my formula wasn't working. It
was because of the name of the file for some reason.