Canadian spreadsheet please help me!!!!

Status
Not open for further replies.
J

jennyb

Member Since 2012
I started a new spreadsheet, didn't know what went wrong with the old till I started moving all my old numbers to the new.
The Worldmmol only goes to like row 20 or something while the US one goes to infinity.

When you add rows to the canadian side be it by the button on the bottom of the page or by adding one row thru the insert feature, it screws up the formula on the us side so that the row you add has NO formula at all and the ones below don't match the formula to row ie:

=ROUND(('World mmol_L'!B26*18),0) this is suppose to be for column B row 25, but it says row 26 which means it will convert the formula in row 26 which messes up the spreedsheet.

I've posted several times in tech help but have givin up, what are my worldmmol peeps doing to fix this? Someone else must be having this problem too.
 
If you click on a cell for a row that you know is working correctly, like row 10, what does the formula show?

Carl
 
Carl & Bob said:
If you click on a cell for a row that you know is working correctly, like row 10, what does the formula show?

Carl
Click to expand...

Row 10 =ROUND(('World mmol_L'!B10*18),0) that's on the u.s side where the formulas are. so it corresponds to it's row10 column B on both the U.S. and world and it works, but when I go down to were I add a row at the bottom the row you add has NO formula and it pushes the formula's

K. So if I add rows on the mmol side, I have to add the same amount of rows on the u.s. side in order for the rows on ether side to line up to the correct row, so the formulas match and will work.

I could do that, but I've yet to figure out a way to in put the formula across all the columns and down numerous rows without having to put the formula in every individual cell.
 
When i get home I'll figure it out. It's so easy with excel. But there is a way to do this.
 
I use the US one but after Copy, there's the option to Paste > Special > Formulas or Format (for colours)
I use a right click to bring up the Paste menu options
 
The way I found to "fill a formula down" a column. I just went to the last good cell and left clicked it. Then I put my mouse at the bottom right corner of the cell until the large + sign appeared, left clicked on the "+" and dragged it down. After I did that, I went back on each cell I'd dragged down over, and saw that the formula carried down like it was supposed to...

If you go to the cell that says "B26" and change that to B25, the data should be correct? Then try to drag the formula (on the US page) down and see if the series of numbers stays correct?

Carl
 
Carl & Bob said:
The way I found to "fill a formula down" a column. I just went to the last good cell and left clicked it. Then I put my mouse at the bottom right corner of the cell until the large + sign appeared, left clicked on the "+" and dragged it down. After I did that, I went back on each cell I'd dragged down over, and saw that the formula carried down like it was supposed to...

If you go to the cell that says "B26" and change that to B25, the data should be correct? Then try to drag the formula (on the US page) down and see if the series of numbers stays correct?

Carl
Click to expand...

Thanks, it worked and now I can let my hair grow back lol. Is there anything I should do now that the problem has resolved, should I delete my first posting?
 
No reason to delete your first posting. Just start a new thread the next time you post. Glad it worked for you!

Carl
 
Status
Not open for further replies.
Back
Top