Excel Forum
-
Macro in Excel 2003 Closed
Hello, I have 2 tabs that contain a lot of data and I need to compare them both. One contains data that needs to be completed, and the other contain...
-
excel Closed
Hello, I need to match two coloums with date and values i am able to match the values correctly but not the dates.(excel 97) please help
-
excel formula Closed
Hello, i need some help, how can i combine 2 or more numbers separately,example in sheet1: cell a2 b2 5 98,76,54,3 if i choose sh...
-
Excel question again around dates Closed
Hello, I have an excel document with two sheets, sheet1 contains a list of product codes in column A and a date next to each in column B. Sheet2 is a...
-
Needed Macro for excel data migration to Proj Closed
Hello Ivan, i am ramesh. i have a excel file contains 2000+ tasks information. i need to write a macro, which reads data from excel and create task...
-
Help with macro to move text between sheets Closed
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 ...
-
Delete All Rows Except..... Closed
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...
-
Copying Data into Cells using a Reference Closed
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 ...
-
Deny excel workbook print and download Closed
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.. ...
-
VBA - Count the number of Word documents Closed
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
-
excel help needed Closed
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...
-
Excel Help Closed
Hello, I have approx 4000 entries in column A listed as follows Robert & Sam Smith 12218 Country Hills Terrace Glen Allen, VA 23059 Michael ...
-
Excel Macro Help Needed Closed
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...
-
Bring Rows of excel that have been changed Closed
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...
-
Three Cells Closed
Hello, I need some support with creating a formula: This is what I want the Cell to look like "200810131234ABC123456789" Cell 1 contains 12...
-
Excel spreadsheet Closed
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...
-
Help w Excel combining duplicate rows and add Closed
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...
-
excel 2003 assistance Closed
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...
-
Excel question Closed
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 ...
-
Macro help Closed
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. ...
-
Macro to choose the max x value and Closed
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...
-
Can't use 2 sheets with a custom function. Closed
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 ...
-
EXCEL Macro - Find and replace function -Help Closed
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...
-
sums of row cells Closed
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...
-
search engine macro Closed
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 Closed
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...
-
Replace one sheet with another Closed
Hello, How to replace one sheet with another sheet in different file, so that no link in the existing file become changed
-
Excel Named Range to single cell Closed
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...
-
web browser Closed
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...
-
ms excel 2003 problemb Closed
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...
-
Need help with simple Macro Solved/Closed
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...
-
Excel active cell macro Closed
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...
-
macromedia flash player Closed
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...
-
excel with macros Closed
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...
-
How do I create a macro that will... Closed
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...
-
Excel query Closed
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...
-
Creating Table of Contents in Excel Closed
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...
-
Macro help Closed
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 ...
-
Excel Sheets Closed
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...
-
A pretty basic excel macro question Closed
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 ...
-
Conditional formatting using macros Closed
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 ...
-
Office "Save as" & file browsing tak Closed
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...
-
Excel Macro Help: find, copy, transpose Closed
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 ...
-
EXCEL HELP Closed
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...
-
Inserting rows automatically Closed
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...
-
Macro Help in excel 03 Closed
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...
-
Extracting few cells frm 8 xl files into 1 XL Closed
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...
-
can't see my one single drive while browsing Closed
Hello, while browsing a file, my pc doesnot show my local drive e: solution for this
-
Excel macro help please Closed
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...
-
Excel Macros help Closed
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 ...