Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Chance224
 
Posts: n/a
Default Auto populate cells based on 2 cells division.

I have a file with two sheets one has a bid template each section of the job
has a total cost and total days. I want to be able to chart the totals by
day. I need the cells on the sheet with the information for the chart to
auto fill. Example:

Cell A2 Description Blah Blah B2 Days 10 C2 Total Cost 100
Column A Column
B Days Cost 1 10 2 10 3 10 4 10 5 10 6 10
7 10
8 10
9 10
10 10

I want it to auto populate the days in coulmn A based on the total days from
"B2" on Sheet1.
Also divide the daily charge based on "C2" Divided By "B2" from Sheet1

Thanks,
Chance

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
Calculate percentage based on cells with conditional formatting Cachod1 New Users to Excel 5 April 4th 05 02:11 PM
REVISED ?? - populate limited cells w/ set value Jane Excel Worksheet Functions 1 March 19th 05 02:29 PM
populate a limited # of cells with a set value Jane Excel Worksheet Functions 5 March 18th 05 09:43 PM
Adding colour to a range of cells based on one of the cells v... McKenna Excel Discussion (Misc queries) 4 March 11th 05 02:25 PM
Auto Skipping and protected cells Dave Peterson Excel Discussion (Misc queries) 6 January 27th 05 11:35 PM


All times are GMT +1. The time now is 11:45 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"