Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automated calculations? What's the best way?
Hi,
I am using MS-Query to pull some data from our database. Depending on the criteria I'm using there may be more or less rows selected. To the right of the data that's fed into the spread sheet I have a column that calculated based on two of the fields brought in from the database. When there are more rows than the previous set of data the calculated column doesn't automatically expand the calculation for the new rows. I have to manually copy and paste the calculation. If there are less rows then I get an error because there is no data to make the calculation from. I also have to trim spaces from a couple of the fields brought in by the database. Since this data is being used by non-technical people and it's quite time consuming to do it over and over I'm wondering if there is a way to have Excel do these operations automatically. If so then what's the best way? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
order of calculations in Excel | Excel Worksheet Functions | |||
complex calculations | Excel Discussion (Misc queries) | |||
looping through a set of calculations | Excel Worksheet Functions | |||
Calculations crossing multiple sheets | Excel Discussion (Misc queries) | |||
time interval calculations in excel | Excel Discussion (Misc queries) |