The discussions
Compare sheet and return last column
Hello, I have two sheets with the same column to compare as follows: Sheet 1 Column A: First name Column B: Surname Column C: Father's name ...
Merge data from 3 columns into one cell
ClosedHello, I am trying to make bin labels for my parts dpt. I have a file with 3 columns but it's 2051 rows long. I need the data from the 3 columns to ...
Excell: consolidate dupes and add missing dat
Hello, I can's seem to find an answer anywhere for my problem. I have a CSV list in excel that has companies contact information and what category t...
Excel conditional format or formula help
Hello, I need help for conditional formatting or a If/then/And/or formula that can assign numbers for multiple criteria. How can I set up a bla...
Needed macro for raw data arrange in colunms
Hello, i have data in multiple row and transfare in colums, Please help me. 001 GEN V C 00:00:55:02 00:00:58:00 02:01:00:00 02...
Excel: chnge gen # format to date format.
Hello, I have searched this site but can't see how to get an Excel colume I have to convert to a date format. The column has dates in this general nu...
Save the html page as excel sheet
ClosedHello, I have a HTML page which contains a table. I want the contents of the data to be stored into an excel sheet. For this I want a pop up asking...
Assign value from one cell to other-excel vb
Hello, I need to assign a value to a cell and to the following 5 cells. If I could assign a value to a cell from one cell to another it would lo...
Icons and browser wont open
Hello, Some, not all of the program, file icons and internet browser icons on my laptop wont open, when I click on them a screen pops up asking m...
Excel vba to filter rows containing same word
ClosedHello, In my Excel there is a column, say, column A, where all the cells are text string such as company names. My task is to filter all the rows w...
Macro sum
ClosedHello, Can I get a macro to add a total line? I want to specify the starting row each time, but then sum down to the row above the totals. I'v...
Excel macros>functions
Hello, I have a function that I need some help with to save a mass amount of time. I have a report tab named "total" which I would like to keep, bu...
Compare columns and update the row
Hello, I need some help with a VBA code. I have tried differents codes that i found in the forum but they didn t match with what i m looking for...
Macro to delete rows containing a date
Hello, On a daily basis I populate data on different worksheets. Meaning on each day I have to delete T-2 data to populate T-1 data. I would lik...
Excel 2010compare multiple columns of data
Hello, I have been given 6 seperate excel docs with serial numbers in, i have created 6 columns containing these different serial numbers but now...
Excel03searching row,then deleting/updating
Hello, I'm currently trying to piece together an Excel spreadsheet with the following functions done by forms: 1) Add data (including a unique 6 ...
Excel
Hello, please giveme the formula of percentage Configuration: Windows XP / Internet Explorer 6.0
Excel macro to copy cell i4 to active cell
Hello, I'm trying to write a macro to copy data in cell I4 to the cell I select (also in column I), but I'm confused between absolute and relative...
Vb excel 2010 - loop until can't find
SolvedHello, We are trying to manipulate data from a very old DOS program. We have a lengthy macro that works well until the end where it seaches for s...
Excel transfer
Hello, I have a problem. I want to transfer some data from the files to excel. I meant I have some forms from my colleages about their work ti...
Excel: locate value in one list & copy
SolvedHello, I need some help with Exel. I have two lists: List one contains two coulmns: ID numbers and age. List two contains also two coulms: ID ...
Data reshuffling of cells
SolvedHello, Dear Friends, I need your help to solve the following problem. I have few files containing data of more than 50,000 records. Some rec...
Transfer data in one sheet to another sheet
Hello, how i can transfer some cells in one sheet to another sheet automatically. for example i have one sale report that i want to this information...
Summary with data from different worksheets
Hello, I have a file with 42 worksheets, all the same format (kind of "entry screens"). I need to create a summary table listing the data from all ...
I want to compare data in two sheets
Hello, I am stuck up with a problem in macro please do help me, I have 2 sheets with data i want compare two sheets, if the data is same it should ...
Excel: if cells match use related value
Hello, Here is what I need to figure out how to do: If the value of A matches any other cell in A then I need all matching columns to t...
Deleting multiple rows (2 rows and leave 1)
Hello, I need a REALLY QUICK reply. I'm working on a worksheet in excel that has hundreds of rows and I want to delete every 2 consecutive rows an...
Two worksheets compare info and insert data
Hello, I have two worksheets and I am trying to find and compare information in one and then return the matching information to the spreadsheet fo...
Problem with excel 2003
Hello, I have a problem with excel 2003 I am trying to do this: i have a sheet with 20.000 rows and some of them (the rows with the died perso...
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...
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...
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...
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...
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...
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...
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 ...
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...
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...
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...
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...
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...
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...
