Movable Sum
May 5, 2006I have a data base in a worksheet which is genateated automatically with formula's, I want the a row after the last to be a SUM that moves up or down depending of the amount of the rows.
View 9 RepliesI have a data base in a worksheet which is genateated automatically with formula's, I want the a row after the last to be a SUM that moves up or down depending of the amount of the rows.
View 9 RepliesI want to do a pivot table with a range a1:j(variable)
The variable row number is held in M2
I would like to do a pivot with range
'Data Input Used for Pivots'!$A$1:$J$[m2]
I have this list wherein the rows might extend beyound 100.
At AG23&24 i have some comments
Can i somehow implement such that even when i scroll down teh rows this too will be appearing, as we see sometimes navigation toolbars appearing in websites when we go down or move up.
I want to know if this feature can be implemented in excel.
I have an xy scatter plot and I'd like a way to put some verticle lines / cursors on the plot. These lines could be moved along the x axis (right and left). Where these lines cross the curve, i'd like the x and y value of the data point on the curve to be given in cells within the spreadsheet.
If this is not possible, is there a way to get the values of the data points in the curve by selecting them. I know you can hover over the data point and it comes up in box, but i'd like those values to be actualy transfered into the spreadsheet.
The location of the data point will vary, so the system needs to be dynamic, i.e, I need to be able to select the datapoint then extract the x and y value.
I have a userform that allows users to review, input and edit data on a spreadsheet. (thanks to Leith for getting me started on it a while back)
I want to be able to assign names to columns so that they can be rearanged in the worksheet without interfering with the VBA/macro/userform.
For instance currently the VBA for the row = "R" (equating it to whichever row the form is currently on)