Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a problem and I can't find an answer for it. Maybe you can help me.

  1. In Sheet "Intro" I have a row (5), in which are formulas:

    (i) C5(='Sheet1'!$A$1);
    (ii) I5(=OFFSET('Sheet1'!$A$1;17;1;1;));
    (iii) In this row also is the number of my tables line, i.e., B5(=1). This number "1" is also a hyperlink to Sheet1.

  2. I have a macro that automatically inserts a new row after the last filled row, i.e., when I have filled 5 rows and run my macro, it inserts row 6. I want to automatically fill this row with my formulas, which I described above.

More specifically, the new row should be filled in like this:

When the new row is 6:

(i) C6(='Sheet2'!$A$1);
(ii) I6(=OFFSET('Sheet2'!$A$1;17;1;1;));
(iii) B6(=2). This number "2" is also a hyperlink to Sheet2.

When the new row is 7:

(i) C7(='Sheet3'!$A$1);
(ii) I7(=OFFSET('Sheet3'!$A$1;17;1;1;));
(iii) B7(=3). This number "3" is also a hyperlink to Sheet3.

When the new row is 8:

(i) C8(='Sheet4'!$A$1);
(ii) I8(=OFFSET('Sheet4'!$A$1;17;1;1;));
(iii) B8(=4). This number "4" is also a hyperlink to Sheet4.

share|improve this question

closed as not a real question by CharlieRB, Hennes, 8088, Renan, Synetech Nov 6 '12 at 17:23

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

Please specify what spreadsheet tool you are using (including version number). You say you are using Excel, but then you show the syntax OFFSET('Sheet1'!$A$1;17;1;1;), using semicolons (;), which is the convention in OpenOffice and does not work in Excel. Then, please post what you have accomplished so far (i.e., your macro that “automatically inserts a new row after the last filled row”). – Scott Nov 6 '12 at 17:56
@Scott The semicolon can also be a localization thing - in german Excel this function would be BEREICH.VERSCHIEBEN('Sheet1'!$A$1;17;1;1) - so this might be a UK version or some other localization. Further, I am guessing Dalia is just looking for the VBA-Code to setup a formula for a range - like: Range("A1").Formula = "=NOW()" – Jook Nov 7 '12 at 13:55
@Jook: Thanks. If I knew that, I had forgotten. – Scott Nov 7 '12 at 15:40

Browse other questions tagged .