How to show value of one column to different column

[sing1327]

Hi
I got spreadsheet where i have 7 columns
Amount type Code cat1 cat2 dog1 dog2
10 1 cat 10
15 2 dog 15
40 1 dog 40
55 2 cat 55


could anyone help me to create that kind of spreadsheet.Thanks.

[jaslake]

sing1327
This code appears to do as you requested on your sample data. I'd think it'll take some modification in order to work on your real data.

Please Login or Register  to view this content.

Let me know of issues.

[sing1327]

in this sheet it is calculating holiday pay from the holiday list on sheet if u are entering holiday code if there is no holiday on that day it will calculate it as normal pay but i want that i can add holiday pay whatever the day is.i dont want to lookup to holiday list for holiday .i just want whatever code i am entering the amount will go under that.thanks.
plz hav a look on this file
http://wikisend.com/download/745082/tempnew.xls

[jaslake]

Hi sing1327

You say

in this sheet it is calculating holiday pay from the holiday list on sheet if u are entering holiday code if there is no holiday on that day it will calculate it as normal

There's no code in the book to do the same (actually, there's no code AT ALL in the book)

Your "Example - Wages Pay Sheet" looks nothing like the "Wages Paysheet"

I'm missing something...what is it?

[sing1327]

it is wages sheet.i tried opening this one