On the sheet 2 I have table "Orders" where is in column A emplooyes in
column B is month january in column C is month February
and so to the end of year.
On the sheet1 I have pivot table where is emplooyes in row fields, months is
in page fields and one calculated item "working hours" in data fields.
I want copy paste only value calculated item "working hours" from pivot table
to table "Orders"
in adequate column.
If month in pivot table is january must copy value to column B in table
"Orders" if is month May must copy in column F and ect.
I try with formula =if(sheet1!$A$1=1;vlookup(Orders!$A2;sheet!1$A$4:$ B$50:
2;false)) but I must manually work too.
Maybe, someone who know how implement this formula to VBA code.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200901/1