• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

USING OFFSET IN A NEW SHEET

H

harveywalker

New Member
Hi All,


I'm having problems with a worksheet I'm doing for work.


What I have is a worksheet called "Take Off", with a load of data entered horizontally, and I need to take certain elements from this sheet, and use them in colums on worksheet "Costing sheet". The worksheet isn't a fixed size as it depends on which job I'm taking off.


Each item on "take off" is seperated with 5 rows.


I'm currently using the sum function to copy the cells, and manually moving the cells around the sheet. There must be an easier way! I've tried using offset, but I can't get it to use columns instead of rows.


Can some one help?!


Regards,


Harvey
 
Hi Harvey ,


I think some more details will help.


You say each item on the "Take Off" tab is separated by 5 rows ; what about the destination sheet "Costing sheet" ? How are the items taken from the "Take Off" tab to be presented on the "Costing sheet" tab ? Should they be in consecutive columns , or should they be separated by some fixed number of columns ?


It would make it easier if you give an example , specifying row and column cell references.


Narayan
 
Harvey


Firstly, Welcome to the Chandoo.org forums.


You can find a discussion on how to upload files here: http://chandoo.org/forums/topic/posting-a-sample-workbook
 
You must log in or register to reply here.
Back
Top