Excel Forum
-
macro for deleting row with condition Closed
Hello, suppose I have one column in which there are 24 rows i.e. A1:A24 and these rows contain some value I need to make one macro in which I ...
-
Delete rows that don't match another data set Closed
Hello, Excel 2010. I have essentially two data sets. One is a dump from an analytics tool that contains about 8,500 rows of data with about 3 c...
-
Excel Solved/Closed
Hello, My name is amit and i am having problem with creating a excel sheet which has three columns stating date , service and amount. and now i wan...
-
VBA Code to copy row based on dates Closed
Hello, I have a spreadsheet that I am compiling for completed work orders. The sheet I want to copy the information from is called "Completed". In...
-
VBA code in excel Solved/Closed
Dears who can help me to write VBA code to solve the following case: I have Excel sheet to calculate overtime, includes several rows for each month...
-
Compare 7 colums of data in 17 worksheets Closed
Hello, I am a complete beginner with Excel, so please excuse me if this makes no sense !! I have made a spreadsheet for driving hours which add...
-
Excel 2003 Color Drop Down Menu limit of 3? Closed
Hello, I am working of Excel 2003. I already created a drop down menu which has 6 items in it. When I get to the part about "Conditional Formatting"...
-
MACROS Closed
Hello, I want to create a VBA code which if can fiend in column "B" the value ICA to copy the row in another worksheet. EX A B C D 1 ICA 2...
-
Macro or VB in Excel 2007 Solved/Closed
Hi. I have next to no experience with macros & VB. But I have a problem that I need resolved. I have 11 sheets in excel. 10 sheets need to pull in...
-
To get cell contents into Excel file property Solved/Closed
Hello, Can you please kindly help me to solve the below interesting issue? (I will make my best to make myself understood, which is sometimes very ...
-
Copying certain cells from one column Closed
Hello, I want to copy certain cells depending on their value contents from a column into another column but follow their order. If some cells ar...
-
Excel Macro to insert row based on data Solved/Closed
Hello, I have a large spreadsheet w/ over 9,000 rows of data. I would like to know if a macro can be built to add a row(s) based on the month. In t...
-
Excel 2010 Using Absoloute reference Closed
Hello, Hello, I would really appreciate if you could help me out, I'm trying to copy a forumula using the $ absolute referencing. My column is...
-
Excel 2003 color drop down menu limit of 3? Closed
Hello, I am working of Excel 2003. I already created a drop down menu which has 6 items in it. When I get to the part about "Conditional Formatt...
-
Using Excel Closed
Hello, I'm trying to find the necessary formula or formulas that will let me enter a single or double digit number into one cell, example C3, tha...
-
match different columns and return a value Closed
Hello, Hi Guys, I have a list which looks like this A B C 2 0 3 3 4 4 67 67 89 14 8 8 What i want to do here is match the tw...
-
Copy cell contents from worksheet function Closed
Hello, I have a question re: Microsoft Excel 2007 :- I have a worksheet of raw data named 'raw'. I also have another worksheet named 'graphs...
-
Sharing info between worksheets based on term Closed
Hello, Configuration: Windows Vista / Firefox 8.0.1 I have a master pipeline and in the Status column there will be terms such as "closed",...
-
Excel - How do I compare 2 columns 4 differnc Closed
Hello, I'm trying to figure out how to compare two columns (i.e. reports) in Excel 2007/2010, where one is a comprehensive report listing every em...
-
querey-ms excel2010 Closed
Hello, HI I have a work book which has few spreadsheets 1 spreadsheet name FC SECOND sheet name SV81 , third sheet name SV83 ,fourth sheet n...
-
Combining three different macros Closed
Sir, I am a beginner in writing codes(macro's). With great difficulty i have written three different macro's to copy data from main sheet to thre...
-
Copy info from several cells into one cell Solved/Closed
Hello, Could you please help me solve my issue bellow? I have several sheets in Excel, i.e. Sheet 1, Sheet 2 and Sheet 3. I wanted that A1 cell from...
-
Excel Data - Matching and Sorting Closed
Hello, I have 2 spreadsheets, Spreadsheet 1 with names and contact information, and SS 2 with contact information and an ID number. Names are in C...
-
Comparing columns and returning value Closed
Hello, I have an spreadsheet where I want to compare values between two columns and return the value from the relating row in a third column. If A...
-
Macro to find and copy cells Closed
Hello, I have never wrote a macro using VB I normally just do simple ones step by step, could you please tell me how to do one that finds the cells ...
-
excel 2010 absolute reference Closed
Hello, Hi, I'm trying to copy a forumula using the $ absolute referencing. My column is as follows: Jan =$c46 Feb =$D46 Mar =$E46 etc ...
-
Copy a row to another sheet with conditions Closed
Hello, I am very new with coding in excel. I have a sheet called AFF with rows containing different information. If a cell in column Q is not e...
-
Excel macro selecting column Closed
Hello, I need to select a specific column relative to the active cell in a macro. Specifically, regardless of the Active cell on a given row, I want...
-
one column multiple rows (data in sets) Closed
Hello, I'd be grateful for any suggestions... So what I have is gene A 1 2 3 4 gene B 1 2 3 4 and what I would like is gene...
-
Macro Help In Excel COPY PASTING Closed
Hello, I am trying to copy data from a excell spread sheet that is actually a set template i.e. Name:John Doe Age...
-
vba - compare two sheets Closed
Hello everybody, I have two sheets: - sheet1 holding 3000 entries of all the guys - sheet2 holding the transferred guys i need a macro that...
-
Excel Data Reading from another Excel Shheet Solved/Closed
Dear People, I have a small Requirement in Excel. Can you please help me out? Problem Description: Content of Raw Material Prices are maintai...
-
using functions in excel, match, vlockup Closed
Hello, I have two columns with numbers and i need to find the numbers in 1st column that apear in 2nd and vice versa. But my problem is next: when...
-
"">[no.]=true & ""<[no.]=false in excel ???? Closed
Hello, as the title says why excel treats same kind of formula in 2 different ways??? thanx
-
percentage formula for microsoft excel Closed
Hello, Im looking for help regarding a pricing sheet im trying to create on excel.I have my list of costs ok where im adding the totals in the cells ...
-
Identifiying data that does not match inExcel Closed
HI There, I have two columns in excel, I would like to verify that the information in Column A, is the same as in Column B, and if not I would lik to...
-
Format Cells based on a letter in other cells Closed
Hello, Sorry I'm new at Excel, but here is what I'm trying to do: I'm making a work schedule. 3C through 3AG represent the days of the week. ...
-
lookup problem from excel 2007 Closed
Hello, Just want to seek for assistance about my problem for lookup data.Actually i have data as per below. PO Items Qty 0001 a 2 0001 b 10 ...
-
Excel data Extraction issue Closed
Hello, I have the following issue with data extraction with Excel. I have a list of data (barcodes) dynamically populated - which means that ever...
-
how to compare several columns...? Solved/Closed
Hello, could anyone help me with this. I would like to compare two columns: A B C D Peter 4 John 3 John 3 Peter 5 G...
-
Using Macro for conditional formatting Closed
Hello, Im in desperate need of help!!! I have an excel sheet with a list of employee number,rank,primary schedule, and secondary sched, years of e...
-
How to extract info from csv files to excel Solved/Closed
Hello, I have 74,340 .csv files I need to extract information from Col. A-C & Rows 1-143 into an excel workbook, Sheet1. Every .csv file has diffe...
-
EXCEL VBA macro Closed
The situation is: I have a about 15000 lines of data that needs to be cleansed. I need to change the Item description from e.g Uncleansed = OFFSET...
-
Reg: Excel query Closed
Respected Sir/Madam, This is regarding a query that i have in MsEXCEL. I would like to know is there any formula or script so that i can get the...
-
Transfer data to match on Excel Closed
I have two reports. One is from 2010, the other is from 2011. Within each report is the same information...account numbers, member names, credit sco...
-
Paste to all sheets except some with criteria Solved/Closed
Hi, How can I make a macro paste copied data into some sheets of a worksheet but not other sheets. For example, I have 10 sheets in my worksheet ...
-
Formating a column using macro Solved/Closed
Sir A forum member helped me in writing a macro to copy certain data from sheet one to sheet two. I modified basic macro to suit as per my require...
-
Excel VBA User Form Closed
Hello, I am quite new to Excel VBA and I , desperately, need an expert help. am trying to create a user form that generates customer IDs made of 9 ...
-
Call an excel document to another sheet Closed
Hello, Can any one suggest how to call a separate document(or) a Cell from one excel sheet to another excel sheet. For Example Book 1 got he...
-
Automatically copy from one page to excel Closed
Hello, I want to copy information from one sheet to another regarding the categories. For example if I have airline company name, aircraft type, ...