The discussions
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 ???
SolvedHello, 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
SolvedHello, 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
SolvedHello, 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
SolvedHello, 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
ClosedHello, 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
ClosedHello, 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
SolvedHello, 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
SolvedHello, 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
SolvedHello, 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
SolvedHello, 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.
SolvedHello, 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.
SolvedHello, 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
SolvedHello, 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
ClosedHello, 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
ClosedHello, 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
SolvedHello, 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
ClosedHello, 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...