The discussions
List of sheet names used in one sheet
Hello, I have been given a model with 53 sheets, I want to check if the formulas are ok. I was thinking to make a flowchart or matrix to be able t...
Use password to remove controls set by macro
Hello, I created a Macro that forces users to click "Enable Macro" or the rest of the sheets in the excel document will not populate (unhide). Als...
I forget my memory card password
Hello, I Forget My Memory Card pass word can i break my memory card password please help me thanks Configuration: Windows XP / Safari...
Changin format of date in excel
Hello, Trying to chang the date format in 2007 Excel. The date looks like 05 Oct 2011/0630 and I was wanting 10/5/2011 6:30... Any help greatly ap...
Searching one table to report values
Hello, anyone who can help? I have the following two tables, I want to search the Table A for certain values and report them in Table B Tabl...
Macro help
Hello, I have created a sheet which contains all the details abt the customer and feed back received from the clients and the sales team, Each...
Conditional formatting
Hello, I am trying to design an excel spread sheet where basically i track invoices which are paid and outstanding. In Row A - Date of the i...
How to hide formula
Hello, If i have one formula inserted in Excel and when i will send the same sheet to someone, I do not want the other person to see the formula. ...
Change adobe reader from default application
SolvedHello, How do I change my settings so that Adobe Reader is NOT the default application used when downloading a JPEG image? Everytime is save a JP...
Should i use vlookup?
Hello, I have an excel sheet (sheet 1) with valves in columns A and B that I need to look up in another sheet (sheet 2). Once these valves a locat...
Compare columns
Hello, I need your help to resolve next problem: i have 5 columns (A, B,C,D,E) with these characteristics : 1. The length of all 5 columns are vari...
Microsoft excel - timesheet help
Hello, I was wondering if anyone could please help me with a problem I've been having, I would be greatful. I want to send info from one worksheet to...
Comparing and return value based on it
Hello, I've got a table in such a way like Age Age Cost 16 20 3500 like the above i've 1000 rows i need the O/p as if...
I phone sync with outlook calendar
ClosedHello, my i phone won't sync with my outlook... it used to.. but just stopped. Anybody got any ideas? D
Help for sorting top 5 values on excel
Hello, I have office 2007 & I would apreciade if somebody could help me with my problem bellow! I have 3 columns, column A with names, column B with...
Formula to check text & return other text
Dears who can help me. The Case: In Excel sheet, I have two column of data (for thousand of rows) and in the third column there is formula for eac...
Data from rows into columns
Hello, I'm not that great in Excel so I was wondering if there is a way to separate rows and move to different columns in Excel 2007/2010. I ha...
Code for macro
Hello, Can you please tell me how to write a code to select a statement in a list of statements in excel macro(code) Configuration: Windows...
Find missing data in 2 columns (excel)
ClosedHello, I have two lists of data (patent serial numbers) that I need to compare and find the missing serial numbers. In Column A I have my databas...
Increment last 2 digits alphanumeric cell
ClosedAuto-increment last 2 digits of alphanumeric cell upon open excel document? Hello there, I'm making an invoice template and need some VB trick th...
Should i use vlookup
ClosedHello, I have an excel sheet (sheet 1) with valves in columns A and B that I need to look up in another sheet (sheet 2). Once these valves a locat...
Excel letters relation to numbers
Good evening I am making an excel spread sheet template for an assignment at college and I have hit abit of a snag. I want to express an answer in ...
Acer aspire one. user id and password problem
ClosedHello, iv been given a notebook for my daughter.i want to fix it for xmas but im out of touch of windows xp. when i turn on the nb it goes to the...
Excel macro for creating pdf from mult. sheet
Hello, I need to create a macro that pulls data from two seperate workbooks, then prints them to pdf and combines them. Does anyone have any ide...
Excel 2007 copy multiple columns into one
Hello, I am trying to create a macro that will automatically copy multiple column lists into a single list. Let me clarify. Sheet 1 contains...
Creating a csv file with extract from excel
Hello, I need to extract data in a sheet called csv (A1:H6) in my excel workbook into a new csv file with a new name. The new name is generated...
Can i use a range name in if formula?
Hello, I have a workbook with two sheets, Data and Transactions List. I have named cells A4:A7 on the second sheet as Income (Dividend, Interest,...
Send email using outlook based on excel data
Hello everyone, i'äm new to this forum hope you experts can help me solve my problem, I have an excel file which consists of calibration date of so...
Pls help with valid code. thanks
Hello, I have a xl sheet which contains junk values and required values in mixed format I need to separate the required values alone and put th...
Excel macro copy to cell based on criteria
Solvedhey everyone, I'm stuck. I hope someone can help me out today. I have an excel spreadsheet with 1400 rows. The first 3 rows are irrelevant (headi...
Excel vb script to notify/popup
SolvedHello, I want to have different cells in the worksheet have pop up messages/notifications when the date or deadline is reached. so when the 1 june 2...
Outlook 2007 not sending emails
Hello, I am using Outlook 2007 and have several email aliases set up, all with different outgoing SMTP servers from different ISPs. Recently I have ...
Microsoft excel - info between workbooks
ClosedHello, I was wondering if it was possible to send info from one worksheet to another in Microsoft Excel. I know how to use the function =sheet!a1 ...
Help for vba
Hello, This question is related to MS Office 7. I want to write a code to validate codes used in transaction are present in master sheet or not...
How to match the 1st left word on diff sheet
SolvedHello, I'm trying to match the exact first words from sheet 1 to sheet 2. (like the way we get the match for Vlookup formula) I have a file which...
Excel 2007 not read
Hello, i am using microsoft 2007 version ,but i want to convert my power point to 2003 version as my client does not have 2007 version . kindl...
Extracting cell data from different workbooks
ClosedHello, Have a question. I currently have to compile reports for different customers, all of the same format, but each customer report data is on a...
Unable to edit contents from my thumb drive
Hello, Sir or Mam, I currently run microsoft word 2003 on my PC. I can view items on my thumb drive and on my desktop but I ...
Ms office problem
SolvedHello, i am still using 2007 office but my some excel files in 2003 office format so pls suggested me now how to opned my old file in 2007 offic...
Vb code to copy data from one sheet to anothe
Hello, My problem is similar to first one. I was able to solve with the solution provided by helper. thanks helper. But, if column Q contains blan...
Solved... didn't need a macro!
Hello, Turns out no macro is needed... =INDEX(Sheet1!B:B,MATCH(A1,Sheet1!A:A,0)) I have a rather complex issue I'm trying to solve with a macr...
Type a code that will look into these 7 colum
Hello, I have one sheet in which i have 7 columns. In each column different ranges are typed by me i.e 580, 790, 450.... so i want in my othe...
I need help with profit percentage
Hello, Within a series of columns there are Cost, Sales, and Profit. Within each column are 9 rows each with the information. What formula wil...
Yes or no return on a comparison of two colum
SolvedHello, Column A contains 80 cells with numbers such as this, not in sequential order: 3-1705578711 Column B contains 50 cells with numbers simila...
Excel macro for deleting rows if cells not...
SolvedHello, I need help to create a Excel macro. Basicly what I have is a sheet full with information about different departments and what I want to do...
Comparing value of a cell to a range of cells
ClosedHello, I want to compare the value in a cell - B1 - to the values in a range of cells and return 1 if true and 0 if false. I set up $H$1:$H$14 as my...
Ms word 2007 field codes are shown
SolvedHello, I'm working on a long word document and all of a sudden field codes are displayed instead of references, page numbers etc. I followed what s...
If a1 contains the a word, then show b2 in c2
SolvedHello, I'm trying to create a formula to display the contents of B2 in C2 if cell A2 has a certain word. ex. =IF(ISNUMBER(SEARCH("BACH",B13)),"=C1...
Automaticaly transferring data .. tab to tab
Hi there i was just wondering if you can help i have had a look around but cannot see quite what i am looking for so I have just made up a very si...
Replacing text with a value?
Hello, So I'm wanting to make a rota for work as I'm a midwife, what I'd like to do is the following: C is community and adds up to approximately 7...
