Excel Forum
-
Macro help Closed
Hello, Is there a Macro available that will allow me to only pull unique data from one worksheet to another? For example, I have a bunch of data,...
-
urgent help in macro Closed
Hello, happy nEW year i need your urgent help in macro . i have some data like below in excel A B C E F Customer Name RDS ID Device ID Produ...
-
Calculating time in an Excel formula Closed
Hello, I have an Excel formula that works: =WORKDAY(A2-13.5/24,1)+IF(NETWORKDAYS(A2,A2), IF(MOD(A2,1)*24
-
How to chang text color automaticaly in excel Closed
Hello, I want to chnge the text color if the value of other relative cell is changed. For eg. I have cell range from B11 to XAV11, if any value...
-
HELP IN MACRO Closed
Hello, happy nEW year i need your help in macro . i have some data like below in excel A B C ...
-
Excel 2007 Moving information button Closed
Hello, I need to create a button which movies an information from one row in one sheet to other row in another sheet. I can create it with macro 1 b...
-
Compare two worksheets macro Closed
Hello, I was looking for some help as far as setting up a macro that compares to worksheets into a third worksheet and came across this macro. Thank...
-
Try to match cells and return values Closed
Hello, I need help!! I have a table containing the following: Column A Column B Column C Column D product Country State Date ...
-
vb macro to copy image from file to cell Closed
Hello, I have a VB issue, i have a excel sheet where i wish upon entering a number in column C (starting at row 10) a jpeg with the same name will...
-
EXCEL 2007 HIGHLIGHT MAX&MIN VALUES Closed
Hello, I have lists around 500 rows long each group of dates ×& marks separated by an empty row is there a macro to highlight the max&min values ...
-
create a new matrix in excel macro Closed
Hello, I would like to create a new matrix under some conditions from old dataset. Basically, I want to choose rows from the old data as long as ...
-
Data entry in two excel files using a form Closed
Hello, I have two excell files "a.xls" and "b.xls" both are having Three sheets "Sheet1", "Sheet2" and "Sheet3". Both the sheets are protected by...
-
how to check for the last row of excel Closed
hi, i am writing data from csv file to excel using c#, by data contains more that 80000 rows, so i want to check the end of the excel file i.e the ...
-
Countif macro codes on multiple criteria Closed
Hello, I need a macro codes with condition applied in formulae. I have a text as below in excel from C1 to C33 and i want a macro to count of "f...
-
Highlighting Cells based on Dates of other ce Closed
Hello, I am working on the following. I have names of customers in column A and dates in columns B, D, F, H, J and L. I am trying to highlight the...
-
Rollup or summary sheet Closed
Hello, i am quite a 'newbie' at VBA and have run into something that i can't seem to get started. i have sheets by month that have the same amoun...
-
Copying data excel worksheets Closed
Hello, Can someone give me an easier way to do this? I have in column A; Team 1, Team 2, 3,4 etc down to 30. In coloumn B, I have 'week 1' Afte...
-
Match Excel Data and return associated data Closed
Hello, I have an excel sheet that I am trying to match data up on. Essentially, my data looks like this: Column A Column B Column C Col...
-
Microsoft Excel Look Ups Closed
Hi Guys, Please can you help. I am trying to do a formula which allows me to look take a cell, for example the word 'help' and look for it in a...
-
Excel-format exported file to proper col/rows Closed
Hello, This is my problem: I generate a report from my accounting system and export the data to Excel. As an example, if i generate a sales order ...
-
Excel Search & display query Closed
Hi All, I am a non IT person.. I have a simple requirement, but dont know how to go about. The requirement is My data. Sno Release Project ...
-
may i request help with comparing two columns Closed
Greetings everyone, I needed some help and would appreciate any comments or advice if possible. I am working in development finance and i got ...
-
vba search & find, select entire row and move Closed
Hello, Hi, Can anyone help????? I need vba for cmdbutton on userform to move one row data into another row. I have a worksheet "details1" ...
-
Macro to class interval Solved/Closed
Hello, I have a workbook of employee data and at dth column i have ages of employee. in eth column i have to define age interval like. 18-25...
-
VBA for excel Closed
Hello, I need to open one after another xls files from the spec. folder, then activate another workbook and copy 4 cells from it, then paste those...
-
I need information to move to the next cells. Closed
Ok, so my problem is probably simple, but since I'm new to this, I'd like a little help. So, I have stuff that I have in "Quote Download" tab, and I n...
-
macro code for making a graph in excel Closed
Hello, I would like to create a graph from a macro. Here is what I have got so far. Charts.Add ActiveChart.ChartType = xlXYScatterLinesN...
-
macro regarding the cell color Closed
Hi I would like to have a macro for the following when i type "red" in a cell the whole cell turns red when i type "orange" in a cell the whole ...
-
Extract info from Excel Closed
Hello, I wonder if you could please help me. I thought this would be something simple but after an exhaustive search and using filters and Vllookup I...
-
Excel less than but greater than Solved/Closed
Hello, How would I get into L2 if J2=>10 then "lates", if J2=
-
Excel-extracting names into seperate elements Closed
Hello, I have several hundred names in an excel file written like this Doe, John A and I want to seperate them into 2 columns with first names in ...
-
Excel 2007 date 20100915 without formatting Closed
Hello, I have a column of dates (around 800 rows) with dates entered in as 2010/09/15 as date format. I need to convert these to GENERAL format an...
-
find and replace in EXCEL Closed
Hello, all i have been suffering to find a solution for a problem which is : I have three categories which I call region (Central, Northern and ...
-
How to add COUNT to a column w/ 3000+ rows? Closed
Hello, I have a column with numbers in them (1) Column, over 3000+ rows. How can I simply add the 'COUNT' text in each cell without having to ent...
-
Highlight max/min in excel 2007, VBA Closed
Hello, I'm quite new to Excel VBA and need some help doing the following. I have a lot of data and need to highlight (or change the background ...
-
Macro - check name and then insert blank row Closed
Hello, Would appreciate any help on below. I need a macro that would insert a blank row after each unique entry. To illustrate imagine follo...
-
Excel Formula to populate fields Closed
Hello, I have a spreadsheet with Employee names (A2...A150) & one of 5 Divisions that they work for (B2...B150). What I am trying to do is put the...
-
Copy 5 columns and paste to next 5 columns Closed
Hello, I have to run daily reports where I have to add new day data to the right end of the spreadsheet. Example is below. I want to create a macr...
-
How to copy sheet1, sheet 2, sheet3 in Sheet4 Closed
Hello, How to copy sheet1, sheet2, sheet3 and Sheet 4 in Sheet 5(same excel workbook) using macro? I want to copy columns A-W The rows will ...
-
how to do in excel Closed
Hello, I've four columns: A (with Names), B (with date of birth), C(random name of column A) and D (the result i want automatically). What formul...
-
COlor change macro Closed
HI All, I need an excel macro where i require to do the following things: if i type RED then the cell in which i type RED turns red, SImilarl...
-
Excel if function Solved/Closed
Hello, Could someone please help me with the following problem. I want to know how to do a if function in vba to search for a value (output), a...
-
Macro to find and copy all columns Closed
Dear all, I've searched online for 2hours but still unable to find suitable threads, please direct me to the information or help me out with the fo...
-
Excel Macro assistance please. Closed
Hello, I am trying to write a simple Macro which would look at a corporate organizational chart in Excel. The Macro would list the company name an...
-
Excel Macro, Time input button Closed
Hello, Excel Macro Help PLEASEE!!!? Ideally i want a time in and a time out button, so that when workers sign in they click the timein button a...
-
excel hide column formula Closed
Hello, I'm trying to find a way to hide a colum in my excel workbook when I would select one of 3 drop down menu items. The drop down list is lo...
-
Copy Paste multiple rows - incrementing issue Closed
Hello, I'm having a problem, I have 9 rows of data that contain formulas that pick up data from other worksheets. When I copy and paste to the nex...
-
excel: don't print when cell value is 0 Closed
Hello, Please, I have an excel file with several worksheets. I made a macro that when I click a button, the worksheets are printed. There are sev...
-
Filter Problem in Excel 2007 Closed
Hello, Im Xishan, using excel 2007 & facing problem while delteing rows of filtered data. When i delete filtered rows, other rows(unfiltered ones) ...
-
Help! Trying to copy rows of data via macro Closed
Hello, I could really use some help. Here is what I am trying to do.I have a mound of data that i want to break up into different sheets. I want to u...