The discussions
Copy data from one sheet to a master sheet
Hello, I have a worksheet, sheet1 where I enter the product code and it gives me the Bill of Materials for this product. I would now like to cop...
Excel
ClosedHello, I am trying to make it easier to get expense totals by category. I have created a spreadsheet that has text (expense categories -- meals, ...
Vba for repeating groups of rows
ClosedHello, I need to copy several rows of data n times. An example of the data would be: 63111 64546 67818 So that the results of the VBA would...
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] ...
Macro for deleting row with condition
ClosedHello, 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
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
SolvedHello, 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
ClosedHello, 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
SolvedDears 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
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?
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
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
SolvedHi. 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
SolvedHello, 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
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
SolvedHello, 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
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?
ClosedHello, 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
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
ClosedHello, 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
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
ClosedHello, 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
ClosedHello, 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
ClosedHello, 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
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
SolvedHello, 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
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
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
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 ...
Copy a row to another sheet with conditions
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
ClosedHello, 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)
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
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
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
SolvedDear 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
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 ????
Hello, as the title says why excel treats same kind of formula in 2 different ways??? thanx
Percentage formula for microsoft excel
ClosedHello, 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
ClosedHI 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...
Lookup problem from excel 2007
ClosedHello, 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
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...?
SolvedHello, 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
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
SolvedHello, 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
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
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
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...
