Excel Forum
-
Browser and Address Bar [Closed]
When I click on my internet explorer on my desk top and go to my home page theres no address bar at the top of my page there to put anything in like t...
-
MS Excel 2007 Version [Closed]
Hi, does anyone know where I can find "Tools" in using 2007 version of spreadsheet? Thanks very much^^
-
COmpare COlumns Macro [Closed]
Hello, What I am trying to do is come up with a macro to compare 2 columns of data in sheet 1, columns A & B. One is a master list, and another is ...
-
WIFI 2gb netbook internet browser not working [Closed]
I bought a 7inch, 2ghd, 300RAM...netbook from ebay last week and connect it to LAN! The network is connected and I can sign in MSN too but everytime I...
-
Excel Error Message [Closed]
Configuration: Windows 7 / Internet Explorer 8.0 I've suddenly begun getting an error message when trying to export a Quickboos report to excel. Th...
-
in excel date,help to take time part away [Closed]
Configuration: Windows XP / Internet Explorer 7.0 hi i have query im not able to take time part from date and as below 29/04/2010 10:30 AM, i need...
-
transfer tally data to excel for editing [Closed]
i want the technique with which i cn transfer my tally data to excel sheet Configuration: Windows XP / Safari 532.5
-
excel formula! [Solved/Closed]
I would like to make an excel formula that if at least 7 out of 10 cell (i.e A1 to A10) are greater than 5, then return as " accepted", otherwise "...
-
Selecting the required cells info from the co [Solved/Closed]
Hi, I have a data like below in one column in excel: SL#00000 Product: ABC Region Name: Name1 City :1 Country:1 User con: Id type SL#88888...
-
data Comparision in two worksheet in exel [Closed]
How to compare the data in two worksheets in exel.
-
Conversion of values already present in cells [Solved/Closed]
Hi: I need to convert values already present in a range of cells to another currency. The current range changing causing headache. Any suggestions...
-
Excel Copy Paste [Closed]
There are Job titles in COLUMN A. There are a list of dates in COLUMNS G, I & K There is information in all the rows between A, G, I & K Ther...
-
Copy Paste - Excel [Solved/Closed]
Hi I have a spreadsheet with a list of job titles in column A. there are a list of dates in columns G & I. there is information in all the ro...
-
Excel - Display text w/ range of values [Closed]
I'm trying to get text displayed in a cell when the value is between a range of numbers. Example when the value of cell d18 is between 60% & 70% I wan...
-
excel query [Closed]
after entering 15 no. (123456789123456) when i insert 16th number its converts it into 0 tell me the solution Configuration: Windows 7 / Firefox ...
-
copy rows from 1 sheet, to multiple sheets [Closed]
I have a workbook I'm working on in Excel 2007. Sheet 1 has a list of students, location, dates attended, test score and so on. I want a function that...
-
Selecting a printer in an Excel 2007 Userform [Solved/Closed]
I am using the following code: Private Sub CommandButton1_Click() Application.Dialogs(xlDialogPrint).Show UserForm1.PrintForm End Sub I can...
-
Excel 2007 - Change cell color using If [Solved/Closed]
I have a cell with a % in it. I would like that cell color to change to red if the percentage is below 60%, and change to yellow if it is between 60% ...
-
macros to copy alternate rows to anothersheet [Closed]
Configuration: Windows Vista / Internet Explorer 8.0 Kindly tell me the macros to copy alternate rows to another sheet in excel
-
Lookup data on different worksheets [Solved/Closed]
I have 2 spreadsheets with the same town names in column A and different dates in column N. I have a third spreadsheet with the town name and have ...
-
Excel find a value <>2#'s &get a value beside [Solved/Closed]
Hi All, I want to enter a number in cell A1 (Sheet 1) and have a formula which gets excel to go to sheet 2 column A finds the two numbers the e...
-
How do I match to columns in excel 03 [Closed]
Hi there I have 7500 bar codes and price from two computer systems, I have managed to get both of them onto the same spreadsheet. Is there any e...
-
Vba to search and copy cells in row [Closed]
Hi, i need to know how to copy certain cells in a row. I have the vba to search for a value in column A, but i need to know how to do the following...
-
EXCEL FORMULA FOR FINDING PERCENTAGE OF [Solved/Closed]
Hello, I need a simple formaul for finding the percentage of Total number of members: answer in column A392 Total number of members who have prov...
-
Need Help in MS Office Excel [Closed]
I want to multiply cells A1to A190 to cells B1 to B190 and put the results of each row in the next column in (cells D1 to D190) and then copy and p...
-
excel drop down list [Closed]
Thanks for the reply but i have some more doubt. how can you add a third dependent list to this. For example i have columns with headings continent,...
-
how to copy data in excel [Closed]
Configuration: Windows XP / Internet Explorer 8.0 hi, Can any1 explain how to copy the entire row from one sheet to another if there is a matchi...
-
Partial match of cells in excel [Closed]
Hi, I have a workbook with 2 worksheets. Column A of worksheet 1 contains text data such as "Paracetamol/Codeine 500/30" in a cell. In worksheet 2,...
-
conditional hide rows in multiple sheets [Solved/Closed]
It didn't solved yet. I have one excel file with multiple sheets, and all of them with the same columns and rows . I need to hide specific rows in ...
-
excel drop down box [Closed]
hai evry1 i have small doubt regarding the use of microsoft. suppose cell A2 has a dropdown list containing football, basketball , cricket. wen ...
-
Vb code to extract selected range of cells [Closed]
Hi i need a vb program to extract selected range of cells to another excel. Ex: If i complete a row A1 - F1 and if i give "Update", it should copy ...
-
How to display formula in excel? [Solved/Closed]
hi everyone, for example i have A1=H and A2=G, and A3=A1+A2 how do i make A3 show a final result of "H+G",display text instead of calculating the form...
-
Excel Skipping a cell when calculating a tota [Solved/Closed]
i have a series of codes back and forth it seems a bit insane. but what im wanting is for cell b1 c1 d1 e1 and etc to add together wich i have the fo...
-
Excel problems with copying a formula [Closed]
My excel is behaving funny. When I copy a cell formula across the row or column, it copies the formula correctly, but does not give the corresponding ...
-
Excel [Closed]
Hi i want to format the cell value like this 1 A 2 A 3 A 1 B 2 B 3 B 1 C . . . any easy way? Thanks in advance
-
VBA msg box problem.. [Closed]
Hi, how do you change a msg box option from Yes and NO to 1 and 2??? Thanks in advance! Excel 2003 Configuration: Windows XP / Internet ...
-
copy paste macro [Closed]
Hello all , I need a small help in doing macro. can you please any one help me ? for example:- In sheet1 i have data from A1 to A4( this ...
-
Break [|] pipe delimited values in rows [Closed]
I have a text line containing information separated with pipe sign [|]. Kindly provide me a macro/code to break them into: a. Each broken value shou...
-
SORTING DATES IN EXCEL [Closed]
Hi, I am trying to use a spread sheet to automate my family tree. I have a birth date like 2/2/1880 and a death date of 3/8/1900. The censuses run in ...
-
<Select multiple rows by criteria in Excel> [Closed]
Windows XP / Firefox 3.6.3
-
Combine data of Multiple cells into one cell [Closed]
I have a list of Records in Excel sheet in a following format. Each record contains more than one Row. Each new Record starts from number Zero [0]. N...
-
Excel copying text [Closed]
Hi, Hopefully someone might be able to help. Can you tell me if I can copy text in one worksheet to another continuously? All the text is in the s...
-
Copy rows into asheet when checkbox is select [Closed]
Hello, I am setting up a workbook to track software as part of a project, I need a macro that will copy data from a row if a checkbox in coulum j i...
-
Macro Assistance (Remove First number) [Closed]
I have an excel speadsheet that is sent to me daily with numbers in column A (example: 1.1.2.1.1). What I have to do everyday is delete the ...
-
Macro to read most recent row of data [Closed]
Hi, I'd to create an Excel macro to read the last line of a spreadsheet with data and transfer that data to another worksheet in the same workbook....
-
date and time macro for excel spreadsheet [Closed]
I would like to insert the date and time in a cell on an excel spreadsheet with the click of a button every time I make updates to the spreadsheet. I...
-
Formatting Cells based on previous cells valu [Closed]
I want to be able to highlight a cell based on the previous cells value. Example: if cell D1 is 450 and cell E1 is 480 then I want that cell to turn...
-
Excel - Macro repeats on Worksheet Change [Closed]
I have set up a worksheet change event that will run a specific macro when a number is put in a specific cell. Private Sub Worksheet_Change(ByVal ...
-
Compare cell against multiple columns [Solved/Closed]
Configuration: Windows XP / Safari 532.5 Hopefully I can explain this as simply as possible. First here is what my spreadsheet looks like I have sepe...
-
VBA code to select particular tab.... [Closed]
Hi does anyone know the vba code to find particular tab if it is todays date. e.g. i have a list of tabs on a spreadsheet dated from 1st to 31st...
Subscribe To Our Newsletter!
DON'T MISS
- How to Create a Gmail Account
- How to Fix a Blurry Snapchat Video
- How to Get Free Diamonds in Free Fire
- How to Recover a Disabled Facebook Account
- Facebook Code Not Received
- Computer Boots to Black Screen
- How to Upload High Quality Photos to Instagram
- How to Disabled Write Protection on a USB
- How to Install a VPN
- How to Recover Your Yahoo Account
- How to Get More Followers on Instagram