Excel Forum
-
IF Function in excell Closed
Hello The cost of insurance is based on the value of the artwork. If value is greater than $500, then the insurance is 25% of the value; otherwise t...
-
Copying different worksheets data & updating Closed
Hello, I am looking for a Macro that can help me with the following: I create several worksheets in the same document everyday. Every worksheet ...
-
Combine Excel Sheets from folder into 1 book Closed
Hi Ya, I have a number of workbooks in a folder which I would like to combine certain cells of them into another spreadsheet. The cells I need fro...
-
Picking up information from one excel sheet t Closed
Hello, I have a excel work sheet with a list of products with code numbers and differenct characteristics of the each product in different columns of...
-
Extracting data from 2 or more excel columns Closed
Hello, I've got a spreadsheet that looks a bit like this (only with loads more data on it): GENDER LANGUAGE LEVEL Male ...
-
Needs help to compare 2 excel Worksheet Closed
Hello, I need some help. I need to compare 2 worsheets. I need a macro that looks (compare) all the values in both sheets and then open a new work...
-
browsing for free on my laptop Closed
Hello, i will like to help me in browsing for free on my laptop without paying any subscription to anybody
-
comapare two columns containing date and time Closed
Hello, I would like to comapare two columns containing date and time data to is if the match. If the don't, i would like to return a value i.e. "1"...
-
Need an excel genius Closed
Howdy. I hope you guys can shed some light on a tricky situation and I shall try to explain best I can. I have an excel document where one of the t...
-
Excell 2003 Advanced Filter Unique Items Closed
Hello, I am using the Advanced Filter to identify the unique items from four columns and paste into four new columns on the same tab. The problem is...
-
browser problems Closed
Hello, when i try to open my an 2 error messages appear: 1) AVG Network scanner Service has stopped working. 2) Windows Explorer has stopped worki...
-
excel subtraction Closed
Hello, hi im trying to subtract a numer in 1 cell to a number in anuther cell but when i type in the furmiler it dont work can any one helpConfigurat...
-
Open excel workbook using a macro Closed
Hi, Can some1 help me open a workbook using a macro from another workbook. Im working in two.xls and need to run a macro and open workbook one.xls?...
-
Export or email excel worksheet Closed
Hello, I'm trying to write a Macro so that I can use a command button to automatically export a range of cells from a variety of sheets in a workbook...
-
Excel Formula Closed
Hello, i have a gradeing scale on one sheet, and on the other, i have my grades as percentages, and the amount of points the assignment was worth. I ...
-
excel formula Closed
Hello, I need a formula which can display the contents of two cell to one but with the same format. I mean if the Cell has the text AB001 with AB ...
-
cell input to call macro in adjacent cell Closed
Hello, I have a scenario that i'd like automated. The scenario is as follows If i enter a value in any cell in a particular column, i want the s...
-
QUESTION ON HOW TO WATCH DSTV AND BROWSE FREE Closed
please sir, i saw and witness the good works you guys had been doing and i want to use this opportunity to recommend you guys ,you are making us prid...
-
Excel Help Closed
Hello, I need to copy a formula using data from another column, but I need to do this for the whole sheet: Let's say my formula is --> ='Sheet1 ...
-
Needing Excel Macro for Copying& Paste Spec. Closed
Hello, In Excel....I need a macro which copies the entire row based on a condition (if) and paste just the values of that row into a different work...
-
Excel formula to get all values Closed
Hi Gurus, My head is really spinning on this one I can't seem to make it work! I have tried the lookup functions and none seemed to work. Please do...
-
To highlight duplicate rows with some colour Closed
Hello, I am rashmi. i need your help regarding, to identify duplicate rows in excel sheet and highlight the same with some colour using macro program...
-
Prob Reg. Excel Macro.. Closed
Hello, I have a prob regarding Macro of excel 2007. suppose i have a Excel tab(xyz) which have some column(name, add, Date). i want to create a mac...
-
Find cells with certain characters in it Closed
Hello, I am trying to get an if statement together that basically says if a certain character is in a cell then set to true, if not set to false. T...
-
Help for Excel macro to only copy data in the Closed
Hello, Allow me to thank you in advance for any help you give me, it is really appreciated. I am trying to compile a spreadsheet of variable dat...
-
Copying rows into a different sheet. Closed
Hello, Heres what I am trying to do. I have a workbook with a "master" sheet that I enter all of the info on. I have other worksheets that have only...
-
i cant browse.. Closed
Hello, First of all,i am sorry about my english.I have the same problem.Safari and firefox dont work but internet explorer and skype work.I have trie...
-
How do you map / arrange 2 Excel flat files Closed
Hello, I need to map one Excel (or could be Access) flat file into another Excel (or Access) file. there are many common fields (cells) but are no...
-
COUNT # ROWS where 2 conditions are true Solved/Closed
Hello, I am having problems counting the # rows of problem reports where the priority = 1 and the PR is active. here is the array: PR PRIORI...
-
Excel 2007 Formula Help - if cell is empty... Solved/Closed
Hello, Simple formula of =J3-SUM(L3:X3) BUT if J3 is empty then I want the formula to run as =C3-SUM(L3:X3) What is the proper formula to get t...
-
excel - send result of formula to another cel Closed
Hello, Is it possible to have the results of a formula go to a cell other than the cell containing the formula? And I don't want to do the '=c5' t...
-
excel issue Solved/Closed
Hello, please give macro for hiding blank rows
-
to increase browsing and downloading speed Closed
Hello, i am using reliance netconnect highspeed 1x, it gives me 180kbps browsing speed and 4-6kbps downloading speed, but it reduce now and gives me ...
-
excel formula Closed
Hello, I want the formula which make the negative answer in "RED" and positive in "LIGHT GREEN" after "ADDING" OR "SUBTRACTING".
-
EXCEL: Nested IF formula question Solved/Closed
Hello, I've read some answers to similar questions, but not quite the same... How can I have *certain* results of my nested "IF" formula display...
-
compare contents of 2 excell woeksheets Closed
Hello, I am clueless about VBA Programming. I need help with a small piece of code. Following is my problem description... The first 3 columns...
-
if a1= active, copy a2-a6 to a1-a5 on sheet2 Closed
Hello, I am new to macros and would like to know if it is possible to create something to do the following: I have a list of jobs that are eithe...
-
Find copy and create new excel files w macro Closed
Hello, I would like to create a macro to save time. I receive data which I then have to process in excel. Right now, I need help with copying and p...
-
excel macro copying cells based on criteria Closed
Hello, If problem excel If cell H of worksheet A = cell E of worksheet B and/or If cell J of worksheet A = Cell H of worksheet B and/or If ce...
-
Excel Formula Counting Diff IF Closed
Hello, I am trying to write a formula to count only certain dates of events in colum A but only IF column F meets certain criteria. I have a formula...
-
Excel question Closed
Hello, I receive an order report (spreadsheet) from my customer that only has their part numbers & on a separate spreadsheet I have a cross reference...
-
HOW DO I DO A FIND METHOD IN EXCEL VBA Closed
Hello, I am trying to create a macro in excel and I am new to it. I am trying to have it where I search through a excel worksheet and I try to find ...
-
Simple Excel Question (I think) Solved/Closed
Hello, I am putting together an XL sheet and would like to find the MAX value in a column of numbers, then return the contents of the cell next to it...
-
MT6225 (Chinese mobile) with my PC to browse Closed
Hello, Please I need pc suit for my E71 Pro (China Phone). I equally need the driver for USB for same phone. My email is: p.onubah@gmail.com. Pl...
-
not able to browse... Closed
Hello, Hello, I have got connected with wireless network but not able to browse. Signal strength is good enough but still not getting the solution f...
-
VBA Excel Search Select Paste Delete Solved/Closed
Hello, If someone could possible help on this I would be very greatful. I have reems of data in Excel (tidal data). I'm looking to get the highs...
-
Sort by date Macro Closed
Hello, I am working in a worksheet that have more than 3000 rows, in one of the columns there is a date in the form of 20-07-2009 10:03:25. I want ...
-
Comparing first columns in 2 worksheets Closed
Hello, I'm trying to compare the first colum from worksheet A with 1st column in worksheet B to find the differences between them. Please help. Aprr...
-
Excell Sum calculation Closed
Hello, I'd like to find out how to make an excell sum to highlight when a point in time has passed. For example. say I buy a tin of beans on 12/3/0...
-
Find and paste data into seperate sheet Closed
Hello, I need a macro that will search a specific range on one excell sheet--say G7:G56 and J7:J56 for a specific name--if it finds the name i want...