Two questions

[Boenerge]

Hi,
Is there a way that I can set up a spreadsheet row that would print
automatically row headings on every new sheet, regardless if cells move up or
down?

Secondly, how can I get cell B1 in sheet 2 to look at column A in sheet 1
for a specific e.g. G1 and then for the cells in the row the specific is
found in sheet1 to be directly copied to sheet 2.
E.g Cell B1 in sheet 2 looks for G1 in sheet 1 and finds it in cell A5,
then for the cells B5 to H5 in sheet 1 to be copied to cells B1 to H1 in
sheet 2?

Thank you in advance
Jason

 

[Shane Devenshire]

Hi.

1. Choose File, Page Setup, Sheet tab, Rows to repeat at top

2. This question is not clear, why not show us an example - for one thing
finding G1 in A5 is at the very least confusing, are you refering to the
contents of G1 or are you refering to the text "G1"?

If the first part helped, please click the Yes button

Cheers,
Shane Devenshire

 

[Boenerge]

Hi,
Thanks
I have two spreadsheets. One called nursing and the other medical. I want
to be able to copy certain cells from one sheet to other and visa verca
without the need to copy & paste.
So I want a cell in nursing to search a column for specific text in the
medical sheet, then I want the contents of cells in the row where the text is
found to be copied to cells in the nursing sheet.

Example:
The cells B3-G3 in the nursing sheet to search Column A in the medical sheet
for specific text e.g. "G1". When "G1" is found in cell A5 then the contents
of cells B5-G5 in the medical sheet are copied to the cells B3-G3 in the
nursing sheet.
Hope this helps to make it clearer, if not let me know.
Thanks