Apple Event: May 7th at 7 am PT

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Cliff Peters Author

Level 2

195 points

Fixed Column changing Row

Hi,

I'm fairly sure there is no formula for what I would like to achieve ??

Is there a Macro? that can be used.??

I have a spreadsheet that I would like to be able to recognise a variable cell reference.

I.E. the formulas will look similar to this when complete.

Cell "F1000" =SUM(F8:F28), Cell "G1000" = SUM(G29:G34)...

Cell "F1001" = SUM(F29:34)...

Cell "F1002" = SUM(F35:64)...

etc

The Row numbers will change until I complete that portion of the spreadsheet.

I have found a way to display the final row numbers as they correspond to a date.

A way I can do this manually is to type the cell reference & formula then Fill Right.

I have never had any joy creating Macro's & don't understand the language or how they work.

Cheers for any Ideas

Cliff

iMac, Mac OS X (10.6.8)

Posted on Jul 19, 2014 7:20 PM

19 replies

Yellowbox

Level 7

20,383 points

Jul 28, 2014 12:50 AM in response to Cliff Peters

Hi Cliff,

If you feel comfortable with emailing your document to me, click on my name to see my email address.

If I too get the 'Spinning Beach Ball of Death' then we will know that something is amiss.

Regards,

Ian.

Cliff Peters Author

Level 2

195 points

Jul 28, 2014 2:21 AM in response to Yellowbox

Hi Ian,

My lovely wife Made me buy a new Mac in the weekend, (just kidding), but I do have a New Mac & New Numbers.

The document apart from a few format issues is rocking like a Jackaroo.

Thanks V much for assistance.

Cliff

Cliff Peters Author

Level 2

195 points

Aug 3, 2014 1:47 AM in response to SGIII

Hi SG, Ian, & Others,

I've almost completed my Cashbook Spreadsheet with the help of Numbers & all you great people. I have found the SS constantly changing & evolving as I build it.

Multiple sheets is great now I have the hang of them. Now I understand how they work I realise it is something I have wanted for over 26 years of Claris & AppleWorks.

Even though there are a few things I miss from AppleWorks the advantages of Numbers is amazing & I will now rework all my previous SS's to Numbers.

Loving Numbers more each time I use it.

Cliff

Cliff Peters Author

Level 2

195 points

Aug 3, 2014 1:48 AM in response to Listen Inn

Hi MS,

I see what you where saying now, this is another great function that performs as it should.

Thanks

Cliff

Fixed Column changing Row