New tab stores data in an overview...

**vi54** · 12-19-2009, 01:24 PM

Greetings

I just changed the question here, as I found out something I looked over

but here's my replacement

(using excel 2007)
Inside my book, I have this overview page.

Linking to another sheet in the document is easy through =sheettitle!B2 for example.

Now lets say my sheets are called page1, page2, page3,

How can make sure that when i drag the handle for listing numbers refers to the correct rows?

what i have now is

=service051!B$7
this displays what service my client did for a job. so service is my sheetname, which works great! hooray...
but when i drag the black box (handle) to make a new overview, the service051 is static

so finally here we are...
How can i make sure my document number changes to 052 ... 053 etc.

Many thanks in advance

**jrdnoland** · 12-20-2009, 10:10 AM

Please Login or Register  to view this content.

The “$” anchors the row so that when it is copied anywhere else, it will always refer to row 7.

Use this for the copied cells not to be anchored

Please Login or Register  to view this content.

If you want the column and row to reference the same cell all the time do this:

Please Login or Register  to view this content.

**vi54** · 12-20-2009, 12:10 PM

Thanks but alas thats not what I wanted, what you mean is comon excel stuff, thanks for this, but it doesn't work out for this particular case.

The issues is that i have for example these tabs (sheets)

service051,service052,service053

So in essence,

I am looking for a way so i can make a incremental list of the sheets that are in my document.
fe:
=service051!B7 (the actual service is fe. "painting")
=service052!B7 (the actual service is fe. "logo design")
=service053!B7 (the actual service is fe. "stock photo selection")
etc etc

just like you would drag any other incremental list
but since service051 is referring to a sheet, it gets wrapped by ' ' in excel
so the drag of the little black box doesn't work.

So as you can see, each sheet is a different invoice, i am trying to get a solid overview, referencing to my incremental services.
Thanks in advance.
v