Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 54
Default In Over My Head

Hello again Gods of Excel. Here's what I'm struggling with this week: I need
to use the value from sheet "SET UP" cell "C2" (which is a whole number,
let's say 50) on all my other sheets (Jan - Dec) in as a counter. I'd like
to accomplish two things on all the other sheets: 1) starting w/ row 6 in
column A, list 1 through whatever the number for C2 is on "SET UP" sheet; 2)
format cells B6:K56 (row 6 + 50 in this example) with white background, grey
shading etc.

So if I entered 50 on the SET UP sheet, all the other pages would have 50
lines formatted with 1-50 listed in column A. What if I changed that number
to 30? Wouldn't the formatting remain for the rows labelled 31-50?

Thanks in advance for any help.
 
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
over my head James Excel Discussion (Misc queries) 5 June 24th 08 10:06 AM
Head to head Noob Jedi Excel Discussion (Misc queries) 3 August 31st 07 11:26 PM
In over my head with calendar 8.0 Matt the wire guy Excel Worksheet Functions 2 July 22nd 07 05:08 AM
Cant get my head around this one mbys14932 Excel Worksheet Functions 7 June 9th 06 05:23 PM
Over my head on this one... ChuckF Excel Worksheet Functions 1 April 6th 06 10:57 PM


All times are GMT +1. The time now is 12:58 PM.

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"