The discussions
Compare numbers in two columns in excel
SolvedI appreciate any response to help me with this. I have two columns of numbers A B B.121 S.222 S.154 B.121 B.164 ...
Keeping only specfic text in a cell
SolvedI have an excel file that has data dumped from external source (P6). One cell contains a lot of data of which I only need very specific. Here is wha...
Excel macro - using integers as cell referenc
SolvedOK, 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...
Excel: need macro to run when value entered
SolvedHi! 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...
Macro to deleting multiple rows
SolvedHello, 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. ...
Select by lowest cell value & group by column
SolvedHi There, I would appreciate, if anyone could help me with the following. Item Qty Length Supp1 Supp2 Supp3.......Supplier7 A ...
Copy with lookup
SolvedHi, I am working with 2 Excel, One field is common in both the excel "SID". I need to copy the row of SID say 'ABC' from Excel B and append to the ...
Microsoft word
Solvedi have a old microsoft word dosc i cant remember the serial # for how do i go about finding it on the program?
Win messenger my secret answer or my password
SolvedHello, i need to get in my windows messanger but i forgot my password and my secret answer. It is very important for me to get in there right n...
How to remove password of my micro memory car
SolvedHello, i m V andana. i forget my memory card password .my phone is nokia 5130. and i have sd micro memory card of !GB.i want data from memory card p...
Extracting data from specified columns
SolvedI have some columns of data looking somewhat like this: data1...data2...data3 val.........val........val val.........val........val val............
Need help on vlookup
SolvedI have list of Incident numbers(both Closed and open) in Cloumn A and only open incident numbers in column B. I should be able to filter the rows base...
Forget skype password
SolvedHello, my skype password has changed by someone how i open my accountConfiguration: Windows XP Internet Explorer 8.0
Need help on an excel if/then in macro
SolvedI'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 ...
Vb for split data
SolvedDepartment | Name | Amount Spent | In my file, there's one column specified different departments of a company, with their money spent by the peo...
Copy down formula if cells on left non blank
SolvedHi, 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...
Lookup/identify next number,paste into cell
SolvedHello,I need help with a identifying the next number! When pressing the Save button on sheet1-Form(Code below),lookup the last number that was used...
Repeat formula
SolvedHello, I need the the formula to work for every cell in column A. So if I select A1 and enter a number >= 40 it skips the next cell, and if I select ...
Compare two columns and delete duplicates
SolvedI 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...
Compare 3 columns excel
SolvedHello, 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 (...
Help need writing a formula please
SolvedHello, I have a report I pull which outputs IDs. There are 5 IDs. Management would like to display their respective Site locations instead of the IDs...
Excel macro to group by column & sum value
SolvedHi 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...
Adding cells
SolvedHello, 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 ...
Help with excel percentages
SolvedHello, 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 so: P...
Convert active excel wksht to pdf file
SolvedHello, I'm trying to figure out how to create a macro to save an range selected in an active worksheet and save to a pdf file by clicking an inserted...
Figuring a number based on a percentage incre
SolvedHello, if i have a number and want a formula to know that it is a percentage of another number, what is the formula in EXCEL? i.e. if i have a s...
Assign macro to all yellow highlighted cells
SolvedHello, 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 formula ...
Excel vba msg box when cell meets criteria
SolvedHello, 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 mess...
Forgeten my password
SolvedHello, hi could u please help me to found my alternate email address and to found my password too because they have steal my password and i can...
Forgot password
SolvedHello, i forgot my password in facebook. The problem is that the e-mail adress in google is different from e-mail adress of the facebook. Please help.
Excel page linking
SolvedHello, 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 asking i...
How to make formula in excel cell for time?
SolvedHello, 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 cell I ...
Marco to delete cells containing an interger
SolvedHello, 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 like to...
Date formatting
SolvedHello, I am currently downloading a report from an external source (csv file format) into excel and one of the fields (column P) should be represen...
Excel
SolvedHello, I have an excel file with Start dates, end dates, total day, and networkdays columns. I would like to average these number for the average to...
For each cell... vb help
SolvedHello, Column A contains either "Ja" (yes), "Nee" (no) or nothing. I would like to know on which date the cell value is changed to "Ja". Therefor...
F 5 problem
SolvedHello, Up untill yesterday, when I used F 5, the cell that I was going to always ended up in the upper left corner of the screen. Now it goes to so...
Ms words into (comma-separated) text file
SolvedHello, What I try to do is that convert multiple MS forms into tab-delimited text files. If there is a quick and dirty way to do so, please let me ...
Need help with a formula please!!!!!
SolvedHello, I and creating a spreed sheet for my job to make weekly counts easier. I have been trying for hours now on a formula to calculate either a...
Problem with "lastline" in vba excel 200
SolvedHello, Let me start off by saying that I'm a VBA noob, and have never worked in it before. Basically, I inherited a spreadsheet which has a macro t...
Changing h:mm am/pm to hhmmss
SolvedHello, I need help changing imported times from i.e. 2:38 PM to 143800 (hhmmss). Please Help!! Thanks, icooper
Moving the contents one cell up in a column
SolvedHello, In my excel sheet the column C has contents in alternate cells starting from C1 till end. It looks like C 1 ...
Formula to copy data
SolvedHello, I have a range table that is 18 columns. I want to be able to look up the number in the first column and return all the info in the other 17 ...
If statments w/ <= dates
SolvedHello, Hello Want a brain buster? Its been busting mine all day…… I'm trying to create a statement for column J "frequancy of visit" to ret...
Macro to delete created object
SolvedHello, With the following VB code I have created a wordart object: Sub ShowMessage() ActiveSheet.Shapes.AddTextEffect(msoTextEffect1, "Even...
Looping for a specific time
SolvedHello, I'm using Excel 2007 I have the following code: Sub Macro1() With Selection.Interior .Color = 255 End With Appli...
What about mail account deleted?
SolvedHello, i had sent a email to a friend and after sending the message came that the mail has been sent but he says that he has deleted his account . so...
Copy/paste values on the specific column
SolvedHello, I want to, copy/paste values on the specific column based on cell A2. i.e. if cell A2= 1 then copy/paste values for the January column (range...
Delete certain cells of active row
SolvedHello, I would like a code for the following: Check which row is active/selected and then delete the data which is in the 5th and 7th column of ...
Insert rows based on count of row in another
SolvedHello, I have a excel where I create few dummy accounts and the next sheet (sheet2) has details of these accounts. I need the sheet 2 to have certai...