Excel Forum
-
Dropdown lists in excel 2007 Solved/Closed
Hello, I want to create dropdown lists in excel, it should work as follow:In cell2,1 must be a drop down list with 4 names (e.g.Mill,Comp,Loads,Blend...
-
need help from excel formula Closed
Hello, I want a formula in excel : in a worksheet ina single cell an amount will display which will be written in another worksheet . Example...
-
I need to replace jpg description with a number Closed
Hello, I have thousands of jpgs that are named by a product description, like Beltwayjacketblack.jpg, and I need to replace jpg description with a p...
-
Conditional formatting Closed
Hello, If cell P5 is greater than Q5, I need cell R5 to equal Q5. If P5 is less than Q5, I need cell R5 to equal P5. Any help would be appreci...
-
Selection of Data from multiple sheet Closed
Hello, I am facing a problem, regarding selection of specific rows from multiple sheet in a single workbook. Details: I have a workbook with...
-
input search and jump to cell Closed
Hello, i am trying to create a search field cell where i input my data, that i want to search for, as soon as i hit enter it finds and displays m...
-
Using Vlookup to return insted of 00/01/1900 Solved/Closed
Hello, I am using a Vlookup to return values within a sheet using cell A2 as my reference some of the data that I am returning via the lookup are ...
-
Excel 2010 - Macro for filling in Top half of several Excel form Closed
Hello, I have about 14 Excel 2010 forms that lines 2-6 contain the identical information, after filing in the information in on the first form, I ...
-
Formula for Between to Dates Solved/Closed
Hello, Hi, I am looking for a date formula that will tell me if a date in a cell is between to dates In column "A" I have a list of dates and in c...
-
conditional transfer of rows to another sheet Closed
Hello, I am working on a production worksheet. Sheet1 is called "Lead Input" and contains columns of names, addresses, prices, etc. There are two ...
-
Balancing totals from two workbooks Closed
Hello, I have tried some pivots, some access but still no solution. I have data coming from two different sources. One has a breakdown for some...
-
Hide the formula Closed
Hello, I am creating an excel sheet where I need to have a cell show 55% of a number that will change weekly. How do I set it up where the original...
-
Conditional Formatting Closed
Hello, I'm using Excel 2010 (not sure whether or not that matters) I'm not very familiar with conditional formatting, so I need help with somethi...
-
Looking For a Value in a Cell Closed
Hello, I am using the following formula below =IF(OR(A1=" ",B1=" ",C1=" ",D1=" ")" ",G1) What I am trying to do is if all the cells are blank ...
-
one cell will turn green when the two other cells match Solved/Closed
Hello, I am keeping a register of staff in our department. What I want to happen is for the cell (where the name is) to turn green when the date ...
-
=month(d2) Solved/Closed
Hello, Empty cell in Excel file has changed in the month, while 0 is 1 reply should have come to help please Configuration: Windows XP / Chrome...
-
Adding specific days to date Closed
Hello, Configuration: Windows 7 / Internet Explorer 9.0 how to add 21 days to date 25.02.2012 in Cell A1 in excel 2007
-
Macro to email picking up email address in one cell using lookup Solved/Closed
Hi can anyone help me I am using the VBA below to email a results sheet to various people,the code that I have will only allow me to email to one pers...
-
duplicate data from on tab to a master tab Closed
Hello, I need to create a work book wit 5 tabs? The 1st tab will be a Master Page and the 2nd,3rd and 4th will be data inputted by other users,...
-
returning value from column b in column c, in a cell ajacent to Solved/Closed
Hello, BHID MN Samp 47.86 Samp 50.24 Samp 41.63 Samp 49.34 Samp 48.19 Samp 53.11 Samp 50.98 Samp 49.07 Samp 48.05 Samp 52.96 Samp 41...
-
How to download? Closed
Hello, I want to down load Excel and Microsoft Publisher Configuration: Windows 7 / Internet Explorer 9.0
-
Recovery my work and restart microsoft excel Solved/Closed
Hello, everyone i have a problem with my excel while I start this program then open the file in MS Excel. Excel pops a message saying "MS Office ...
-
compare data in seperate columns to find likely matches Solved/Closed
Hello, I want to compare data in columns which essentially is the same but worded different. For Example Name of Person County...
-
No tool bars or address bar on my browser Solved/Closed
Hello, I don't know what I did, but my address bar is only visable when I drag my mouse up to the top of my screen and my toolbars have disappea...
-
Excel function Closed
Hello, please i need your help in the following problem I have one worksheet contains many colums, rows, and calculations as follows: empl...
-
Code for macro that conditionally inserts rows Solved/Closed
Hello, I know this has been asked and answered often, in particular here: https://ccm.net/forum/affich-222200-insert-rows-on-change-of-value-in-excel-...
-
HELP!!! CONDITIONAL FORMATING Closed
Hello, I have a spreadsheet (d2:d7) with 2012 prices in column D2 and 2013 prices in column D3 for the same product...what i want is if D2 is bigg...
-
Excel if function: less than date Closed
Hello, I need a what if formula to satisfy the following: if date in K34 is before 23 Nov 2012, then AB34 = yes and so on.. i.e date in K35> 23 N...
-
excel for mac opens all files on desktop Solved/Closed
Hello, Whenever I open any Excel file, Excel opens every file on my desktop as well (excel or not). I have to wait until the whole bunch load up, t...
-
is there anyway to use VLOOK with index Closed
Hello, I have hard time to solve this: I have problem like this: 1st worksheet I have a table similar than this: A B C D 1 D...
-
Can't open Excel file Solved/Closed
Hello, I'm running a Mac (10.5.8) and am having trouble opening a recently created Excel file. I was able to open the file since the first time I ...
-
IF statement errors and using multiple IF statements. Solved/Closed
Hello, I am self teaching excel spreadsheets, and I would really appreciate some help to anyone that would graciously be willing to offer it. I ...
-
comparing two xl sheets Closed
Hello, I have two excel sheets. A and B A has two columns col1 ,col2 B has two columns col1 and col3 i want create new sheet which has col1 ,...
-
Conditional formatting of cell in other worksheet dependent Closed
Hello, Hope I make this one clear. I am working on a workbook created by a another and here is what I am trying to achieve. An item selecte...
-
Can this be done? If Yes, How? Closed
Hello, This is my beginners attempt to write VBA code (I just wrote a macro to write MsgBox "Hello World" :-)) Please chk the Following ex...
-
Writing rule in ms excel using vb Closed
Hello, my question is...i'm having huge customer list mails in the format ******@***.es.us ******@***.es.in ******@***.net.us ******@...
-
how to expert office excel work Closed
Hello, I'm Salman i live in dhaka. i work in a company. some time facing many problem to office excel work. Pls told me to how to improve excel wo...
-
Conditionnal formating for more than 3 colors Closed
Hi, I need some help with conditionnal formating. I have 27 conditions and for each I need a separate color. 1,0-2,0 2,0-4,0 4,0-6,0 6,0-...
-
merging more cells into one cell Solved/Closed
Hello, how to merge 3 cells into 1 cell? we tried and tried but we didn't get it.. even the formula, we don't know.. we are just a first timer. w...
-
how can calculate days between twodates Solved/Closed
Hello, I HVE TO CALCULATE THE DIFFRENCE IN DATE. e.g: there is a two coloums as per below, purchase requisition date purchase order date ...
-
How to insert & resize picture automatically Closed
Hello, Configuration: Windows 7 / Chrome 24.0.1312.57 Sir I have an Excel 2007 file named "DTPH.xlsx" with data having person names, details i...
-
Insert row with formats and formulas Closed
Hello, I am curretly trying to write a macro, that will insert a row on the next available line, keeping the formulas, formats, (including some co...
-
recurring billing fee Closed
Hello all, I was wondering if anyone knows a way to have Excel add a monthly billing charge to invoices. I need something that would automatically...
-
organisation chart preparation Closed
Hello, how to prepare organisation chart Configuration: Windows XP / Firefox 18.0
-
Macro to count the answers in a table Closed
Hello, I have a problem in macro in Excel. I am working on a file that counts the number of responses (0 or 1) of a certain type under certain que...
-
Comparing sales Closed
Hello, I have two separate Excel spreadsheets (e.g. 2011 sales & 2012 sales) with the following columns: Customer ID, Customer Name, Product #, Sa...
-
Macro to download certain files from a webpage Closed
Hello, I am trying to find a way to download a number of files that exist on a webpage (the names are in sequence, e.g. abc202, abc203, abc204...e...
-
changing cell formats based on another cell value Closed
Hello, I was having difficulty in solving this problem. say: I have a dropdown on A2, text1, text2, text3 when you selected text1 the format...
-
Transferring data from one sheet to another Solved/Closed
Hello, I have been using Excel for a number of years but fairly new to formula etc. I need a VBA code that can copy data from costing(raw data) to ...
-
convert text mixed numbers to spelling Closed
Hello, i want to know how can we convert in excel the mixed numbers such as 1ZXV78 to "one ZXV seven eight".. can some one help on this task, ...