Most probably the document page setup is "letter page" whereas the printer's default page setup is A4.
You should change your document's page setup to A4.
This is how I would do it:
1. Write down on a column, all the names of the worksheets you want to retrieve values from.
Example:
Col A Col B
1 sheetA
2 sheetB
3 sheetC
. .
. .
In another column, for example M, write in cell M1...
If your number is in cell B1 (e.g. 12-152452-456) write this formula in cell a1 and copy it downwards:
=MID(B1,FIND("-",B1,1)+1,FIND("-",B1,1+FIND("-",B1,1))-FIND("-",B1,1)-1)
Hope this will help!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.