The discussions
Lock/unlock/color a range based on the value in another range
Hello, My questions relate to Excel for MAC 2011 (not PC), I am very new at VBA. I found the below code and need help to make it work. My Excel ...
Vba - graph color same as cell color
hi, i am creating a project of my own using ms excel 2007 and i need help on this. i want to put the cell color to the graph that i am making using ...
Insert desired rows on condition basis
Sir. I am new to this website. I want to learn/know to how to insert desired number of rows when any condition met. For example: I have a Spr...
Create new sheets in excel based on dates and creating charts
Hello, I have excel file with aircraft engine data (date, time, EGT & CHT for 6 cylinders, fuel flow and manifold pressure), eg 16 columns and abo...
Conditional formatting based on dates-3 columns
Dear brothers/sisters, I need your help to do this below facilities in excel. I explain it, then you please guide me well in detail. 1) In Cells A...
Parsing rows of data into separate tabs based on criteria
I have a master list of launches in excel, each which includes a column for launch date. For all launches with a launch date in September, I would li...
Insert muliple embed objects vba code
Hello, I am looking for a script that will automatically insert muliple embed objects to cells in excel And this is my case: - I have a sheet wi...
Excel vlookup-copy entire row
Hello, I need to get the entire row by using vlookup or any other lookup/formula please help. is there any option to lookup left side of t...
Copy rows with specific data to another sheet automaticaly
Hello, I am new to this forum and appreciate worth of all who want to help and share knowledge. I would like to extract or copy rows from one s...
How to transfer data between multiple sheets
Hello, I am just wondering if anyone could help me find a solution to my problem. I am trying to automatically transfer data from one column t...
Auto notify or mail when excel sheet is updated.
Hello, I found this code on the site, however I am trying to get it to launch Lotus Notes instead of Outlook. Any help would be appreciated. ...
The skills for software
I want to learn more please
Formula
Can someone please help me? I have a column with the letter H and I would like to add a value to the H so that I can sum the colum in the last row. i....
Excel formula to count cell colour and display sum in another
I have had a look through the other questions and responses, but they don't really help. Using Office 2010, I would like to apply a formula to a range...
Due date reminder in excel 07
SolvedHello, dear all. I have a "credit list" worksheet having the details like. 1) date 2) invoice number 3) name of beneficiary 4) total amount 5)paid c...
If/then relating to a legend
This must be easier than I'm thinking it. I have a set of data I collect every month that I drop into an excel. It's in a list. I take that list an...
How copy a particular text from one column of sheet to another
Hello, how to copy a particular text from one column of sheet to another sheet. For example i have a text in cells of a column in sheet1 i a...
How to sort using vba
Hello, i have a table with 1 230 450 1 301 2 230 450 2 340 7 230 450 7 350 65 230 450 301 501 67 230 450 340 502 71 230 450 350 546 129 2...
Date formatting
I WONT DATE FORMAT (dd/mm/yy) BUT IN MY EXCEL IT SHOWS (mm/dd/yyyy) IN FORMULA BAR. PLEASE HELP ME. I HAVE SO MANY WORK WITH THIS DATE.
Ms excel, lookup word from a cell
SolvedA B C 1 C287198 MARIQ BLDG MATERIAL TRDG C287785 C287785 2 C2...
Excel formula
SolvedI have a blank excel invoice that I want to be able to type the Item number on it and have it populate the vital information on it like the item name,...
We loop-up
How to operate we loop-up programme in excel file
Need help please: excel click timer to time each work/task
SolvedHi Excel Pros, This is my first time to join the excel forums and have seen how helpful you guys are here. I need to come up with a visual basic...
how to convert word to pdf
Excel
Hi i need help, i have 2 cells with data in it, for example A1 = AX14587Z4 and E1 = AX14587Z3, i want to compare (match) these to cells to see of the ...
How to extract data from one excel file to another
How do I extract data from one excel file to create a report in another excel file template? The input file has various data fields. I need to extr...
If function
What is the formula to get a return value of Y in column x, by looking at the data in columns a,b,c,d,e,f,g to see if they indicate y.
Need to move 2 columns from excel to notepad
I'm in need of some help here. I have an Excel (actually Open Office) spreadsheet with two columns, A and B. There are 500 rows (sets of data). Not su...
If x then vlookup and sum, if y then vlookup and sum
Hi guys, This is my first post here so I hope I'm doing it right and that someone might help me out. I'm working on a spreadsheet where I inser...
Conditional formatting
I have list of numbers like 4J0249 4HE304 44S305 406305 4B9308 4KI308 here 3 is the last digit of the year and 04 is the week of the year ...
How to auto generate excell sheets based on set of values?
HI, I have a sheet with one set of values as height, width and quantity which work on formula. I have 10 set of values, but now i am copy pasting ...
Condintional formatting for dates
I am working on a spreedsheet to track mulitple people and the dates they signed a wavier. Everyone has different dates they signed. I would like to...
Converting numbers into words
Please advice that how can i convert numbers into words. Please send solved formula and its related tips.
Link between workbooks
New to the forum, hope someone can help! Let me know if I need to clarify my question and thanks in advance. When using formulas to link one workb...
Run a macro when value is...
Hello! I have been trying to run a Macro within a worksheet. Running the macro depends on the value of a cell, it can be 6 or 4 (Changes depending on ...
Error ox800ccc79
SolvedHello, This is driving me nuts... I can recieve mail but not send please help Outlook Express Configuration: Windows XP / Internet Exp...
Date and text functions
Hi, I am trying to find a function which will return the following: If the cell date falls in the previous month of the today date cell and matc...
Code for the below scenario - excel vba
Good Morning/Evening , I need help in coding the below scenario. I have to code in excel vba and have requirement to look for 2 rows . 1st row ha...
Copy complete sheet in excel with condition of a word
i want to copy a complete sheet in excel, but only the data with specific word in one of the columns. for example : number name rate 1 dan 90 2 d...
Copy multiple charts to multiple worksheets
SolvedHi I have a challenge for which I cannot correctly conceptualize a workable solution so I am hoping someone here can share their thoughts on it. ...
How to increment numbers automatically in excel using macro
Hi, I have a column A1 which has values like Tc001 and B1 and Tc002 > I just want to increment only the numbers. How can i achieve it using macros? ...
Macro to email a list of transaction in form of statement
Hi Excel Pros, I'm only a rookie when it comes to VBA excel - I have been pulling customer data via an sql link into a spreadsheet - the data for...
Array lookup
Hello, I was wondring if there was a formula to do this in excel. I have the data in two columns, col a and col b What I want excel to check first i...
Excel macro: rename all worksheets
SolvedSo, I'm trying to figure out a way to rename all the worksheets in a workbook. the first worksheet would be "1" (without the quotation marks) and c...
Excel macro error
I recently tried this macro to make a cell in excel blink but it gives me an error. Our of range error 9 This is the macro Dim NextTime As Date ...
Time formulla use in excell
i use excell 2007 i want to use time formula in excel example for timeshit i enterd my company 7:00 am and i exit my company 23:00pm its autmatic ca...
Formula to show a value in a cell if another cell has a value
Hi ............ Sheet 1 - shows a value of "Y" in A5 Sheet 1 - shows a date value in A1 Sheet 2 - A1 destination cell "Sheet 2 A1" needs to sh...
Changing the format of a cell based on another cell with text
Hi There. I've spent about 4 hours trying to work out the formula or what I'm doing wrong to no avail, please help me before I lose my mind. I need ...
How to get numeric value in to text?
Example: In Excel sheet Cell A1 has 125 numeric value. So I want to convert this into Cell B2 as One Two Five. PLease give the solution/form...
Window software
how to install window software on my windows7 basic