Excel Forum

Vba excel 2010

Hello, One more question! I'm looking for a code that will allow us to compare rows of data and highlight which rows are different. We have 2 ...

Excel - cells formatted as numer pesel ???

Solved

Hello, Firstly, just a quick one: I want to use conditional formatting to check if a cell ( say A1) has a red background and if it does then re...

Excel - macro to search & paste to new sheet

Hello, I am working on a log for items that have gone in a machine at work. Some of the items come out damaged and therefore are void. These are a...

Deleting and combining rows in excel with con

Solved

Hello, I hope someone knows the answer: I have simple table Column A: item # Column B: text example: Item # Text 2 text 1 2 t...

Copy paste autofilter data macro to new sheet

Hello, Dear all, I have a worksheet "data reqd" which will be generated by a macro based on the input of another sheet. I am herewith attaching my...

Copy/paste cell a to new sheet if cell b=1or2

Hello everybody, I am slowly trying to learn about Macros to make my data sorting and report running easier and am asking for some help/guidance fr...

Microsoft excel

Hello, In column A I have specific numbers in each cell (i.e. A1= 1, A2=2, A3=3, A4=5), then in column B I have cells that have numbers as well (i.e...

Excel conditional formatting help

Hello, Really need some help with an Excel problem. I have to try and change the cell background colour under certain conditions. I've tried con...

Split worksheet

Solved

Hello, Is it possible to Split one worksheet to different workbooks( files). I am having a statement to be send to 10 branch offices. sample...

Macro to check the last 7 values against mean

Hello, I am looking for help writing a macro to check the values of my last set of 7 results against a mean of the last 30 points. -Say I have ...

Partial match multi-sheet comparison

Solved

Hello, I am trying to compare a manufacture's part number in a spread sheet with a spreadsheet that we have to match these part numbers to their U...

Excel vba macro coding/ data look up

Hello, I have a single workbook with multiple sheets. one of my sheets contains a list of information (ie date,name,owner,description, and a cate...

Ms excel 2007 won't read in 2003

Closed

Hello, I have a excel 2003 file. My application is excel 2007. When I save the file as .xls, I lost all the format. So, I save the file as .xlsm...

Copy columns

Hello, i need to copy column values from 1 worksheet into another if the em id is the same in the two worksheets... that means worksheet 1 has empi...

I want to delete rows except certain values

Hi any one plzzzzzzz help me, this sheet has 5 columns column A COLUMN B COLUMN C COLUMN D COLUMN E row 1 --- vegetable,...

Copy non adj. cells from two sheets into one

Hello, On two occasions in the past this community has been of incalculable help to me, and I was wondering if there might be one more assist th...

404 error in mozila firefox browser

Closed

Hello, I want to connect oracle10g throw JSP code.I already implement registration page but after inserting some value when I click submission bu...

Retrieve a range chart through macro

Hello, I am trying to add a new series in a graph through macro. Range of the new series is similar to the other series already plotted in the ...

Search for a values in 2 sheets using macro

Hi, I have Response XMl Schema from 2 different environment of an application in sheet1 and sheet2 on the msexcel . I have a collection of xml ta...

Inserting/copy rows, transpose vba help

Solved

Hello, I have searched through many posts and it appeard everyone is very helpful. My skills in vba are ok but i lack the knowledge to solve my prob...

Conditional copying into different worksheets

Hello, i have excel 2003. what i am trying to do is set up a complaint sheet for 4 different people. In total there are 5 sheets (Main, Al, Bri...

Excel formula needed to look up and copy data

Hi, I have a list of aged debtors that is updated weekly, Im looking for a formula that will search the previous list via the invoice date and if ...

Merge rows if it meets criteria in excel

Solved

Hello, I would like to know if I can merge rows if it meets certain criteria in Excel. If Project ID on column A is matched, it will merge all the ...

Excel 2007 is not working properly

Hello, We are using office 2007. My problem is, we are type 2400 or other number in my excel sheet. It hides the last to digit. It show only 24 .We ...

Help with excel macro

Hello, Hi. I am not a programmer and have not used Visual Basic before so that's probably my first problem (!) but I am trying to debug a macro in...

Pulling ordered parts from sheet 2 and insert

Hello, What I'm attempting to do is create a master list of items ordered and what they are ordered for. Sheet 1 is a list of tasks generated b...

Import data into excel

Hi, I have 2 excel sheets namely A.XLS and B.XLS. I would like to import the data from A to B by running a command button in spread sheet B. Can an...

Conditionally deleting rows in excel 2007

Solved

Hello, I'm hoping someone here might be able to help me with this. I have a spreadsheet where column A is a project name then columns B, C and D a...

Excel data updation

Hello, Configuration: Windows XP / Internet Explorer 8.0 I have date in an excel spreadsheet that gets updated automatically every minute. ...

Need help in saving file which macro download

Hello, I have a macro which login to one of my site and download a file based on the no what the macro picks up from the excel file. While doing...

Webpage to excel

Solved

Hello, Could you please help me in downloading data's from a web page to an excel. If that web page has multiple pages ( 1,2,3,4.... ), i want all ...

Macro to copy certain data

Hello, I regret to say that I missed using hello and other polite words in my earlier post. I do respect the people behind the forum. I know that ...

Copy an excel worksheet multiple times

Hello, I have an excel worksheet, which I want to make 38 copies of, and rename each copy with the initials of the person to whom it belongs. The ...

How can i compare two excel sheets using vba

Hello, I am having two text files ( which is a comma separated file).The template of the two file is given below. SD,CurrentDate,RecordCount ...

Linking excel sheets and getting 0's all over

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

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

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

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

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

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

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

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

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

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

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

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

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...

Subscribe To Our Newsletter!