Excel Forum
-
Linking excel sheets and getting 0's all over [Closed]
Hello, I have a document that we adjust the master, and then each fiscal year I want on separate sheets but to be updated with the master. I linke...
-
formula: to count cells and then add number. [Solved/Closed]
Hello, All Hope you can help! I have a list of actions 1 Contacts 2 Appointments 3 Estimates 4 Sales contacts counts as 1 contact,...
-
Macro not working in shared work book [Closed]
Hello everyone, my macro works fine, but when i share my work book it is throwing some error, Run-time error '1004': AdvancedFilter method of R...
-
Needed a VBA. [Solved/Closed]
Hello, I'm very new to progamming kind of stuff... i need to generate a report from a excel sheet. Coloumn Q of "data" sheet has only 0 or 1, whi...
-
Update the value of excel files [Closed]
Hello, i wanted to ask if there is a method so that i can keep other excel files updated when i make some changes in a particular file.....suppos...
-
move rows to columns using macro [Closed]
Hello, need help with macro to move rows to columns please E-Mail ID is removed for your security if you can help with this. thanks
-
Excel "if" for letters to equal values [Solved/Closed]
Hello, I have a yes or no sheet, one column for yes and one column for no. I want the end column to calculate a 1 for yes, and 0 for no, and in s...
-
VBA Transfering Data To Next Sheet [Closed]
Hello, I'm applying this code to transfer data from sheet 1(source) to sheet 2(destination). Sub TransferData() For Each cell In Range("B...
-
Macro help [Closed]
Hello, i use a macro for filering my data into another and macro code is Sub Extract1() ' ' Extract1 Macro ' extract ' ' Keyboard S...
-
Excel 2007 [Closed]
Hello, I am a very novice/beginner Excel user. I have a table of Company information in a vertical column which I want to convert to a horizontal...
-
EXCEL Move A1 to A2 in a formula [Closed]
Hello, I have a 9 digit zip code in column A. I need to phyically move the first 5 digits to column B cell by cell, i.e. A1 to B1, A2 to B2, e...
-
Excel question [Closed]
Hello, I am using Excel for inventory and invoicing. They are in different workbooks. I have to fill in the information in each workbook. My ques...
-
Simple Excel Formula Help [Solved/Closed]
Hello, Configuration: Windows 7 / Firefox 3.6.17 Hey guys I'm doing some project on Excel for a class. When it comes to entering and crea...
-
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 "...
