The discussions
Macro for finding dates
SolvedHi guys, Is there a macro that would give me the the cells in a column in which there are dates between 2012 and 2013. It can be easily filtered b...
Macro to copy data
SolvedHello, I have two excel sheet with three column on each sheet Sheet 1 Sr.NO Code Name 1 1256 2 1256 3 1258 4 1258 5 1259 6 1259 7...
How to build a macro that does this...
SolvedHello guys, I would like to build a sheet that contains several names and infomation pertaining to each name. The first tab would be the search in...
Separating items from columns
SolvedHello guys, Could you please help with this... Is it possible to do the following in excel: I have similar cells to this in one column: Ford v-36...
A macro to move data from rows to columns
SolvedHello, I have data in a single column and would like to copy it into a rows for every x rows, for example; The column of data varies in the amoun...
How to match 2 row of data in excel ?
SolvedHello, brothers & sisters I have 2 columns of companies name say (column a=38900),(column b=1000) so how can i use a formula to do a match by thei...
Excel, comparing two sets of two rows
SolvedHello, I know the title may be a little confusing, and I apologize for that, but I really did not know how to phrase it. What I have is two Excel...
Macro to compare two excel sheets
Solved/ClosedHello, I need help to write macro to compare two sheets, sheet1 and sheet2 on same excel book and display the result on the third sheet. The ...
Excel help
SolvedHello, I have a schedule for the employees, and it contains seven columns as 7 days in a week. If any range of the columns contains text " ...
Excel: comparing two columns and output data
SolvedHello, I'm using Excel 2007 and am trying to figure out a way to analyze and sort some data. I have two sets of data in 6 and 5 columns in the sa...
Problem with excel
SolvedHello, I was trying to write a formula in excel where IF A1 is greater than 7 then 1 would be substracted from it and if it is greater than 5 but...
Excel: splitting of data based on calculation
SolvedGood day, I would like to seek help to how to split and populate data based on the result of certain calculation. Here are the criteria for the...
Excel 2007 if function
SolvedHello, Need formula to say if cell has NA put 0 but if the cell has a date (yy,mm,dd) then subtract cell L1 from cell E1. Trying to determine how ...
Vba - transferring select data to new sheet
SolvedHey there, I'm trying to create a macro for an Excel 2003 spreadsheet that will take a record (a row (or rows)) that I've already selected into a new ...
Vba code to conditionally copy the data
SolvedHello, need help! see I need a vba code that can copy data from sheet1(raw data) to sheet 2,sheet3 and so on is certain condition matches..exam...
Vba macro help
SolvedHello, I have a report that I am using for a customer of mine that lists there kits in a matrix for me. Once in a while I find an error where a kit...
Split mutiple columns in sets of 40
SolvedHello, I have data in 3 columns A,B,C and it goes to 1000 rows, I want it to be splitted in sets of 40 each . Like first 40 then next 40 and so on...
How to concanate two cells "line by line"
SolvedHello, I have one cell that has names separated with alt + enter. On the other cell, I have additional information on those names (also separate...
Text to n rows + copy row and insert n times
SolvedHello, I would appreciate your help with a macro I am trying to create in Excel 2007. My data is as follows: Column1 Column2 Column3 Column4 D...
Excel macro - set and autofill a range?
SolvedHello, I recorded a macro for excel and part of the code is to create an index column that fills the cell with a row count (i.e. A2=1, A3=2, etc.)...
How to copy informations from excel to ees
SolvedHello, I wanna know if anybody can help me to copy 2 columns (supply) from Excel to EES (another program if anyone used it before) and then copy the...
Excel 2007 activex option button default?
SolvedHello, I have two activex option buttons, Yes and No. How do I get it to display "No" as marked as a default? I have created a process that c...
Excel date formatting into another column
SolvedHello, I want to check using IF function in one column and change the date format to another column from MM/DD/YYYY to has DD/MM/YYYY in excel 2010....
Excel - transfer information from file
SolvedHi there! I have run into some problems when transferring information from one Excel file to another. I have a big Excel file with a lot of informa...
Add when multiple criteria is met in rows
SolvedHello, I'm trying to add numebrs when multiple criteria is met! I want to add numbers in B115:BF115, but only the ones that have an "A" in row B8...
Sumifs in excel 2003
SolvedSir I was using System with office 2010 and deriving some values by using "Sumifs" function. Now i am using Office 2003 system. When i copied the wo...
Create new worksheet & copy the based on date
SolvedHello, Can any one help me to copy the excel sheet data from one sheet to another sheet? -> I have one excel sheet (name: Test.xls, sheet name: S...
Copy worksheet to another workbook (unopened)
SolvedHello, I want to copy a portion (A1:F54) of my current worksheet that I am working on, over to another workbook, that is not open. I want to use ...
Excel macro help needed to name ranges
SolvedHello, I have a 10 column x 500 row spreadsheet A1:J500 I would like to name ranges as follows: Range A1:J1 should be named with the content of...
Excel related
SolvedHello, could you please tell me how I get excel to automatically use a color in a cell that I write something into? The blank ones can remain colo...
Macro to create worksheets
SolvedHello, I'm Mike, I'm new to Macro excel I need a Macro that read from a table the name of projects and create for each project a sheet named th...
How to make 2 vba codes to work correctly
SolvedHello, How can I correct the following 2 codes (which written in the same sheet) in order to work correctly, other wise it gives me Error (debug)?...
Auto-copy of select rows to another worksheet
SolvedHello, This is my first time asking a question, so I will do my absolute best to follow and respect the forum guidelines and it's contributors. I...
Correcting vba code in excel
SolvedHello dears, I have the following VBA code : Private Sub Worksheet_Change(ByVal Target As Range) Dim cRow As Integer If Intersect(Target, Ra...
Highlight unique or duplicate on 2 sheets
SolvedHello, I have a Excel file of 2 worksheets and have a list of Usernames on column B of both worksheets. Few of the usernames appear on both sheets...
Excel dynamically fill cell with data
SolvedHello, I have worksheet ( AllUsers ) with two column A ( user id ) and B ( date ). Column A is a long list of user names and B is a list of dates ...
Copy text frm a cell n append it thru macro
SolvedHello, I am trying to create a macro where I want to copy a cell content from one worksheet and append it to a cell in another worksheet of the...
Column comparation in different datasheet
SolvedHello, Hello, I have one excel column A in datasheet 1 which has a list of names. In Column A of datasheet 2 I have a much longer list of n...
Vba copy/paste cells then drop 1 row for next
SolvedHello, I am making a questionaire. When the questionaire is complete I want to copy the answers to another worksheet then reset the answers to zero...
How to determine cell value in excel column
SolvedHello, Sorry the title is really vague, it's hard to describe with a limited number of characters. I have a column (C) which contains a full li...
Excel macro
SolvedHello, I wonder if anyone can help me with a small (I think) problem, please? I'm trying to write a macro to manipulate a spreadsheet sent to m...
Compare cell a1 to entire a col in sheet2
SolvedHello, I have been trying to compare sheet1 A2 to sheet2 A2 through A500 and if it exists somewhere in sheet2's a col then copy that entire row to ...
Excel problem
SolvedHello, Hello, I am hoping that someone can help with the following problem, I have a list of numbers, golf staplford scores, located in cell...
Excel - copy data macro
SolvedHello, I am currently learning the tricks in excel but have become stuck. I have created an expenses sheet where employees record various expenses...
How to move data in rows to columns
SolvedThe data now is in the below format 1 2 3 9 15 16 20 25 1 This has to come in this format 1 2 3 9 15 16 20 25 1 ...
If, then statement in excel
SolvedHello, This formula sounds easy to come up with, but I cannot figure it out. I'm trying to figure out how to add a certain amount of days to a dat...
Excel: populate data based on criteria
SolvedHello, Good day. I would like to populate data from 1 sheet to another sheet based on certain criterias. With reference to the sample data provide...
Excel comparision
Solvedhello, can any one help me solve the following comparison problem.. a(reference data) b(raw data) c(status) ab ...
Vba code in excel for 200 sheets
SolvedDear all who can help me. I have salary excel file. This file includes 200 sheets which are for each employee. I have the following VBA code. P...
Excel help
SolvedHello, If possible, can you help me in coding this: Collumn J will have the drop down menu of Open, In Progress, Complete [Open as default] ...
