| Home |
| Search |
| Today's Posts |
|
#9
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how to insert a collum on a sheet without it changing cell ref
welcome, glad to hear.
-- Max Singapore "Just Me" wrote in message ... I would like to thank you both for helping me with my problem, I learned i could insert the second column then manipulate the numbers and the page would work without changing the cell addresses. But the real trick was to only call for the row number range and not the collum at all so the collum would not update: =COUNTIF(Numbers!3:3,1) and the place where I was calling the date just changed to: =INDIRECT("'Numbers'!A1") that way the cell reference does not change when I insert a collumn on the numbers sheet and will show the proper date once the data has been pasted onto the cells. -- Thank You both very Much for taking your time to reply to my post I learned alo alo alot |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| insert an extra row or collum | Excel Discussion (Misc queries) | |||
| Referen to cell on other sheet not working | Excel Worksheet Functions | |||
| Using SUMIF and FIND/RIGHT to add values of a partial cell referen | Excel Discussion (Misc queries) | |||
| How do I change a cell from absolute reference to relative referen | Excel Discussion (Misc queries) | |||
Threaded Mode
