The discussions
Editing scanned pdf files...
Hi, I have a huge pdf file made up of scanned images. I wish to edit them either in Acrobat or in Word. Problem is I cannot edit in Acrobat, beca...
Is there a way to call out multiple values in single cell?
SolvedHello everyone, this is tricky and im not sure if i have missed something or if this is even possible, if it is it would be a huge help. I am limited ...
Excel
Acc Code ..... Date.................. Amount....... Cleared C287974...... 31-Jan-13.......... 500............. Yes J320728....... 07-Ap...
Create different worksheets based on data in a column
I have a huge worksheet, where I have a data by different countries, I want to split this master data into different worksheets based on the countrie...
How to capture the data with using of macro
Hi, Am crating a excel form in sheet#1 as following entry's. Row Column A B C D E 1 ...
Excel: matching lists with different formats
I have two lists of names that I am trying to compare. One list is divided into two cells, one for first and one for last names. The other list has ...
Outlook can receive emails but cannot send emails
Hi, My outlook is able to receive email but cannot send emails. Please help. Sometimes my sent emails will be sent into my INBOX. I am using gmail ...
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...
