need help on microsoft excel

[PiaKurda]

---

hi, im trying to make a formatted report of which requires the certain data to appear in each page. im using the "rows to repeat on top" for my header, but im having a hard time of the data that must be seen on the bottom of every page. does anybody know how to do this?

[kensh1n]

=(SheetName)!(Column_Name)
example
=Sheet1!C10
Having this formula will copy what was on Sheet1 particularly on C10

[sogate]

hi,

I assume, you mean the header (text that appears permanently on top of every page produced) and the footer (text that appears permanently at the bottom of every page produced).
Just click <file>, <page setup>, click <header/footer> tab, then click <custom header> or <custom footer> to write the desired text, including the page no., etc.

[PiaKurda]

yes i've already tried using the footer on the page setup, but unfortunately it does not allow complex footers. huhu my footer contains a table gud.

[sogate]

try the copy-paste way in every page u will do