Hello, I'm trying to write a macro to help me with a repetitive task and running into some trouble. I have two sheets, setup like this - Sheet ...
Hello, I have a questions that i could not find the answer yet. I'm also new in macro VBA programming. The question is, I need to delete all rows...
Hello, I am currently having trouble arranging data that is exported from SAP. The report gives data like this, CC CCD P PD L LD B A ASN AD ...
Hello, I need to send confidential excel data to people but want them to only be able to view it.. They should not be able to download or print it.. ...
Hello, Could someone help me try and write a problem to count the number of files (i.e., word) on my C drive. Thank you
Hello, I have a couple of issue I hope you can help me with. I need to create a spreadsheet that will be linked to another spreadsheet. Can it be...
Hello, I have approx 4000 entries in column A listed as follows Robert & Sam Smith 12218 Country Hills Terrace Glen Allen, VA 23059 Michael ...
Hello Everyone! I hope you can help me with this... I have this in my data let's say on column A: John Doe 1234 Good St ATHERTON 94027 650...
Hello, Dear All , i need your help I have a huge excel database and i need to create a macro which will identify the rows that have been chan...
Hello, I need some support with creating a formula: This is what I want the Cell to look like "200810131234ABC123456789" Cell 1 contains 12...
Hello, I am trying to create a spreadsheet for employees schedule. I want it to be able to give me the total hours at the end of each week. It is a mo...
Hello, I have a spreadsheet with employee names and hours worked. Each employee has multiple lines with four columns. I want to have each employee ha...
Hello, i am currently using excel 2003 to try and set up a client feedback form, at the bottom i want to make a button that has the display letters...
Hello, I have a stock list. I can obtain the list and items that need replacement and ones that do not but I do not want to print out the whole list ...
I have huge data of branches in one file (14 sheets in to it for all data). From this data I have to prepare separate files for different branches. ...
Hello, I would like to run a macro to choose the maximum x value from 6 SETS OF numbers and the corresponding y value and continue the loop for EVE...
Hello, I am trying to make a Function in VBA. If I put the function in a Module in the Personal Macro Workbook I can't get it to show up on the ...
Hello, I work for a customer care ... I need to set a macro to delete customer information in the same file -- around 30,000 contact. I was thinki...
Hello, I use an excel spreadsheet for bookkeeping purposes for a single person corporation. I want to total amounts across each row. In other words t...
Hello, On sheet4 i have lots of data in columns. And i'm interested in two of them: col. i and col. k. In column i i have code (12-13 char). An...
Copy cells onto another file, depending on the information to the left of the cell I need to copy.. Hi Everyone!! I have 2 files (workshee...
Hello, How to replace one sheet with another sheet in different file, so that no link in the existing file become changed
Hello Everybody, I want to name range single cell by the value of the active cell, may i know how to do it??? For example, in cell A1 I've valu...
Hello, Just had a company create a website for me. Am supposed to be able to edit website but the company is telling me my web browser is outdated...
Hello, This is giri i have excel 2003 problemb when i open 1 excel document its opening 17 excle different documents these all are saved documents no...
Hello, I have an Excel worksheet with data in columns that I would like to move to rows. The data is in A1:AN1 - I would like to make it shwo in th...
Hello, I'm trying to write a macro in excel which would copy and paste a range from WITHIN THE SAME ROW in the same sheet as the active cell is sel...
Hello, My name is Chase and I am facing a really serious problem with Flash Player. I have tried to install it on my computer (I am currently using W...
Hello, how to equal the two excel sheets column fiends with using macro for Ex:my excelsheet1 had "date" column and my excelsheet2 had "date...
Hello, Im am running excel 2007 on vista. I need help figuring out how to create a macro that will take a series of data in a single column and trans...
Hey there, I have an excel query which goes like this. I have 2 excel workbooks First Excel workbook is called as Campaign Tracking sheet (for ea...
Hello, I have been trying to create a table of contents in Excel, by using a macro. It doesn't work, then I tried using a non VBA on the first sh...
Hi I am wondering if somone could help me with some macros in excell 2003. They should be pretty basic, so any help would be great. I have a colum ...
Hello, Last time while shutting down my computer at the office I forgot completely to save all my work in excel and now im just asking if I cou...
Hello, I need some helping creating a macro that will copy a column of data from one sheet and transpose it onto a row in another sheet. Thats the ...
I've got a worksheet and cell A1 to A100 consist of a drop down list which was created using data validation. When the user selects a value from ...
Hello, In all Office programs the same thing; selecting "Save as" and if the target directory needs to be browsed behind a long path, it takes minu...
Hello, I need a macro that will go down column A and recognize the words "Defendant Address:" and then copy then transpose the info after it and the ...
Hello, I am trying to use excel to work out a statement for me as follows I want a rolling average percentage based on the current month I n...
Hello, I want to put one formula or function or button in a cell that whatever no. I put in cell the same no. of rows containing some particular data...
Hi guys, I've created a log where users enter a code (column A), and this looks up various data from other sources (giving #N/A where no data is av...
Hello, I have an excel issue for BW. Presently we are extracting data from 8 excel files (for example 24 fields from all 8 files) to BW, i.e we e...
Hello, while browsing a file, my pc doesnot show my local drive e: solution for this
Hi guys, I have a excel document with several If statements. Everything I have figured out so far. But now I am sitting with a problem. The 1 sh...
Hello, I am try to get a macro to let me do: Input a number in cell c1 and have that number appear in a1 then the macro will delete the number in ...
Hello, im trying to do a vlookup and am stuck on how to. i need the correct meal price to apper once the meal no. and meal type have been placed in,...
Hello, I have a excel sheet that is really tricky. This is a bit a my problem. Lets say it's a test. I have a Total Amount Scored column a...
Hello, well actually my web browser is extremly slow any idea of what can i do to optimize the speed please?
Hello, Hello, H have different files named 110.xlc...1980.xlc...1020... and the final file there is a column in it . the value of it select as name ...
Hello, I recorded a macro that when run, will perform a web query and extract daily prices for a particular commodity. Now, I need to copy these pr...
DON'T MISS