relative sheet

  1. H

    capture cell info from different worksheets into a column of Summary Sheet

    I have created a few identical sheets, namely Invoice, Invoice (2), Invoice (3) and so on. Cell F5 of each invoice will be the invoice number (running number). After sheet Invoice (3), i have created another sheet namely Invoice Summary (on the right to Invoice (3)), which will have one of the...
  2. S

    Autofill with relative sheet reference

    Thank you in advance for your help. I have searched several times through the boards and can't seem to find an answer to this one. I am dragging cells to autofill but what I need is an absolute cell reference and a relative sheet reference so when I drag my cell the subsequent cells read...

Some videos you may like

This Week's Hot Topics

Top