Excel Forum
-
Help with macro [Closed]
hey folks i am trying to create a macro to copy lines of data to another worksheet baed on the original date meeting certain criteria I have a s...
-
how to move data in rows to columns [Solved/Closed]
The data now is in the below format 1 2 3 9 15 16 20 25 1 This has to come in this format 1 2 3 9 15 16 20 25 1 ...
-
If, then statement in Excel [Solved/Closed]
Hello, This formula sounds easy to come up with, but I cannot figure it out. I'm trying to figure out how to add a certain amount of days to a dat...
-
VBA code in excel to work for many sheets [Closed]
Dears who can help me. I have excel file includes 30 sheets for different 30 employees. I have the following VBA code. Private Sub Worksheet_C...
-
Copy data from one sheet to a master sheet [Closed]
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 [Closed]
Hello, 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 [Closed]
Hello, 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 [Solved/Closed]
Hello, 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 [Solved/Closed]
hello, 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 [Solved/Closed]
Dear 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 [Solved/Closed]
Hello, 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 [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...
