referencing sheets but additiona

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Referencing sheets but with additional rows | Excel forum

Referencing sheets but with additional rows | Excel forum

resolvedResolved · Medium Priority · Version 2007

Tom has attended:
Excel Intermediate course

Referencing sheets but with additional rows

I want to reference a cell from a previous sheet but insert 3 rows below each cell referenced. How do i do this?

RE: referencing sheets but with additional rows

Hi Tom

Need a little bit of background information on this issue.

Firstly the cell you want to reference, does it have the same cell reference on each sheet?

Secondly could you provide me with an example you could email the example to newson@stl-training.co.uk

Thanks

RE: referencing sheets but with additional rows

i have sent you the sheet to have a look at...

the example is of a master sheet for a set of job roles.. i want to then reference the cells on the main sheet to the subsequent sheets but for each criteria have a column next to it with 3 rows per criteria.. i hope that makes sense.

Have a look and see if you know what i mean.

Thanks
Tom

RE: referencing sheets but with additional rows

Hi Tom

Thanks for the spreadsheet. I'm assuming you want to insert 6 rows below where you have put the question marks in the salary bracket column.

I'm assuming the salary bracket row in the Junior 1 sheet should match the Salary bracket row the mastersheet. Sorry need to clarify the the specifics of what you want before i can propose a solution

Listen I'm training today I will have a look tonight

Thanks

Newson

RE: referencing sheets but with additional rows

I think what i basically need is a macro to run from the mastersheet. the mastersheet would have what it has now.. and post running the macro the junior 1 sheet would be set up as it is now. So, for every characteristic there would be 3 rows in the criteria column next to it... all the way across.. tricky.

thanks
Tom

RE: referencing sheets but with additional rows

Hi Tom

Let me get some clarification here

you just want to basically add the additional criteria rows to each of the columns in the mastersheet.


So every junior sheet is basically a copy of the mastersheet but with those additional criteria columns.

and your not copying data or anything like that you just want additional rows.


Thanks


Newson

RE: referencing sheets but with additional rows

close.. i want both.. i want to copy the rows from the master sheet to the junior sheet and add the columns; the column should have 3 criteria rows for every filled cell.

I don't know if i am confusing you or helping...

RE: referencing sheets but with additional rows

Hi Tom

You are helping but I think this is beyond the scope of the forum so I am going to pass it to my colleague and he will contact you.

Thanks

Newson

Thu 15 Jul 2010: Automatically marked as resolved.


 

Excel tip:

Hiding Formulae in the Formula Bar

It is possible to protect the contents of a cell reference(s) from amendment by applying cell protection. The contents of the cell reference can also be stopped from displaying in the formula bar.

Step 1: Select Format > Cells > Protection.

Step 2: Tick Hidden option. Ensure Locked is ticked

Step 3: Select Tools > Protection > Protect Sheet

(Ensure "Protect worksheet and contents of locked cells" is ticked)


View all Excel hints and tips


Server loaded in 0.08 secs.