Hi All Could someon ehelp me with a macro to filter dates. I have in place a form created to store the start date and end date onto two cells. All...
Hi, I would like to how the code to write a macro that can select/copy the last entry in a column/s. Thanks in advance PM Configuration: W...
Hi, I have a table in one sheet and a column in another sheet something like as shown below Table in Sheet 1 ---------------------- Region1 ...
OK, I've written this and I'm having some trouble. I've put the comments in the code (preceded by ****) rather than giving you a summary here. I thi...
Hi! It's been a long time since I used VB. I seem to be a bit rusty, and I can't figure this out. What I need is for a specific macro to run when...
I know this should be much easier than I'm making it. I'm simply tring to loop through all existing sheets in one workbook and paste a section from a...
Hello, I am running a simple formula in excel to sort out duplicates from a given row, by adding the value "DUP" in a new column on the spreadsheet. ...
Help, What I need appears basic but browsing through other questions I don't see it asked/answered. I'm organizing contractor's bids on projects. ...
Hello I've a shell script which generates a html file in each iteration.I want to get 3 values from the html file to be merged in one xcel file seque...
Hi, I've created a spreadsheet for keeping a selection of data. Once a cell reaches the number 10 I'd like a pop up box to appear saying "Jon now ...
Hi all, How i can add number of sheets using macro. For Example. i have assing A2 as a sheet count for addition how can i accomplish it. m...
Hello, I need to filter unique values from 2 columns and place those value in a third one.. can any one help me
Hi, I have written a single cell formula in Excel which gives "Pension Amount" depending upon the inputs on "Age" and "Salary" of the pensioner from a...
Hi, I want to create a macro which will look at for example column A and find the last number entered then add a row below it and to do this every ...
Hello, I have a spreadsheet with all different dates with corresponding data in its row. There are many rows with the same date and i want to create ...
What is the best firefox browser that i can use for my pc?
Hello, i need a macro to be created in excel to first filter the data by latest or the last date in the end time column and delete rest of the data,t...
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 Text t...
I have tried doing it with the use of a macro but it is not working. Does anyone know how to do it?
I have some columns of data looking somewhat like this: data1...data2...data3 val.........val........val val.........val........val val............
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 in ...
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 wasti...
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 and ...
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 differ...
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 B ...
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 U2:CY2...
Dear Experts, I have a data here on excel Column A with the following arrangement 1 Radio Link south 2 Capacity ...
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 rows...
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 spr...
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 and mu...
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 an ...
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 have...
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 M5 a...
Can anyone help with adding a limitation to a macro? I currently have a very simple option button activating another worksheet in the workbook. But I...
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 not s...
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 copied in...
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 like ...
Hello, I want to add an alphabatic letter in percentage formula in excell sheet. plz write me how can i do it.
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 12 3 4 ...
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 columns (...
Hello, pls tell me hw i can browse with my nokia 5130 c free of charge,tru opera 4.5
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 remaining. So...
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 data f...
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 righ...
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 dat...
Hi there, I need to write a macro for following example. Item Qty Length A 1 100 A 1 100 B 2 200 B 1 100 B 5 100 C 4 200 C 2 100 C...
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 and ...
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 ...
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 ...
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 Cells. Example. Sheet1 ...