Project Layout
I m from India & work in a Govt Departmetn PWD where Road maintained section
So my project show in hindi … (hindi fonts enclosed..)
My proble is
Cell No. I24 when I enter Y
2 types Record move
1 fix record copy (Cell Value A27:W27) to sheet Record
2n condition record move
a- if (E6=Head Office Work then copy record cell value (e38:h40) to sheet HO
b- if (E6 other then Head Office Work then copy record cell value (a29:L34) to sheet Work
Problem in Moving Fix Record
When after entry cell no i24 Y I move Fix Record (Cell Value A27:W27) to sheet Record then when I read record from here to mail marge words sheet then Cell Value G,H,I (SHMDR, VR & Total Cost in Record Sheet) this value show difference.. in excel sheet value show 150.79, 7.00 . 157.79 but in word mail marge value show 150.790001, 7. 000001 157.790001
To fix this problem we use SHMDR, VR & Total Cost (Cell Value AJ, AK, AL) with
=text()
pls help me to solve this problem so that we never use =text() in sheet
so that we can not entery 400 blank row before
pls help us
thanks & advance
my project file enclosed for ur kind persual
Bookmarks