Office Software Forum
- Excel (9,724)
- Open Office (111)
- Outlook (635)
- PDF (334)
- PowerPoint (174)
- Word (2,181)
-
Excel Macro to find perticular column name [Closed]
Hello, Ii have excel having column names in row#1. I want to write excel macro that will look for column name anything that had 'ID' or 'AMT' i...
-
how can find unique data [Closed]
Hello, I have a data from April 2008 to Feb 2011 and i have to find no. of unique member visit every month. every member having a card no. and he/...
-
merge more rows into one [Closed]
Hello, i want to combine more rows into one based on the same first cell which contains the same number ex : 529251 0 2456018 6 529251 0 2456019 ...
-
Compare sheet 1 & Sheet 2 pull any items that [Closed]
Hello, I saw this posted earlier... did you ever respond to this? +++ Your macro has been a great help to identify the matching records- th...
-
sku011.cab missing [Closed]
Hello, I Tried to run regedit, BUT....... I can only expand up to OFFICE, After that there is no 11.0 What can i do? THANKS Con...
-
Copy row to next available row in another wb [Closed]
Hello, I am trying to copy row to next available row in another wookbook. I have the follow codes, but not sure why it skips 3 rows every time, th...
-
Vlookup [Solved/Closed]
Hello Sir, In Sheet1 I Have Numbers Like A-----------------B------------ 4050 6080 9060 And In Sheet 2 I Have Data Like: A--------...
-
Macro to format cells [Closed]
Hello, I hava excel data exported from a community page whihc will look like ttetetert -Row 1 yyyyyy Row 2 ...
-
Run a macro on another open application [Closed]
Hello, I have a list of account numbers which needs to be keyed on another application named CBS - "Core Banking System.WS - [24 x 80]" I had r...
-
excel help formula which capture this as Prod [Closed]
Hello, Can you please help me on this: The below data is in sheet 1: Products DATES VALUE A 2-Jan 1 B 2-J...
-
find, select, copy, paste elsewhere in para [Solved/Closed]
Hello, Can anyone help in the following matter: How to find, select, copy and paste elsewhere the paragraphs containing specific terms in...
-
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...
