The discussions
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...
Last value in a row with diff. 25% on rel val
SolvedThis is tough to even state, but I'll try with an example Example: find the first value that changed 50% in relation to the last time when there wa...
Colour
SolvedHello, Hi and thanks for previous help. Last one for a while (I hope) I am using the below formulae you gave me and it is fine. However these res...
Excel macro - dynamic column selection
SolvedHello, I am just beginning to learn Excel macros. I was working on a sheet wherein I have to select a column dynamically, based on just the column ...
Text box linked to cell value
SolvedHello, I have a text box placed in a chart that links to another sheet/cell for its content. The value is a percentage. I can format the source text ...
Dates
SolvedHello, Crazy question.... I have a row full of different dates. I would like to create a formula to display in a separate cell, the earliest date fr...
Separate required records from a file, mak
SolvedHello, I am using following macro to separate required records from a file contain several worksheets and each worksheet contain thousands of rec...
Excel conditional formatting row color
SolvedHello, I am trying to get Excel to automatically change the color of a row depending on the entry in column H. I've got some VBA code written up, but...
Match formula with external lookup_array data
SolvedHello, I am trying to write a formula using the MATCH function =MATCH("x",r1:r10,0) to find the first instance of x in a column. Howev...
Copy data one sheet to another
SolvedHello, dear friend i have two work sheet.first sheet has a data.using subtotal function I'm daily taking summary of that data.that summarized data da...
Macro to compare two sheet with both sheets h
SolvedHello, I have a 2 excel sheet which has all the column having same. This has D$C Comment, OMS comments, Planned Resoluiton date & Sub account in bo...
Lookup,count and pie chart excel2007
SolvedHello, Can anyone give advice? I got a form on sheet1 thats got a savebutton to save the input data of the form to the database on sheet2.On sheet2 ...
Scores
SolvedHello, Hi I will sonn get a sheet of student exam outputs listing there choice of answer from a to p for each question. I have a space st the top of...
How to match value with table
SolvedHello, I have a problem to match the value from sheet 2 with another sheet name table. I want to compare if the value near with the value in the tab...
Countif based on two criteria
SolvedHello, I'm tinkering with a spreadsheet I use for my business and would like to create a count of the number of products dispatched on a date. I ha...
Changing color of a cell in a table...
SolvedHello, I'm afraid that this post rather fits into the "free help" section of things here, I am a person with a basic knowledge of coding and i...
How to fill selected cells with given data?
SolvedHello, I often need to fill cells with a date of production. What kind of a macro would be usefull in this situation so that I could just select the...
Selectively transfer data topre defined range
SolvedHello, I am new to Excel VB. I'd like to compare a set of data from worksheet1 by meeting a set of multiple conditions/criterias and then transfer ...
Find a string in excel and remove all cells
SolvedHello, I need to find a string (for example: abc) in a large worksheet then remove all cells containing this string. I have tried different functions...
Cut-paste row to sheet2 if columnvalue is met
SolvedHello, I have got 2 sheets. Sheet1 contains a list of assignments, in which column B contains the status of those assignments. Sheet2 contains comp...
Converting a number in words into a number
SolvedHello, i want to convert wrods into a number.Let me say more clearly... if i take " one thousand five hundred six " it should be converted into ...
Column comparison
SolvedHello, i have two columns to confirm the name , I want 2 identitfy; do the first column name is same person in the weccond column for example...
Excel help
SolvedHello, I am having trouble with an excel calculation, i'd be grateful for any help: I have menu items listed along the top, with a space for th...
Getting perfomance of each vendor using excel
SolvedHello, What I want is to get an evaluation of every supplier. Let say I have 20 list of supplier and list of product I'd ordered, including quantity...
Find a text in a sentence inside a cell
SolvedHello, I have a column which has addresses of different Companies, eg. SHRUTIVEER,23/2/1/1 BHAGBAN CHATTERJEE LANE,HOWRAH 711101 2nd Floor, Eas...
Adminstrater password problems
SolvedHello, my 10 year old daughter changed her password on laptop on the admin user she cant remember her password .
Copy a "comment text" in to "cell t
SolvedHello, my Self Deepak Kumar, I can't find the fomula how do Copy a "Comment Text" in to "Cell Text" in another sheet. Regards Deepak Kuma...
Date format today
SolvedHello, I have an invoice with a date format "TODAY". If I create an invoice today, it assigns today's date. If I open the invoice tomorrow, it as...
Excel forumla help (if formula)
SolvedHello, I need some help, I just can't figure the IF formula out. On my Excel 2007 spreadsheet, I am trying to figure out if I put the letter grad...
Formatting with more than 3 colors
SolvedHello, I need your help guys, i wanted to apply the formatting with more than 3 colors in my worksheet. The worksheet im working on has a lot o...
Conditional formulat with #ous condiitions
SolvedHello, I have to write a formula to account for 6 conditions from 6 different columns. Originally, I thought it could be done by a simple nested I...
Law school acceptance chances
SolvedHello, I want to compare possible GPA and LSAT scores to Minimum Acceptance GPA and LSAT scores. I've tried using IF and AND functions, but I can't s...
Counting
SolvedHello, I am trying to count the number of cell's from I4:I304 that have "no access" in it, but in those cells not only do some of them have "no acces...
Excel macro loop to insert pics into more cel
SolvedHello, Could someone please help me in writing a loop in this macro in excel : I have an excel sheet where it contains the name of the pictures in c...
Excel help combining info from2 sheets
SolvedHello, Hello, How can I match and combine records across two excel sheets. I have two excel sheets containing record information, about 6 columns f...
Forget password & secret question
SolvedHello, i have forget password & secret question .please help me.please reset my passwrd . kamal nautiyaljubl@yahoo.co.in
Forgot password of memorycard
SolvedHello, i forgot my password of my memorycard of nokia 3110c.. pl help me to change password.. thank u
Excel if function over a range of dates
SolvedHello, Can anyone help please? I am trying to add a divisions column, which are taken from a date range in another column. i.e. I would like to add "...
Insert and order the column
SolvedHello, It has A, B, C, D, E Columns and less then 6500 rows as per given example. A and the B column are fixed. I want to reorder compare "C" co...
Excel formula to show zero
SolvedHello, I'm using the formula =A2/(A2+A3) in A4, same in B to AF, i need the A4 line to show a zeros when A2-AF2 and A3-AF3 do not have values in. ...
Compairing two columns a&b
SolvedHello, column A column B 5000 4001 5001 4080 5002 4445 5003 4493 5004 4...
Network days
SolvedHello, I need some help if any one can assist, please... I have a date in a Excel S/S so i.e. 15/02/2010 and under this i have a number of days ...
Excel formula converting time difference
SolvedHello, i want to know the excel formula...below iam giving the details, In table A is my starting time e.g.10.49 and in table B is my reaching time...
Deleting alternae rows
SolvedHello, I want to delete every alternate rows from my work sheet. I tried recording macro, but it only deletes a particular row as shown in macro bel...
