Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 17th 22, 07:43 PM
Junior Member
 
First recorded activity by ExcelBanter: Jun 2013
Posts: 3
Default Incrementing cell ref + 9 rows

This should be very simple, yet I cannot find the solution. I have a sheet that provides summary data from a main data sheet. For example, cell A7 returns the value (text) from cell 'Data'! A30, cell A8 returns the value (text) from cell 'Data'! A39, cell A9 returns the value (text) from cell 'Data'! A48, etc. What I need, therefore, is a way to make A39 become A48 without having to manually type it in. I want to have the cell ref as Axx+9, where xx is the previous used reference + 9 rows (i.e., A39+9=A48).

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Incrementing Rows in columns Ray via OfficeKB.com Excel Programming 3 September 8th 05 05:04 PM
incrementing every two rows--the sequel childofthe1980s Excel Programming 4 June 25th 05 04:31 AM
incrementing every two rows childofthe1980s Excel Programming 3 June 25th 05 12:09 AM
Incrementing formula by two rows Ben Hur Excel Worksheet Functions 1 February 24th 05 09:21 PM
Problem incrementing rows hotherps[_12_] Excel Programming 10 February 18th 04 07:00 PM


All times are GMT +1. The time now is 05:26 AM.

Powered by vBulletin® Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
Copyright 2004-2022 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017