The discussions
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...
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 ...
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...
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 ...
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 ...
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 ...
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...
Add cells with other identical attributes
SolvedI'm looking to create a formula which can be copied into other cells that will add numbers in one column, where their attributes in another column are...
Help with excel data selection
SolvedI would like to take a worksheet and create new worksheets for each specific value in a column. for example, one of my columns is "customer". I want...
Excel 2007 vba find last
SolvedI have a mutipage workbook where I am coping information from three sheets and consolidating the information to another sheet so I can export into a c...
Macro to find a info in more than one column
SolvedHi, I need a help to match values in a column from other two columns. I have two columns with some values on them. I have another column [t...
Excel frame a do while loop or macro
SolvedHi All, Could anyone help me to frame a Do While Loop or a suitable macro? I need a method to copy formulas present in Cells F10 to Q10 in She...
Insert rows with data when criteria is met
SolvedHi, Thanks in advance for your help. I have two tables. If a field in table A is chosen, I want a macro which will insert rows of the data listed ...
Input a range of cells
SolvedIf i want to highlight a row of cells in red to show a lead is dead say A1 to E1, buy inputting "lose" in E1 I now have the formula =$A$1="lose" whi...
Macro assistance
SolvedI have a spreadsheet that has data ranging from C3:C263. Workbook is 'GSU CAS Transactional Upload', Sheet is called 'Alliance Upload' I need to...
Excel macro to repeat and insert rows
SolvedI am trying to write a macro that will insert rows as follows: Col 1 Col2 Col3 1 S 456 2 A 222 3 M ...
Macro for array vlookup to worksheet
SolvedLooking for help with a quick macro please. I have four tabs in the workbook: Datadump - contains daily raw data to clean Central - Accou...
Need help with excel message pop up
SolvedI need Excel VB help to show a message pop up box to display whenever the value is below 10 or greater then 50 that's also not a multiple of 5 Con...
Updating data in two+ worksheets
SolvedI have a question, I just created a spreadsheet with 8 tables which contain a deferent data and with Autosum column on each table and I created als...
Pls help me with excel formula!
SolvedDear excel experts, I have a dataset of A1:A15. I want to make a formula stating that if 10 cells of the range A1:A15 are greater than or equal 2 ...
Excel formula!
SolvedI would like to make an excel formula that if at least 7 out of 10 cell (i.e A1 to A10) are greater than 5, then return as " accepted", otherwise "...
Selecting the required cells info from the co
SolvedHi, I have a data like below in one column in excel: SL#00000 Product: ABC Region Name: Name1 City :1 Country:1 User con: Id type SL#88888...
Conversion of values already present in cells
SolvedHi: I need to convert values already present in a range of cells to another currency. The current range changing causing headache. Any suggestions...
Copy paste - excel
SolvedHi I have a spreadsheet with a list of job titles in column A. there are a list of dates in columns G & I. there is information in all the ro...
Selecting a printer in an excel 2007 userform
SolvedI am using the following code: Private Sub CommandButton1_Click() Application.Dialogs(xlDialogPrint).Show UserForm1.PrintForm End Sub I can...
Excel 2007 - change cell color using if
SolvedI have a cell with a % in it. I would like that cell color to change to red if the percentage is below 60%, and change to yellow if it is between 60% ...
Lookup data on different worksheets
SolvedI have 2 spreadsheets with the same town names in column A and different dates in column N. I have a third spreadsheet with the town name and have ...
Excel find a value <>2#'s &get a value beside
Solved/ClosedHi All, I want to enter a number in cell A1 (Sheet 1) and have a formula which gets excel to go to sheet 2 column A finds the two numbers the e...
Excel formula for finding percentage of
Solved/ClosedHello, I need a simple formaul for finding the percentage of Total number of members: answer in column A392 Total number of members who have prov...
Conditional hide rows in multiple sheets
SolvedIt didn't solved yet. I have one excel file with multiple sheets, and all of them with the same columns and rows . I need to hide specific rows in ...
How to display formula in excel?
Solvedhi everyone, for example i have A1=H and A2=G, and A3=A1+A2 how do i make A3 show a final result of "H+G",display text instead of calculating the form...
Excel skipping a cell when calculating a tota
Solvedi have a series of codes back and forth it seems a bit insane. but what im wanting is for cell b1 c1 d1 e1 and etc to add together wich i have the fo...
Compare cell against multiple columns
SolvedConfiguration: Windows XP / Safari 532.5 Hopefully I can explain this as simply as possible. First here is what my spreadsheet looks like I have sepe...
Excel - run macro on cell change
SolvedI am trying to have 1 of 8 different macro's run depending on the value of a specific cell. If I enter 1 in cell A3, I would like macro1 to run. If I...
Vba code for excel ..........................
SolvedDear Expert, Below written VBA code is being used by me to insert jpg picture in the excel file against the code number and its working very well a...
Macro to delete blank rows?
SolvedI have a spreadsheet where I would like to 'record new macro' to delete all rows that are blank. If I filter on blank rows and delete....the macro wi...
Why won't this work?: update graph's year vba
SolvedHi, My graph has a timeline of one year. After that year the timeline needs to be updated. To get the current year I have used the functions TODAY...
Moving specific data into separate worksheets
SolvedHello, I have a list in a column as follows: DAY TYPE PHASE 1 ...
Hyperlink macro
SolvedHi Have a customer profile sheet that has a new customer number each time it is opened. Details are filled in for the customer then a post button is...
Macro to copy and paste values
SolvedHi I am a complete novice when it comes to macros. What I am looking for is a macro that when run looks in Cell Q7 on Sheet 1 to see what number is...
Please help macro or formula excel
SolvedI've 4 columns and 10000 rows like this : Month Plant Area Budget Jan ........ A1 ........01 ........ 1000 Jan ........ ...
Multiple tabs set row count based on sheet 1
SolvedHi Sheet 1 contains > 1000 rows of populated data. I need to create x number of tabs each containg the next 25 rows from the sheet1 data. ie 1000...
