Excel Forum
-
excel date format to be change [Closed]
WOULD LIKE TO CHANGE THE DATE 07.05.2010 TO 07-05-2010 FORMAT
-
Insert rows with data when criteria is met [Solved/Closed]
Hi, Thanks in advance for your help. I have two tables. If a field in table A is chosen, I want a macro which will insert rows of the data listed ...
-
How to map Excel files to a common Excel file [Closed]
EXCEL: I need to extract certain columns from different active worksheets (4-5 files) into one summary worksheet. The exact column headings may or may...
-
Copy Comments from Sheet to Sheet [Closed]
I am using this formula: =IF(ISBLANK(Master!A1),"",Master!A1) If A1 on the 'Master' sheet has a comment, how can I bring it to the sheet I am u...
-
Input a range of cells [Solved/Closed]
If i want to highlight a row of cells in red to show a lead is dead say A1 to E1, buy inputting "lose" in E1 I now have the formula =$A$1="lose" whi...
-
help with counting in Excel with a condition [Closed]
Hi, I would like Excel to count a range of non-blank cells and enter the number but if all the cells in the range are blank, I'd like it to fill in w...
-
Macro Assistance [Solved/Closed]
I have a spreadsheet that has data ranging from C3:C263. Workbook is 'GSU CAS Transactional Upload', Sheet is called 'Alliance Upload' I need to...
-
Spreadsheet Comparison [Closed]
I have a project that I am working on. Although the example uploaded is very simple, it's what I am looking for. I have a Master 'Sheet 1' and a Val...
-
EXCEL MACRO TO REPEAT AND INSERT ROWS [Solved/Closed]
I am trying to write a macro that will insert rows as follows: Col 1 Col2 Col3 1 S 456 2 A 222 3 M ...
-
Help I am making a macro in excel [Closed]
I am trying to creat a macro. I have a Graph on its own chart page. I want to be able to click on a box on the graph page and have it take me to the...
-
Macro for array vlookup to worksheet [Solved/Closed]
Looking for help with a quick macro please. I have four tabs in the workbook: Datadump - contains daily raw data to clean Central - Accou...
-
Move rows to a new sheet [Closed]
Hi, I have an sheet with thousands of rows. I am looking for a way to move all the rows that have similar data in the cloumn A feilds. Hope it is ...
-
Need help with excel message pop up [Solved/Closed]
I need Excel VB help to show a message pop up box to display whenever the value is below 10 or greater then 50 that's also not a multiple of 5 Con...
-
Excel Help [Closed]
I have two different Excel files, one with a complete list of serial numbers and one with some of the same serial numbers and also some that may not b...
-
Creating a Graph in Excel using drop downs [Closed]
I have a file, that we are tracking leads. In the file, we have several components, but 2 specific components I'd like to graph. We have a Date Colu...
-
to find cells with same values [Closed]
How to find cells with the same values in column 'A' ,how to add values of the corresponding cells of column ' L ' and put sum in column 'M' ? ...
-
Updating Data in two+ worksheets [Solved/Closed]
I have a question, I just created a spreadsheet with 8 tables which contain a deferent data and with Autosum column on each table and I created als...
-
Macro that shows the contents of a range [Closed]
Hello, I'm trying to create a macro that would show the contents of a range of cells. I would like to assign this macro to the botton on the forms...
-
Need help in excel... [Closed]
Hi All, I need to populate the columns(multiple columns) of excel with the values from the previous non - empty column. The problem I am facing is...
-
Macro to insert rows on click of a button [Closed]
I am trying to auto populate a list one below the other on the click of a button. A sample sheet of what I am proposing can be found at the followi...
-
Help sorting an excel sheet [Closed]
what formula or marco could I use to allow employees to just bring up their data on a spread sheet using their ID IE Col. D is all the IDS F and...
-
Bringing in 1 row - in Excel [Closed]
A B C 1 ND=5127558 NE =007-09-092 00426638 2 TY= KLA+ SR3 3 CAT= CAC17 1 ND=3...
-
pls help me with excel formula! [Solved/Closed]
Dear excel experts, I have a dataset of A1:A15. I want to make a formula stating that if 10 cells of the range A1:A15 are greater than or equal 2 ...
-
recovering downloaded excel [Closed]
I downloaded an excel document to my pc laptop from my school website(schoolloop) and made changes to it and then deleted it from the site folder(My L...
-
Reference number in excel [Closed]
Hello! I have two sheets in a workbook, Sheet1 is for summary with reference number (reference number is alpha-numeric), Sheet2 is the raw data. Is t...
-
how to display add'l rows based on dropdown [Closed]
Hi, I am trying to create a template with a series of questions with responses of Yes or No. A Yes answer would require further information. If th...
-
Locked cell and setting set focus in excel [Closed]
Hello Guys, How can I locked certain cell/s in excel? I've tried the "Protect Sheet" but all cells in my worksheet were locked. Also, I want to defin...
-
Matching Multiple Columns & Highlight Matches [Closed]
Hello, I need to match related columns A and B to comparison columns D and E. A and D are assigned codes and will be compiled of random letter, numb...
-
Rearranging data to another sheet in excell [Closed]
The excell in which i am having consists of lot of data. I need to get few particular calues out of it to another sheet. Ex.) Male ...
-
Excel Formula [Closed]
in a separate cell, i have a number. If that number is greater than 11, i want a certain entry. if that cell is >6
-
Excel (Searching, Finding and Returning) [Closed]
Hi I have not yet learned how to write working excel formulas very well, and I was looking for a short bit of help... I would like an arbitrary...
-
Excell VALUE error [Closed]
Would you be so kind as to evaluate the formula and see what I did wrong. It returns a VALUE error. I tried the evaluator, but im not clear where th...
-
Combining data from 2 worksheets [Closed]
I have 2 worksheets that I am working with. They have very similiar information, but what I would like to do is combine them. The common factor is t...
-
Excel-macro to auto populate value in cell [Closed]
Hi, I am new to Macros.I would really appreciate if someone can help me with the following problem. I have created a validation in Column c a...
-
copy & paste filtered columns [Closed]
Hello, Since changinging to windows 07 I can't work out how I can copy & paste in a filtered column without losing the formating of individual cell...
-
Excel multiple functions in one cell [Closed]
Thanks for the help on the formula. I have one more for you. I would like one cell to look at four different arguments and return the result. Wha...
-
Execute Macro On Calculated Cell change [Closed]
Have tried several approaches, but nothing works Have a cell that has a formula and changes based on other cells - want to execute a macro when ev...
-
print macro for a cell list [Closed]
can you help to create a print macro for excel that will print the sheet continually after updating each time from a cell on a different sheet Config...
-
how i can choose some number from the excel [Closed]
dear all, I am working on excel, situation : I have write different item names in one coloumn say coloumn a, and all the disciption of these items ...
-
multiple sheet formatting based on cell info [Closed]
I have multiple spreadsheets. I want to creat a formula/format so that when I color a particular cell on the first sheet, any cells on subsequent she...
-
Macro to select & email [Closed]
HI, I have been trying hard to read all the posts here and find a solution to my problem but am not able to do so.. I have attached an excel ...
-
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...
Subscribe To Our Newsletter!
DON'T MISS
- How to Get More Followers on Instagram
- Facebook Code Not Received
- How to Recover Your Yahoo Account
- How to Install a VPN
- How to Get Free Diamonds in Free Fire
- Computer Boots to Black Screen
- How to Create a Gmail Account
- How to Recover a Disabled Facebook Account
- How to Upload High Quality Photos to Instagram
- How to Disabled Write Protection on a USB
- How to Fix a Blurry Snapchat Video