Trouble with dynamic named range21510 (6/7/2010 5:34:35 PM) UtfIn an Excel 2010 workbook I created a dynamic named range from the Formula
tab using the Define Name utility. The formula I entered is:
=OFFSET(Price Groups!$AP$2,0,0,COUNTA(Price Groups!$AP:$AP)-1,1)
...
Deleting Duplicate Rows 06-07-10112495 (6/7/2010 8:06:22 PM) UtfHi,
I checked out the archives for close to an hour, but I couldn't figure out
how to change the codes given there to suit my needs.
I have a large set of data, from about A1 to X441. In column X, there ar...
How to do this with macro?22311 (6/7/2010 4:59:05 PM) ArtoI have several cells in one column, what include numbers (example B2-B4).
After few empty cells, I have a cell (example B7), what include formula
B4-A1.
A1 B1
1
2
3
4
5
6
xx ...
Need largest number61718 (6/7/2010 5:03:28 PM) UtfI have a file in Excel 2003. In 1 column I have a numeric field. In the
next column I have a 2 digit apha field. In the third column I have another
numeric field. For each row I need a formula in the 4t...
Re: How to do this with macro?01426 (6/7/2010 9:25:50 PM) Donoops. to find the last number in b and subtract a1
=INDEX(B:B,MATCH(9999999,B:B))-A1
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett@gmail.com
"Don Guillett" wr...
Sort Routine Macro for Excel Worksheet11569 (6/7/2010 5:31:30 PM) JCOI have an excel that requires a sort routine. I tried using the start/stop
recording. The code is shown below, however, I need this routine to work
when you don't know how many rows are in the data. My m...
Change event does not fire32671 (6/7/2010 6:06:11 PM) UtfHello!
I have a worksheet with checkboxes. Each checkbox is linked to a cell. When
checkboxes are checked/unchecked the cell changes, but the Change event for
the sheet does NOT fire! Is that how it is sup...
Save data before printing11675 (6/7/2010 6:43:44 PM) SagaHello all,
An acquiantence is programming in Excel 2003 and has a sheet
where theuser enters receipt data. When he is done, he clicks a
boton to copythe data from the sheet to another in tabular form
with...