Excel Forum
-
Moving data within spreadsheet [Closed]
Hello, I am copying data from another system to an excel spreadsheet. I need to create a pivot table in the end. Data is very busy and when I...
-
Remove alternate rows [Closed]
I have tried doing it with the use of a macro but it is not working. Does anyone know how to do it?
-
extracting data from specified columns [Solved/Closed]
I have some columns of data looking somewhat like...
-
Combine 2 rows into 1 row, over and over [Closed]
I have over 5,000 rows of items I need combined, but they need to be combined in a certain way. Below is an example of the information I have, all...
-
Excel problem [Closed]
I have never used excel before but I have a long list of names for business transactions. how will i be able to count the list of names wityhout...
-
Need help on an excel if/then in Macro [Solved/Closed]
I'm trying to create an If/Then in Macro for a cell which you input what GPM you want to use. The goal is to stop sales people from making errors...
-
Macro [Closed]
I would like to write a macro that will insert a certain name into a cell depending on what number is in the cell beside it. There are about 20...
-
counting in excel [Closed]
Hi I have an excel spreadsheet that has totals in 4 different tabs. I have a final tab that sums up the scores of the 4 tabs. A ...
-
Copy down formula if cells on left non blank [Solved/Closed]
Hi, I need code to copy down a formula from R2 to R3, R4 , R5 etc only if H3, H4, H5 etc is nonblank. I also need to copy formulae from...
-
Help Please! EXCEL SOS [Closed]
Dear Experts, I have a data here on excel Column A with the following arrangement 1 Radio Link south 2 Capacity ...
-
Excel 2007 - deleting multiple rows [Closed]
Hi - I'm hoping for some help in deleting rows in a worksheet. I have data that is imported from a database into Excel. I want to: 1) Delete...
-
Urgent VBA excel help! - reorganize data [Closed]
Hello, How do I write the VBA code to search Events by date and reorganize them into a totally different format in a different sheet? Original...
-
Excel functions [Closed]
Hi, Good day! Can someone tell me formula to find the datas which range's between 1 - 5, 5 -10, 10-15 and so on till 95-100 in a column ...
-
Macros Help [Closed]
Hello, I am trying to write a macros that will help me delete the first three characters in a cell. I copy and paste a set of serial numbers into...
-
Match phone numbers on Excel sheet to address [Closed]
Hello, One Excel sheet #1, I have names and addresses of a very select group of about 5,000 people. Address is in column H. On Sheet #2, I...
-
Excel if formula help requesr [Closed]
Hello, i am entering my formula like " =IF(H5=AMC,"=M5*5%") " but i am gating error like #NAME, can any body help me to calculate 5% value of my...
-
only run a option button macro if a cell >0 [Closed]
Can anyone help with adding a limitation to a macro? I currently have a very simple option button activating another worksheet in the workbook....
-
Compare two columns and delete duplicates [Solved/Closed]
I have a large amount of data that is supposed to be unique based on two columns (Column A, Column B). The combination of these two columns are...
-
automate simultaneous entry of data in cells [Closed]
Hello, I need to format two Excel cells on the same sheet so that when data is entered into one, the same data automatically is entered or...
-
Excel Cell Reference; '=+' meaning [Closed]
Hello friends here, I wish to ask a question about Excel cell referencing cell value from another work sheet. 1. The value in the cell was...
-
excell formula [Closed]
Hello, I want to add an alphabatic letter in percentage formula in excell sheet. plz write me how can i do it.
-
Excel Formulae - value of row above [Closed]
Hello, I have to rows of values as shown below 1 G F E D C B A A* 2 1 5 8 25 9 10 15 ...
-
Compare 3 Columns excel [Solved/Closed]
Hello, I have to compare 3 columns (A,B AND C) filled with names and return, in another column (E), the list adding the names from the 3...
-
i want to browse 4 free [Closed]
Hello, pls tell me hw i can browse with my nokia 5130 c free of charge,tru opera 4.5
-
mircosoft excel formatting cells complicated [Closed]
Hello, i need to change the color of certain cells based on percentage. for example if i have 20 trucks but 6 break down then i have 14...
-
How Can copy whole data from excel 07 sheets [Closed]
Hello, I am using MS Office 2007. Please let me know that how can I copy whole data from sheet one to sheet two. I want to copy the whole...
-
pasting formulas in excel [Closed]
Hello, Quick question guys, when i insert a formula in a cell in excell i normally get a little cursor appearing on the smae box on the bottom...
-
Merging data from 7 worksheets into 1 pivot [Closed]
Hey, I have seven worksheets within on of my excel spreadsheets. Within each worksheet i have several columns and i am seeking to summarise the...
-
Excel Macro to group by column & sum value [Solved/Closed]
Hi there, I need to write a macro for following example. Item Qty Length...
-
Excel conditional formating! help need! [Closed]
Hello,every one! I have massive problem on off my reports which I need to do for work includes conditional formatting or some specific formula...
-
Help With Excel Formula [Closed]
Hello, I have a question but can not explain. Basically I want to find first row Value from range MIN(A1:A10000) that satisfy some condition.I...
-
Need to Run 3 Loop in a single sheet macro [Closed]
Hello, I can able to run my requirment by 2 macro, i need to run in a single macro. How to calculate this in single macro? Ex. A1 ...
-
Adding Cells [Solved/Closed]
Hello, I am trying to build a macro that allows me to input a number on Sheet1 and then on Sheet2, add that number of...
-
macro to extract to a new column [Closed]
Hello, I need help with a excel formula, as follows HP LASERJET 4250/4350 HI TONER CARTRIDGE HP #78 TRI COLOUR INK CARTRIDGE (19ml) HP...
-
conditional formating on formala cells [Closed]
Hello, i m trying to apply the conditional formating on the cell which is containg the formula, a b c ...
-
Help with Excel percentages [Solved/Closed]
Hello, Please bear with me as I a very new to this type of syntax with that said here we go. I have four date columns in Excel like...
-
Excel If Help [Closed]
Hello, I am having trouble with my excel spreadsheet. I want to do an if function but I also want the formula to do a calculation at the same...
-
Long IF statement in Excel 2007, won't paste [Closed]
Hello, I am trying to use data validation in excel 2007...below is the formula I am using to refer to data on a seperate worksheet. I know the...
-
excel help [Closed]
Hello, Please help me with this I want to limit my data entery in one cell. for example the data enterd in cell A2 should be less than or...
-
Master of Free Browsing has come. [Closed]
Hello, i knw most Nigerians need a free working cheats 2 help browse lik fire. here, i come 2 make ur dreamz come. i work on all d Networks in...
-
Excel Formula [Closed]
Hello, I need to create a formula that will compare which cell is greater than the other and then put the greater one into the cell. Say B4...
-
excel macro problem [Closed]
Hello, i am trying to ask a few simple questions in individual command buttons and the answers are going to be yes or no. I would like the...
-
Excel - How to reset / set a particular cell [Closed]
Hello, I have used if function in one cell and its give true value and false value accordingly. But when i am using if function for the other...
-
assign Macro to all yellow highlighted cells [Solved/Closed]
Hello, I am in currently in a pickle ... I hope all the masters could lend a hand to this VBA noob... Right now i wrote a macro to copy all...
-
Excel VBA Msg Box when cell meets criteria [Solved/Closed]
Hello, Hi this will probably be very simple for someome however I am having a nightmare day, all I want is a vba formual which will bring up a...
-
Opera 5.0 free browsing [Closed]
Hello, Pls help me with mtn opera 5.0 free browsing code and cheat for nokia 3230.pls if u can help me,i'll reciprocate.tanx in...
-
Excel page linking [Solved/Closed]
Hello, I'm trying to link 5 pages which each have a total amount on, I am looking to put all the totals automatically on one page, what i am...
-
How to make formula in excel cell for time? [Solved/Closed]
Hello, I want to make spread sheet with time in the Excel CELL How to do that? For example 1st cell should show 11hrs.56mins.05sec and next...
-
Marco to delete cells containing an interger [Solved/Closed]
Hello, I am stuck and would love some help. I have two Columns in Excel J and K. The two Columns contain numbers from 1 to 53. I would...
-
Excel conditional formating more than 3 condi [Closed]
Hello, i hope anybody can help me with this: as I need to have more conditions can anybody give me precise code for these conditions (to...
