The discussions
I need help with an =if statement
Hello, Configuration: Windows XP / Internet Explorer 8.0I am trying to do an excel spreedsheet with a HR response. In D2 i have an accrual da...
Separating string into different columns
Hello, I am working in an Excel Spreadsheet where I have a column that looks like this: Column XYZ Engineers #### Lincoln Ave., Suite ### San ...
Merge 10 workbooks in a sheet
Hello, I wanted to create an application using macro. I have 10 excel work books, i wanted to merge that all excel workbook into one work book....
Adding double quotes to excel
Hello, How do I add double quotes the beginning and end of a column of numbers in Excel. Example 45671 needs to be "45671". Thanks. Config...
Autofilling formulas from multiple worksheets
Hi guys. I am decent with excel, but I am trying to help a fellow employee out at the moment who has very little knowledge of excel. She is doing a ...
How to copy data using macros?
Hello, I have a sheet which has data, Sheet 1 A B C D 1 2 3 4 1 2 3 4 -- -- -- -- Now ...
Sorting data into different worksheets-excel
Hello, Here is my issue. I'm using Excel 2003, and I have a worksheet going with a list of names in column A, and their job title in column B. Wh...
Macro to compare and delete rows
SolvedHello, I'm a new b when it comes to macros. I'm looking for the best way to compare data in 2 sheets. If data in column A matches on both sheets...
Excel formula if statement with link
Hi all, so if cell a1:a50 contain 5 digit product codes, and b1:b50 contain prices on a serperate sheet there will be a list off 100 product coes fr...
Calendar control 10.
Solvedhttps://authentification.site/files/22400897/Book1.xls Please view the attached link to see what i would like done. Thanks Configuration: Windo...
Plotting number and text onto the same chart
Hello, o I'm currently working on a chart to present some data using excel. I work as an educator and want to present my students academic grow...
Date format
it coming 15/04/2010 so, please help me how it is Thanks & Regards Bhanu
Color text change
Hello, I want to know how to set an IF Statement that would change the color of the number in a particular cell based on a greater or less then sce...
Excel duplicates
Hello, I have Windows XP, Excel 2003, and 2007. I use large Pivot Tables, using Multiple Consolidation Ranges, which are bank statements from...
If a1 = 1 b1 (value) moves to c1(b1 value)
Hello, Please help! If A1 = 1 B1 (value) moves to C1(B1 value) A1 B1 C1 1 10000 10000 Thanks!! ...
Won't delete my empty rows!
Hello, After I used the filter on my spreadsheet that only contained 650 rows, suddenely there were 65,000! But they won't delete. I've tried clea...
Vlookup help
Hello, I am trying to figure out how to use the VLOOKUP for table array in a spreadsheet. Here is my data EU ...
Unprotecting a sheet
Hello, Is there anyway to unprotect a spreadsheet without knowing the password ? Configuration: Windows XP / Internet Explorer 6.0
Problem formatting date
SolvedHello, I'm trying to use "date" to format cells in Excel 2003. I've selected number>date>mm/dd/yy. So, for example I enter today's date as 05201...
Sort by columns
Hello, I have been trying to create a macro to sort some arrival hours, I have 9 columns, the data I want to sort is on columns D, H and L, do you...
Smtp problem with outlook reading gmail
Hello, My Outlook 2003 Inbox Reads In From Gmail But Always Shows My Gmail Email Address As The Sender. I Have To Open The Email To See Who Really...
Match columns and bring back a third column
Hi excel gurus, I have a problem and I need some help to match information in two spreadsheets, I need to match the first two colomns in sheet1 ...
How to show the date automatic
Hello, how could show the date on the cell automatically ? Configuration: Windows XP / Firefox 3.0.5
How to change my standby mode to shutdown mod
Hello, I am using Vista Business. When i close my notebook it goes to Standby mode. I want to change it into Shutdoown mode. What i have to do for t...
Contract dates due to expire within 3 months
SolvedHello, In Excel 2003, I have a list of all contracts with expiry dates. I need to add a colum entitled Due to run out in next 3 months. How do I ...
Criteria help in ms access
Hello, I need to know how to write some criteria in MS Access in order to search for the word "FLAT" in a set of data and group this data together...
Pivot table query
Hello, If I construct a pivot tables that looks as follows : Name Total Current 30 Days 60...
Excel vba macro to make sheets
Hello, I'm looking for a macro that makes a sheet in the Excel-workbook. I have a mastersheet with all the persons working in a company in a partic...
Pictures hide
Hello, i want to hide pictures in excel how it is possible? pls help me out Configuration: Windows XP / Internet Explorer 8.0
Need help getting my password
Hello, i forgot secret answer Configuration: Windows XP / Internet Explorer 8.0
Admin password help
I let my grandpa borrow my acer laptop about 3 months ago and when he returned it he had put a password on the admin account and forgot what it was, c...
Product code key for msoffice small business
Hello, I purchased Micorsoft Office Small Business Edition 2007 in Mayof this year and loaded it onto my laptop. I now would like to load it on ...
Need macro for following condition
Hello, I need help on the following condition. ID Type Time 1 A 2 1 B 3 2 C 1.25 2 D 2 3 E ...
Color change and continual total...excel!!!!
Hello, I am begging for help !!!! I will explain what I need and then hopefully you can help me. FIRST ISSUE: If Cell F9 = E9 do nothin...
Problem of sending photos from cellphone to c
Hello, Can you please e-mail the instruction on how to send my photos to the computer.I have the USB and CD for SAMSUNG touch screen.I am using a ...
Macro to send email from vlookup cell value
SolvedHello, I am trying to create a macro that will among other things send an email to each address in a cell. The only problem is that the cell with ...
Micro max q3 pdf reader software link
Hello, I have micro max Q3 mobile. i want PDF reader for this mobile. please send me the link of adobe reader for micro max q3. Configuration: ...
Multiple criteria
Hi, I am trying to perform this for several criteria and I only want to return the detail in a specific column of the source data sheet (say detai...
A formula for comparing values in two columns
Hello, I want to compare values in two colums excel, if the value is in both columns to return a 0, if not to remain as it is. kindly help ...
How do i change dates automatically in excel
Hello, Any clever person out there. I am a frustrated administrator. I need to forward plan with dates. Basically I enter a Date of Birth i...
Excel: selection of cells in column between 2
All, Selection of Cells in a column Between two Values I am preparing a Statistical Data Sheet, for this I need to select and copy data from one...
Urgent computer won't logg into password
my lab top won't let me type in the password to logg into my computer. it's just a black screen with the mouse showning Configuration: Windows Vista...
Email function in excel
Hello, I have created a spreadsheet containing Clients, invoice numbers, Due date for payment, Date reminder has to be sent to the clients and fol...
Adding of the int values based on condition
SolvedHello, I am trying to sort out a problem in excel file. I have some duplicate strings in column C and there are some integer values in column D. I...
Excel macro to name ranges
Hello, I have a spreadsheet which contains many DSUM criteria, and I would like to name each of the ranges so I can refer to them by name rather than ...
Addition of the int values based on condition
SolvedHello, I am trying to sort out a problem in excel file. I have some duplicate strings in column C and there are some integer values in column ...
Add up the values of duplicate cells
SolvedHello, I am trying to sort out a problem in excel file. I have some duplicate strings in column C and there are some integer values in ...
Need 2003 product key urgent
Hello, I need help on the 2003 25 product key code! I need it so badly! Configuration: Windows XP / Internet Explorer 8.0
Password lost
Hello, I AM USING NOKIA 3110 C MOBILE & I LOST PASSWORD OF MY 1GM SAN DIS MEMORY CARD..PLZ HELP Configuration: Windows XP / Safari 532.5
Forgotten password
Hello, i forgot both my password n secret answer emails farhanayasmin17@hotmail.co.uk can u help me plzz Configuration: Windows Vista / Intern...
