LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Barb
 
Posts: n/a
Default formula will not fill correctly due to odd number rows

I am using a formula to add sales in one workbook in the second book,
xxxx[2005 Sales 04.xls]Sheet1'!B9:B10), the problem is when I try to copy by
filling it assumes the rows are in order when in reality they are like this
b9:b10, b11:b12, b13:b14.... is there a way to do this, other wise I'll be
spending a lot of time editing.
Thank you and have a wonderful day
 
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
Possible? formula in one cell can fill another cell Sherri Excel Worksheet Functions 3 March 24th 05 12:35 AM
Formula to count the cells in a range that have a fill color. Molly F Excel Discussion (Misc queries) 2 January 19th 05 06:15 PM
When I copy down into the next cell the formula changes correctly. Jason30 Excel Discussion (Misc queries) 1 January 12th 05 11:55 PM
Excel - formula to calculate colored fill cells within a range wi. MA Excel Worksheet Functions 1 January 7th 05 04:06 PM
Identifying the Active Fill Color Steve Conary Excel Discussion (Misc queries) 3 December 9th 04 04:45 AM


All times are GMT +1. The time now is 02:27 AM.

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

About Us

"It's about Microsoft Excel"