The discussions
Printing excel sheet with jumbled columns
SolvedHello, Dear all, I have a typical question. I have a work sheet in excel 2007 with some headers in columns from C8 to N8 the columns C to F have t...
Excel/vba 2010 - searching for wild cards
Hello, I'm wondering if it is possible to write a code that will search for wild cards. For example: we have a pattern of numbers that come up in ...
Variable sharepoint link into excel
ClosedHello, Configuration: Windows XP / Internet Explorer 7.0 Looking to allow a cell value to dictate a link to a spreadsheet in Sharepoint. S...
Vba macro matrix multiplication with a scalar
ClosedHello, I've been struggling with what should be a simple operation using Excel VBA and was hoping someone could please help me out. Basically I hav...
Please help with user form in excel.
Hello, Hello, I'm getting stumped and just need someone to help out. I know I am over looking something simple but can't figure it out. My user ...
Excel office2007 macro
SolvedHello, I writting a macro to clean up the format of a report down loaded into excel. I'm stuff on on section. I have filter column A for blank cell...
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...
