In a workbook used to track rental income, one column shows the expected income amount for a month. On rare occasions, i will indicate that an additional amount is due by adding the additional amount to the standard rent. On rare occasions, I forget to remove the additional amount in the next...
I would like to have a bottom border on the cells above each page break. Is there a way to test for page breaks using conditional formating? Or, if there is a standard number of rows per page, can this be used?
Thanks
I would like to copy series of tables along with any Named Cells within those tables to another spreadsheet. The destination SS already exists and includes some complex, protected imbeded macros.
Is this possible?
Thanks
Tom
A number of contributors ( XLBO, SkipVought and KenWright come to mind; I apologize to those I don't remember ) have made an effort to help others learn the benefits of using the database and pivot table approach to collecting and analyzing volumes of data. The concept is excellent. My question...
I am using W/XP and Excel 2002. In one sheet only of a 5 sheet file, when I enter a date, i.e., 4/13/4, Excel makes it =4/13/4. Other sheets and other files are ok. What setting is causing this? I have reviewed Tools|Options and did not see anything obvious. The cell formating is set to a date...
With a base of Win/XP Prof. and Excel 2002, I entered some test data in A8 thru F15, did an insert/name/define, used a name of "testrange" (w/o quotes), and entered the following formula;
=OFFSET(Sheet1!$A$8,0,0,COUNTA(Sheet1!$A:$A),6)
in the refers to field. My questions are;
1...
Is this the proper forum to request web beginner info? If so, where can I get how-to descriptions of where/what folders to put web pages for a new web site? We have a W/2000 server running, with IIs service running. What non Microsoft technical websites offer this kind of info?
Thanks
In an Excel environment, when changes are made to the standard toolbar, such as adding a button with a macro assigned, where is this information recorded, and can it be retrieved after a technician has uninstalled the previous version of Office, and installed a new one?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.