About Us

WLMPilot

Thanks! Figured it was something simple.

Les

"Don Guillett" wrote:

Assuming you don't want to do this for ALL, name it.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"WLMPilot" wrote in message
...
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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Cell Reference Problem with Network	4Nails	New Users to Excel	6	May 26th 07 11:04 AM
Cell reference problem	Jim Olsen	Excel Worksheet Functions	4	October 31st 05 05:47 AM
Problem with formulas changing cell reference	janicesweet	Excel Discussion (Misc queries)	1	August 2nd 05 06:23 PM
problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable.	[email protected]	Excel Worksheet Functions	2	December 11th 04 12:05 AM
Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable	[email protected]	Excel Worksheet Functions	2	December 11th 04 12:00 AM

Menu

About Us