Office Software Forum
- Excel (9,762)
- Open Office (113)
- Outlook (641)
- PDF (334)
- PowerPoint (175)
- Word (2,186)
-
Excel count if Closed
Hello, I am a school teacher that give "Marks" to students. The "marks" are leveled from 1 to 3. I have been inputting students into a spread shee...
-
Copy data from one spreadsheet to another Closed
Hello, Can someone please help? ABC spreadsheet will copy the data to 123 spreadsheet, if there is no match find on Project ID, Name and Part. If ...
-
help with Isblank Closed
Hello, is there a way to use Isblank in such a way that if a cell is blank then do this formula, if not then keep the results that are already th...
-
Help with excel 2007 charts macros Closed
Hello, I have a macro that creates 3 charts. One is a simple bar chart and the other is actually two I've combined so that I have a bar and li...
-
Need an (average) formula Closed
Hello, I need this formula =average(F2:F300) to change when I filter names in column A. Please help. Excel 2007
-
Arrow key skips section?? Closed
Hello, I have Microsoft Excel 2007 and I have all cells locked except for the ones that can be edited. This will create a tab sequence for me.. ...
-
Adding new data sets to multiple worksheets Solved/Closed
Hello, I am creating a spreadsheet database for data to determine the best vendor to use. I have multiple vendors on different worksheets and the...
-
Flter twice on the same page Closed
Hello, How do I put more than one filter onto the same page please? Thank you. Sue Configuration: Windows XP / Internet Explorer 8.0
-
comparing each days sales Closed
Hello, I am trying to geerate this: There are volume of sales of a month and an average score which i have determined as 100%. On compa...
-
Macro To Copy Rows From One Worksheet To Anot Solved/Closed
Hi , I'd like to know if there's a macro that can be run to check one worksheet. In this worksheet there is a column where the value should be "true"...
-
copy rows from one worksheet to another works Closed
Hi , I'd like to know if there's a macro that can be run to check one worksheet. In this worksheet there is a column where the value should be "true...
-
One Button To Execute Two Macros Solved/Closed
Hello, I got one macro in Sheet1 and another macro in sheet2 under the same workbook.I want to assign a button in sheet1 so it can execute both the ...
-
Excel formula A+B=C with the following except Solved/Closed
Hello, I really could use some help please. I am working on an 2010 excel spreadsheet. Would anyone know if there is a formula to do the following....
-
Convert date format Closed
Hello, How to change date format from 72310 to 100723 ? Thanks in advance! Regards, Wong Configuration: Windows XP / Internet Explorer 6.0
-
Use Excel VBA to create an e-mail w reminder Solved/Closed
Hello, I create a file in Excel that does some calculations based on a small database and some user input. I then added a button to open an e-mail...
-
Overtime Calculation Solved/Closed
Hello Sir, I am having problem doing my work at office. I want to calculate the overtime hours of the employees. A1 is Time In where i...
-
Apply third formula after two anotner formula Closed
Dear sir, when I applied formula in Col-D, I got #value!. I shall be much obliged if any one solve my issue. I tried this Col-A Col-B ...
-
Filter all pivot table by same criteria Solved/Closed
Hello, I am using excel 2007. I have a data on sheet1: I had make 4 pivot tables from that data in four different sheets: Now I have ...
-
Find and mark serial numbers Closed
Hello, Is there a way I can have excel open a find box and once i do a serial number scan it will find the serial number let say in D5 then pu...
-
Excel - if cell = "xxx" then email me@me.com Closed
Hi there, Is there a code that can automatically send me an email if result = to something even when excel is not running but PC is on? Tks in ...
-
Toshiba password reset disk Solved/Closed
Hello, hi how r u good i hope anyway i forgot my password on my toshiba satalite laptop is there any thing i can do from home to fix this Confi...
-
Copy data into new workbook with constraints Closed
Hi, I'm looking to use VBA to copy data into a new Excel workbook using certain constraints. I have data on a worksheet called "Data" with multi...
-
Comparing cells in excel Closed
Hello, I am working on a formula in excel. I want to compare values on 4 different cells and return a value. When the values on columns A, B, C & ...
-
Codes Explaination Solved/Closed
Hello, I have an text in excel as below. 1 1 1 2 2 2 3 3 3 After running a macro Iam getting the result as below. 1 ...
-
Excel query a sheet of raw data and return Closed
Hello , I hope you're all having a good day so far. I however am not, I'm trying to pull certain data from a spreadsheet of raw data. It's an inves...
-
Link Excel file to MS Access and generate rep Closed
Hello, I have an Excel file with 1000 lines of Information. I would like to link this file to MS Access and have one windows wherein it will ask u...
-
$480 and 13% tax what is sub total? Closed
Hello, I have $480 and 13% of that is tax. What is the amount of the sub total? Please show the formula Configuration: Windows XP / Internet ...
-
join and connect forms together in access Closed
Hello, i have a problem, please help i have a tabel by very details (above 200 column) i design some forms .every form store a part of datas ...
-
Excel moving data from one cell to another Closed
Hello, Configuration: Mac OS X / Safari 533.19.4I have basic Microsoft excel skills and am making a spreadsheet for personal use. I have a li...
-
Combine two columns into one from two sheets Closed
Hello, I have searched and tried some similar examples but cannot find a fit that works .I trying to combine two sheets into one .can someone plea...
-
Macro to copy data from pivot table Closed
Hello, I have created a macro that creates a pivot table from set of raw data and performs some calculation on that data. Then I have to filter the...
-
How copy rows from multiple excels to one xl Closed
Hello, I am very new to Macros,Now i have one requirement i.e we have three different excel sheets in that when users update something based on the...
-
copy some columns from one excel sheet to oth Closed
Hello, I have got two excel files eg a.xls and b.xls i have to copy some column data from a.xls to b.xls . Both of these files have some common cl...
-
Copy rows and update cells macro Closed
Hello, I wonder if anyone could help me with this particular problem. I have a spreadsheet with a column that has a name and another column tha...
-
Macro to delete rows with certain values Closed
Hello, I am trying to delete rows that have specific values using a macro my problem is that I have several values that would mean that row needs...
-
Excel Help Closed
Hello, What is the formula for: If any cell in column B is in Column A, then display 0, if not 1, in C Thank you. Configuration: Windows ...
-
excell formula Closed
Hello, i am trying to find a formula so that if i put a value in cell a2 and a valu e in cell a3 then i want in cell a1 it to produce a value eg a...
-
Third column value from another table Closed
Hi! Saw the other Q&A in this forum but somehow have not been able to get resolution on this. I have two tables as below Table A ...
-
Excel opening error Closed
C:\programme filesx86\excel phone number format software.xla' could not be found. Check the spelling of the file name, and verify that the file locati...
-
Excel macro for comparing data Closed
Hello, Here is my problem. See below for example. (Workbook A) First name Last name Score A1 = John B1 = Doe C1 = 4 A2 ...
-
copy and paste information from a cell to ano Closed
i am just wondering how to copy and paste information from a cell to another document. i have a formula to figure out the sum of total boxes and i...
-
Macro to highlight a row if cells match value Solved/Closed
Hello, I sorry but I am very new to macros and trying to create one in Office 2003. I need to bold a row if for example column E is greater than a...
-
Forgot memory card password Closed
Hello, i have lost my Nokia 2 GB password, pls help!
-
Count if macro on multiple criteria Solved/Closed
Hello, Could someone please help me out with a count-if macro on multiple criteria. I have attached a sample file in the below link http://ww1....
-
Number convert to word in excel which formula Solved/Closed
Dear Sir, Please help me number convert to word in excel which formula Hello, Configuration: Windows XP / Safari 534.13
-
help with excel Solved/Closed
Hello, i have two speadsheets. the first sheet contains a total column EX: in C4 =SUM(E4+G4+I4+K4+M4) Value of C4 = (339816) on the ...
-
macro not saving file in excel format Solved/Closed
Hello, I have a coding like this: filename = Range("B3").Value Workbooks.Add Set newwb = ActiveWorkbook ChDir "D:\P3\Jan-11\B2B" ...
-
New sd memory card password Closed
Hello, I have purchased a new sd memory card it asking password i unable to found it. i tried puting it in many mobiles and computers. In mobiles i...
-
Copy data from one sheet to a new workbook Closed
Hello, I have a data in excel and from which i made 4 pivot table on 4 sheets naming sheet1, sheet2, sheet3 & Sheet4. now i have to copied thes...
-
Problem in Excel Closed
Hello, I have a problem in Excel to which i seeking a solution. I have imported some External data using the Query option and I am able to Refr...
