LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 27
Default Consecutive cells pulling data from non-consective cells

New job-rewriting the spreadsheet we use for scheduling. What I have is one
sheet detailing test scheduling with one day every three rows and one sheet
detailing man-hours with one day per row. Is there a way I can pull the
daily hours from each row of the one sheet to every third row of the other?

i.e.

A3=A1
A6=A2
A9=A3... etc.
 
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
number of times consective data occurs in a range of cells Thanks a lot Ralph. it worked. Excel Worksheet Functions 10 June 21st 07 05:21 AM
How do I sum the value of a range of cells without pulling any ce. c_foskey_22 Excel Discussion (Misc queries) 2 December 12th 06 08:48 PM
PULLING OUT CONSECUTIVE ROWS GARY Excel Discussion (Misc queries) 2 August 26th 06 04:25 AM
Consecutive Cells Stat Guy via OfficeKB.com Excel Worksheet Functions 1 May 26th 05 05:57 AM
Consecutive cells Trapper via OfficeKB.com Excel Worksheet Functions 4 May 23rd 05 10:28 PM


All times are GMT +1. The time now is 07:53 PM.

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

About Us

"It's about Microsoft Excel"