[Solved] Why text is pasting on hidden page?

[kumarkutti]

https://files.fm/u/sknm6x83 .ODS file

HI Can anyone can explain how the text pasting exactly on hidden scanned page . I searched so many sites but no one unable to explain .

i am working a bank at rural place ..filling the account opening forms manually become very difficulty ..

one day i got this ODS https://files.fm/u/sknm6x83 file .

then i got idea ,it can be used to filling Account opening form

Actually i don't have much knowledge in Excel .

So please any one can help me regarding this ODS file

Thanking You

[FJCC]

The information from the first sheet is transferred to the other sheets using formulas. In one case, the image of the paper form was placed on a sheet and then the cells were roughly positioned to match the input positions on the image. For example, the name KUMAR can be transferred to another sheet with the formula

Code: Select all

=Sheet1.C8

If you have to transfer and input letter by letter, you can use a formula like

Code: Select all

=MID($Sheet1.C8;2;1)

to get the second letter KUMAR.