Hi,
I have a minor problem that im sure there is an easier solution
I have 6 sales figures (every 2 months in a year)
these are on sheet 2 in the following cells
H14
W14
AL14
BA14
BP14
CE14
On sheet 1 i have a summary of the accounts etc
I am looking for a way to show on sheet 1 the latest sales made from row 14
example
H14 - £32,000
W14 - £28,924
AL14
BA14
BP14
CE14
I would like the return to be £28,924 or
H14 - £32,000
W14 - £28,924
AL14 - £16,999
BA14 - £35,323
BP14
CE14
Then the return would be £35,323
Alternatively at the start of the year
H14
W14
AL14
BA14
BP14
CE14
would return a simple ""
Hope all this makes sense
Thanks
I have a minor problem that im sure there is an easier solution
I have 6 sales figures (every 2 months in a year)
these are on sheet 2 in the following cells
H14
W14
AL14
BA14
BP14
CE14
On sheet 1 i have a summary of the accounts etc
I am looking for a way to show on sheet 1 the latest sales made from row 14
example
H14 - £32,000
W14 - £28,924
AL14
BA14
BP14
CE14
I would like the return to be £28,924 or
H14 - £32,000
W14 - £28,924
AL14 - £16,999
BA14 - £35,323
BP14
CE14
Then the return would be £35,323
Alternatively at the start of the year
H14
W14
AL14
BA14
BP14
CE14
would return a simple ""
Hope all this makes sense
Thanks