Use of OFFSET function

M

mahadevan.swamy

Hi,

I have two workbooks (Book 3 and Report 4) where Report 4 is heavily
linked to Book 3. In Report 4, I have a formula that is referenced to
some columns of Book 3. Now my objective to copy the formula to the
adjecent cell in Report 4 by skipping 5 columns of cells in Book 3.

For Example, in cell d6 of Report 3, I have: -

=COUNTIF('[Book3.xls]Line Returns (Internal)'!$E$4:$E
$300,CONCATENATE(LEFT($C$2, 2))

and there is a blank column of cells and in the next column of cells
(cell e6), I want to have this formula: -

=COUNTIF('[Book3.xls]Line Returns (Internal)'!$J$4:$J
$300,CONCATENATE(LEFT($E$2, 2))

You can notice the sequence of formulas in report 4, E, J, O etc....
C, E, G etc... I have many columns of cells and it would be hectic to
go to each and every column cell and change the sequence. Is there an
easier way to do this?

I was advised to use OFFSET function but I don't know how to use it
properly and when I tried it, it wasn't skipping any columns (in the
formula) in book 3.

I would appreciate if anyone has a better solution to this. Thank you

Swamy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0
Use of OFFSET function 0
Skip columns and copy formulas 15
Skip column cells and copy formulas 2
Found few bugs in my daily routine of work in excel for MAC 0
Excel - Wich Function should I use? 1
Remove Identical words 0
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0

Top