Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem w/ cell reference
I have 12 budgets (vertically) within a sheet. Each budget has two
commandbuttons that sort two different ways. One sort is by date due, the other separates income and payments, putting income first. GIVEN: Total rows = 50 per budget. The 51st row shows totals. I have three columns that show % of whatever Even though all 12 budgets are created at the first of the year, they are often updated in the event a new bill is created, or finished paying one off. This is where I use the separation of income and payments, so I can just copy the payment portion to the next month. For January, I set up the % formulas. Example of a formula is =IF(OR($H7="",$H7=0),"",$H7/$H57), where H:H is the payment amount and H57 is the TOTAL PAYMENTS. Note the lack of the $ sign before the 57. This is done so that if I copy the payments to the next month, the row would change. NOW THE PROBLEM: If that month is sorted one way, the cell reference changes when I click the other command button, so $H57 may change to $H63, when it needs to stay $H57. Again, I don't want to use the $ in front of the 57. Is there another way to refernce $H57 with using the $ sign and without having it change regardless of the sort? Thanks, Les |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem w/ cell reference
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Reference Problem with Network | New Users to Excel | |||
Cell reference problem | Excel Worksheet Functions | |||
Problem with formulas changing cell reference | Excel Discussion (Misc queries) | |||
problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable | Excel Worksheet Functions |