98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum 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
Resolved · 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.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Hiding Formulae in the Formula BarIt 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. |