creative_eyes said:
Asalamu Alaikum Brother i have been attached File
I assume you are using excel 2007/2010/2013
A. In 1st sheet adjust your Page setup. Go to "VIEW" and then click on page break preview. then adjust right margin.
B P.O ka no jo print m out ho jata ha is ka solution 2 hain.
1 solution. Adjust Header of the sheet. Q k file ka name he aap ka purchase order ha. Jo K aap na ya kisi aur na sheet design krte hoe header m file ka name rakha ha aur "Enter" key use krte hoe adjust kya ha. Aap ise adjust kr lain.
2. ya apna Header Delete kr dain. aur cell m ya formula use karain. Result will be same
Code:
=MID(LEFT(CELL("filename",A1), FIND("]", CELL("filename", A1)) - 5),FIND("[", CELL("filename", A1)) + 1, 255)
Please find the attached file. Sheet 1 contain the above formula and sheet 2 with header solution ( attached by you)
please feed back agar smjhne m koi masla ho tu btaye ga.
regards
Bookmarks