Excel Forum
-
Excel row removal/selection Closed
Hello, I am trying to select certain rows from a very large data sheet. Ideally I would like to select every 25th row so as to get a random sample of...
-
Excel 2007 conditional format question Closed
Hello, I have an excel 2007 file which I wish to be able to highlight a row if the first two cells in that row equal "Large code model" in the fir...
-
Excel - Macro|group by|based on time interval Closed
Hello, I need to write a macro for following example (copy and paste to excel with comma separated ',' delimiter). MS start and MS end column have...
-
Cut Entire Row To Another Sheet Based on Cell Closed
Hello Dears, If any one can help me. I have 2 excel sheets, Sheet1 "All Invoices" and sheet2 "PAID Invoices". In sheet1 I have several column...
-
Excel: check text in cell, add values Closed
Hello, I'm trying to create a formula to check a cell for a certain string of text, and then if it contains it, take the value of a number in that...
-
Comparing & replicating data, 2 Excel sheets Closed
Hello, all. I have 2 sheets of a spreadsheets I'm looking at in Microsoft Office Excel 2007. On the first sheet: a) I have 300,000 rows of user inf...
-
Excel Help Closed
Hi Everyone. Hope you guys can help. This is what I need I have 3 sheets in excel. Sheet 1 is my master and has products listed according t...
-
Excel Formula to Create Rows Based on qty Closed
Hello, I have an Excel 2010 worksheet with the following data Name ID Qty Joe 123 15 Bob 456 8 Ed 234 ...
-
Excel name match query Solved/Closed
Hi I have a column (A) in excel that lists all of the staff in an organisation, and in column B is their telephone number. In column C is a list o...
-
Need Individual Sheet Data to Copy to Main Sh Closed
Hello, I have a workbook I've created to track sales leads. I have a main sheet called "directory" and individual sheets for each business I conta...
-
Recording Macro with IF(OR(AND function Closed
Hello, I have recorded a macro on Excel with the function IF(OR(AND done but when I try to run the macro file in the test datafile, an error occur...
-
Split data into multiple sheets using macro Solved/Closed
Hello, Configuration: Windows Vista / Firefox 4.0 I have an excel sheet with the data in following manner. a b c d 1 1 1 1 2 2 2 2 3 ...
-
Inserting rows with formulae on existing data Closed
Hello, I wanted to know if a macro could help me deal with the following: The data is something like this: Column Field1 Field2 Field3...
-
Filter excel data using formula Closed
Hello, I have some data in excel, where I need to run filter option. But due to some constraints, I cannot use the manual option of filter in exce...
-
Need Excel Macro Closed
Hello, I am looking for a function or macros to compare two cells in two rows and return True if it has partial match. And one more condition to s...
-
Excel linked to database Closed
Hello, i m working on a excel sheet which is linked to database ,which means whenever i refresh it gets updated.i have created a new column in tha...
-
Excel Macro Help. Solved/Closed
Hi, I was wondering if someone could help me develop a macro that would reference a row in another worksheet. So for example if Column H = "x" in ...
-
Excel macro to identify/modify/combine cells Solved/Closed
Hello, I have a collection of survey results in Excel that are coded from another software that I need to prepare to put in SPSS, the results come...
-
on the excel codes Closed
Hello, I have copied the code, but from tools i try to run and a msg "type mismatch" pops up..what next?thanks Configuration: Windows XP / Inte...
-
Excel help required Closed
Hello, I have data from A1 to A10 I want A1 in sheet2A1 A2 in shett2A2 ........ and so on will u please hel...
-
MS Excel 2007 Date format issue... Closed
Hello, I have an XL spreadsheet with abt 15k rows, with a variety of data, the important ones being the dates - a start date and an end date. Based...
-
Excel search macro Closed
Hello, I have a very tricky problem. I have got an excel sheet having some columns but more than 5000 rows. In those columns there are some names w...
-
Excel macro for moving content Closed
Hello, I need a macro that will search for a specific set of values in a specific column for each row of a subset of rows. Example data can be ...
-
VBA code for a IF Function Closed
Hello, I need help on the following: Selecting a range on data e.g A1:A14 Searching for a certain value e.g 3000 if query is true then copy a ...
-
Excel Formula Closed
Hello, I have 1 Workbook with 2 sheets full of data, both sheets have identical data except for 2 Columns, DOB and Last name. I want a Formula on ...
-
Macro to find Min value Closed
Hello, I need code for part of my macro that will find the min value in a particular column and based on the min value clear the contents in other ...
-
Excel goal seek doesn't go through a macro Closed
Hello, I'm trying to use the goal seek function of excel to seek out a particular value of a cell (say Y) by changing values of another (say X). ...
-
Trouble recognizing data in excel sheet Closed
Hi, Dear All, I asked some time back about a question on how to highlight thevalues etc that i entered in an excel file, and Mr. Trowa has...
-
code for firm which open excel sheet Closed
dear sir, I want to create a one firm from where i want to open my existing excel file , how can i do this. Please help me. May I use some code fo...
-
Excel Macro help Closed
Hello, I have an excel spreadsheet table (on one worskheet) that has several date rows in one column C, and one cell J12, for a permit number havi...
-
Copy rows of data from one sheet to another Closed
Hello, I have used the below code to copy selected rows ("x") of data from one worksheet ("QBank") to another ("TestSheet") within the same workbo...
-
VBA Excel Last Used Cell Closed
Hello, I am trying to copy a range of data I have in several columns in a worksheet into one column (all the columns have the same name: OrderID) ...
-
Need Excel Macro Closed
Hello, I need a function or macros to compare two cells in two rows and return True if it has partial match. And one more condition to search cell...
-
hiding a different sheet in workbook Solved/Closed
Dear sir, I have one worksheet and there are 20 different sheet in that worksheet. I want to show 1 or 2 sheet and want to hide rest sheet. May i...
-
Report from Excel Data Sheet Solved/Closed
Dear Sir, I am new in excel. I am trying to use excel for my work easier. I have one excel file where there are different sheet of monthly salary ...
-
I need help with an excel formula Closed
Hello, I have a spreadsheet that I am trying to find a average of one column with several rows that if another column with several rows contains a...
-
Excel VB Macro Solved/Closed
Hello, I am new to vb and excel. I am trying to create a Macro that will look through all the worksheets in a workbook and find the column named "...
-
Excel issue Closed
Hello, There are 3 tables, A, B and c, according to the requirement A = B + C. Need to check the value for B, where B = A - c. Table A contains p...
-
Please resolve my issue ofMS Excel file highl Closed
Deat Towa, http://www.speedyshare.com/... Please see the below mention link, What i want is, 1. Those bolt which are consumed completely s...
-
Need Shortcut for full screen in excel Closed
Hello, Anyone give me the Keyboard shortcut to change excel sheet into full screen mode.
-
EXCEL MACROS; Clear, Compare and Replace! Closed
Hi, I need help creating three Excel macro subroutines.... This is for office 2003! The first one clears cells that do not contain "arg1"...
-
Codes for Reminder creation in Excel VBA Solved/Closed
Hello, I want to get Reminder message box automatically, according to the date and time in Excel worksheet. What are the VBA codings & procedures?...
-
Can someone help me write a macro? Closed
Hello, I have a large database of information (inventory). The datbase is constantly having rows added and deleted. In column (1), there over 100...
-
delete duplicate items in excel Closed
Hello, I need to write a macro where it deletes duplicates but the marcos out there seem to delete all duplicates I just want it to delete a cell i...
-
can not run macro Solved/Closed
hello sir, I am trying to put macro in any excel sheet then "can not run the macro" the macro may not be available or all macros may be disabled. ...
-
how to create shortcut keys to xl 2007macros Solved/Closed
Hi, I created few Macros in excel 2007,these working fine but how to assign short cut keys to these macros.In macros window in options property is ...
-
Ignoring rows with zero value Solved/Closed
Hello, A couple weeks ago ya'll helped me with some code to compare two sheets and create a new worksheet with all of the values that were identic...
-
excel delete blanks help Closed
Hello, I have a macro to delete rows where if the cell in column c is blank as follows: Columns("C:C").Select Selection.SpecialCells(xlC...
-
Highlighting the values entered in an excel Solved/Closed
Hello, Dear All, I have a question to ask, Actually i am working with an Excel File which has so many sheets under one file, and this file ...
-
Copying Data To Another Worksheet Solved/Closed
Hello, I have the following data in worksheet named "Auto Entry" Cell A1= X Cell A2 =Y Cell A3 =Z Cell A4=Input Value(1,2,or 3) In Cell A4 is...