The discussions
Look for a value into different ranges
SolvedHello, PLeas take a look on the following data A B C D E Range 1 Range 2 NAME 81000...
Excel formula
SolvedHello, I am looking for a formula or script that can help me with the following. I am doing a spreadsheet for 19 different offices (on seperate...
Matching columns
SolvedHello, I have to an issue with matching columns. Column A Column B Column C Column D Column A: This has 300 lines with account #'s Column...
If statement required please
SolvedHello, Date 1 Date 2 Days varience Status 04/05/2010 29/04/2010 -5 On Time 04/05/2010 06/05/2010...
Macro that takes multiple csv files and puts
SolvedHello, I need a macro that takes multiple csv files and puts them all in 1 worksheet. The csv files all have header info that i do not want copied ...
Ms office 2007 opens files as read only
SolvedHello, I installed Office 2007. Each time I open a file in Excel, it opens it as Read Only and won't let me save with the same file name and thus...
Excel 2007 "if....then select row and move&qu
SolvedHi all! I have what would appear to be a basic question, but can't seem to put my brain around the solution. I have a spreadsheet on Sheet 1. O...
Copying data in a dfrnt sheet w/ condition
SolvedHello, Greetings everyone... I want to copy data from one sheet to different sheet but only if a condition is true. For example, 1st Shee...
Label name protected
SolvedHello, I was wondering if someone can help me. I want to know in this file at this address: https://authentification.site/files/22686748/Mac...
5130c forgot my mbl memory card password
SolvedHello, Im Using 5130c.... I forgot my password.... i Cant able to enter in My Memory Card plz tel hw to solve this problem.... Configurati...
Excel: find & offset
SolvedHi can someone help me to get a macro code to make following: I have a file in which some cells having data as 10000, > 10000 and some others 10000...
Code for copying whole data in auto filter
SolvedHello, Configuration: Windows 2003 / Internet Explorer 6.0 i am using excel 2007. i recorded a macro to copy segregate the data from data t...
Autofilter tp leave out #n/a in macro
SolvedHello, I have a project id in column C , which iam checking from another source data which is there in a differenr tab .So ihave a vlookup fprmula...
Formula reads only till 12th on month
SolvedHello, If I run the following formulae it gives the result only from 1st to 12 of the month. Is there any thing wrong with the formula or with my Ex...
Writing a macro
SolvedHello, I am trying to get data whcih has been inoutted into one workksheet to copy into another worksheets when it meets a command in one of the c...
Excel, if fuction with cell text values?
SolvedHello, I would like to include the text value of a cell in the statement I have for one of the IF options. So far my formula is -: =IF((B1...
Deleting cells based on cell value of samerow
SolvedHello, When I delete cell D4 (it's contents turn to ""), I would like cells C4, E4, F4, G4 to be deleted as well. The row must still exist, so on...
If
SolvedHello, If A1 = 80 then B1 = 100 or if A1 = 50 then B1 = 90 both these formules are in the same cell, Thanks Configuration: Windows XP / Interne...
List 2 columns into one
SolvedHello, I hoping that someone can help me fix this. I have two columns with possible duplicate vendor name, example VendorName ...
Highlighting dates conditional formating
SolvedHello, How to highlight dates in "EXCEL" i mean Less than Today = RED Today = YELLOW Greater than Today = Green Please help me i've been...
I need a formula for excel
SolvedHello, Here is what I need and cant find anywhere: IF A12="text1 (anywhere in text)",then b2="text2" please help provide a formula that ca...
Excel formula file linked
Solvedhttp://wikisend.com/download/466894/Check1.xlsx Their is a description on the file about what i am trying to do. besicly check one value to a list,...
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...
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...
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...
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 ...
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 ...
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...
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 ...
Column match
SolvedHello, I have two columns in excel 2007. Both columns show menu items from another computer system. So, as an example different roles in our com...
Getting values from other xls file
SolvedHello, I have 2 xls files (book1.xls and book2.xls). In book1.xls the first column (A1) has certain names in first 10 rows (say x1, x2, x3, x4, .....
Micro sd memory card password is forget
Solved/ClosedHello, i use NOKIA 3110c mobile. MY micro SD memory card password is forget. how can it find give me any solution. my id is : ...
Micro sd 1gb password forget
SolvedHello, . now i am using nokia 6085 mobile .. i forget my possword in micro sd 1 GB memory card.. plz tell me the solution what are the steps to fo...
Excel - macro copy date for "n" month
SolvedHello, Would you please help me to create a macro for generate Date schedule to Sheet2 It just like an installment schedule. Sheet1 Col ...
Lookup last name in a range
SolvedHello, = LOOKUP(1E+30,Sheet3!E118:E141) I jused this formula to look up the last date of a range, but now want to change it to names but it won...
Counting values in multiple combobox's
SolvedHello, I'm looking for some assistance with excel VBA, it would be great to gain your assistance. I've created a UserForm with 4 x ComboBox's, ...
What funtion/s should do i need
SolvedI'm working on tool for a user to input a qty of items, then calulate the number of cartons required. The cartons come in 1, 5 & 20 unit packs. ...
Multipul equations resulting in 1 answer?
SolvedHi all, Recently I asked the question below: https://ccm.net/forum/affich-348337-value-error-when-sourcing-data-from That solved the pr...
If cell a1 have data in copy date in b2
SolvedHello, please can you help on how the following works in excel. In excel 2007: If cell a1 are 1,2 or 3 then the current date displays in b2, or if da...
#value error when sourcing data from...
Solved....Negative conditional formatted cell In MS Excel. Hi guys, I haven't been very busy at work lately and the boss has told me do try and do 's...
Excel - copy rows "n" times with calculation
SolvedI need to have a macro that will copy rows from sheet1 to sheet 2 . The catch is from sheet 1 col C for e.g. C2 may have the number 5 in it. I need to...
Excel
Solvedhi i always make our employee salary in excel. this file is very big. every month I have to put only OVER TIME,WORKING DAY and ABSENT...and i make all...
Can a macro add a number?
SolvedI am working on a excel project where I will be able to click a button and the result would be a number added on another cell. For example, counting a...
Copy columns one below another
SolvedConfiguration: Windows XP / Internet Explorer 7.0 hi i have data in the following form a b c d 1 6 11 16 2 7 12 17 3 8 13 18 4 9 14 19 5 10 1...
Combining 2 cells to 1
SolvedHi, I have data like below in two column of excel sheet: 1-Jan | 2004 23-Jul| 2004 12-Feb|2003 ................ ......... Out out require...
Help excel: click & automatically copy paste
SolvedI need some help Let's say I have 5 different tabs named London, Paris,... Each tab contains different kind of information about the cities: popula...
Search and replace macro for microsoft excel
SolvedI have two workbooks with identical setup. item name address 1 address 2 address 3 x 12 34...
Click a cell and insert a wingding
SolvedIn excel I am wanting to be able to click a cell to insert a Selected wingding from a list. But to also beable to click the cell a second time to cha...
