Office Software Forum
- Excel (9,843)
- Open Office (114)
- Outlook (647)
- PDF (334)
- PowerPoint (184)
- Word (2,189)
-
convert multiple rows and columns to one colu Solved/Closed
Hello, I have some data in excel sheet. Here is the example. 480,000 600,000 720,000 520,000 650,000 780,000 300,000 375,...
-
Excel formula Closed
Hello, I want to set up a formula to send information from one sheet to another in the same workbook. The information in the source worksheet is...
-
2010 Excel Cell Color Changing Closed
Hello, I have a spread sheet that has due dates, I want to change color of cells to reflect time due eg: time of due date red 5 days before due...
-
color code excel cells according to scores Solved/Closed
Hello, How do I color code cells in excel ti turn colors according to scores--such as red (0-69%), yellow 70-89%), green 90-100%)? Thank you, E....
-
Match Excel Columns containing names Closed
Hello, Using Excel 2010 and I have 2 lists - 1 from phpmyadmin with a list of names entered by my users and a second list from my courier company ...
-
Updating 1 excel spread sheet usng 2nd sheet? Closed
Hello, I have 2 excell spread sheets, bothare mailing lists. i woould like to match firstand/or last names from the 2 lists inorder to be able to u...
-
Can i delete text up to a character in excel Solved/Closed
Hello, Is there a way of deleting all the text up to a certain character in excel. i im trying to import a CSV file in to exchange and need it tyding...
-
Excel - Fill column in list based on criteria Closed
Hello, I am trying to fill a column in a list, based on criteria. Example: In Table 1, I configure the criteria: If string contais "aaa" ...
-
compare columns Solved/Closed
Hello, I have a situation like below. Column A Column B Column C A1 1 A2 ...
-
Excel: Match data/copy to another worksheet Closed
Hello, Can someone help me with this please? : ) I'm using 2 worksheets: On 'Tab A' I have: Column A Column B Notification Product Even...
-
memory card password forget Closed
Hello, my 2GB memory card password will be forget pls help me C2-00 mobile model number Configuration: Windows 7 / Internet Explorer 8.0
-
Excel-macro to group by column & sum value Solved/Closed
I was searching your web site for an example of how to group two columns and sum two different columns. I found an example under the question "Excel ...
-
Excel macro question Closed
Hi, I was wondering if anyone can help with a macro that would search for a value entered in a dialog box within a number of worksheets and then p...
-
Average Closed
I am using Excel 2007 to find out the average miles driven in a year and the average rate paid for those miles by Employee. However sometimes they are...
-
compare two excel sheet Closed
Hello, i want to compare two excel sheets if the row in second sheet is not there in the first sheet i need to copy that row from second sheet...
-
Need support VBA stuff on Excel Closed
Hello, I am nani and i have no experince in VBA scripting now i wanna phase out my self to learn Macros VBA with Excel as my most of the day work ...
-
Calculate each number is 1st time happen Solved/Closed
Hello, Pls do help me.. By using what method ( Auto calclulate ) that can help us to find out each number is first time happen ? Eg: Cut Apple ...
-
Autofill in a variable range Closed
Hello, I'm working on a macro in which I have to add a row or a column, and they can be inserted anywhere in my sheet. I managed to add the rows/colum...
-
VLookup Closed
Hello, I'm working with two formulas and trying to make one formula out of them! I can't seem to find a way of putting the two together! I'm ...
-
Data Replication using macro Solved/Closed
Hello Experts, I have a requirement as follows: User data Entry: Column1 Column2 Column3 Colulmn4 TIME JAN FEB MAR INDIA Bangal...
-
Excell help needed Closed
Hello, I have next problem in Excell, I have columns A1, B1, and C1 with data like this: A1 B1 C1 ABCDEF 4444 ...
-
Pop up VB in excel 2010 Closed
Hey guys, I have a large excel file with tons of information about my employees. I need a way to have a pop up to remind 3 months in advanced for w...
-
auto filter Closed
Hello, I have a file, where there are datas in 18000 rows. I am trying to do auto filter but it is not working properly. it is not taking the ...
-
IF statement help Excel 2010 Closed
Hello, This forum seems very helpful... I'm working on a spread sheet and have run into a wall with a specific IF statement. I want the cells i...
-
Saturday as workday Solved/Closed
Hello, How do I get excel 2003 to include saturday as a weekday? I can't get workday or networkdays to include it.
-
C+P macro to dest. based on value Closed
Hello, I'm still learning Macros and the like, and have had some luck learning the functions for what I have need in the past. What I am tryi...
-
How to select signature for outlook mail Solved/Closed
Hello, I am trying to select signature (by browsing for a signature file) to new mail in outlook-2003 using with XP but unable to selct it. Please i...
-
memory card pasword recovey Closed
Hello, hi, i forget my memory card pasword using nokia handset 6303 plzzz help Configuration: Windows 7 / Safari 535.2
-
Not able to hear sound from any browser... Closed
Hello, I am working on 64 bit computer.IE 9 windows 7 . The procedure said did not work fine. "It says the specified file is not a registry file...
-
Create a list based on input cells. Closed
Hello, I am trying to create a vertical list based on cell in sheet2 with various data in sheet1 example file is saved in : http://www.editgr...
-
i want remove my password Closed
Hello, i use nokia 3110c with 2GB micro sd memory card and lost my memory card password.how to remove my password without lossing my data. please ...
-
Conditional Formatting MAX excluding Subtotal Closed
Hello, I am trying to apply conditional formatting to cells to see the max and min of the column. However within the column there are multiple subto...
-
going from one excel spreadsheet into others Closed
Hi everyone, Another newbie here. I have one main excel spreadsheet and I need a macro that looks in a specific folder with 48 individual excel...
-
Missing Data Closed
Hello, i have a list of dates from 1956 to 2006 for precipitation recordings, i want to identify which dates have no data input, btw there are day...
-
VB question Closed
Hello, I need some help with excel. I have a work book i am trying to copy specific data from to another blank work sheet. The first workbook i wi...
-
please help me ... "problem while printing" Closed
Hello, I am having problems with my page margins when I print documents in microsoft Word 2007. when I am creating the document it appears centred...
-
Excel 2007 Data from many spreadsheets to one Closed
Hello, I'm trying to make a compilation spreadsheet inside a workbook (Excel 2007). We have data from 83 different facilities that each have ...
-
Copy cell with more than 921 charcters Solved/Closed
Hello, I wrote a vb code to copy all rows where column B contains "RW". The code first deletes any data that the sheet might already have. Followi...
-
Problem with Excel vlookup table array Closed
Hello, I did a vlookup which worked well however, when I opened the spreadsheet and it asked me if I wanted to update, of course I clicked yes. ...
-
Open a new workbook and populate form Closed
Hello, I have a "data" sheet with customer information that is updated automatically all day. When a new line of data is downloaded to my "data" ...
-
Auto populate numbers Closed
Hello, I am very new to this and but believe that anything can be created and simplified with computers. I am creating a holiday schedule where I...
-
Excel: If date changes Closed
Hello, Here's what I want to do. I have a Column where I change the date and I want certain cells in this column to extract different informati...
-
copy-paste to fixed cells macro searchvalue Closed
Hello, How are you? I've been looking for some help in the forums because I'm new to macro programming and have to develop some sort of line code...
-
Macro for copying data onto another sheet Closed
Hello, I have a workbook that contains 8 sheets of different states. These sheets have data of five differenct products' sales and achievements fi...
-
How to copy and paste based on quantity? Closed
Hello, This is first time I ever need to ask question on Excel. I got a problem which is very time consuming and it would be helpful if there is a...
-
Split data from one sheet into many sheets Closed
Hello, I have extracted data from our accounting database (account code, journal number, reference, date etc). Now I want to split the data so tha...
-
Calculation Add Up Closed
Hello, I'm trying to get the formula for the above calculation however I cant figure it out. I'm trying to add 20% only when the total amo...
-
Notifications on excel Solved/Closed
Hello, I would need your help to create a notification on excel. I've got a row of date's and when the date is 90 days prior to the expiry dat...
-
Excel cell search and enter value Closed
Hello, I need help constructing a formula in Excell 2007 that will do the following - search the spreadsheet for matching number - if it f...
-
Suma Closed
Hello, I have two columns in excel sheet. column1 , 2 1541671 A 1541672 A 1541673 A 1541674 A2 1541675 A 1541676 B 1541677 C 15416...