Excel Forum
-
Adding double quotes to excel [Closed]
Hello, How do I add double quotes the beginning and end of a column of numbers in Excel. Example 45671 needs to be "45671". Thanks. Config...
-
Autofilling formulas from multiple worksheets [Closed]
Hi guys. I am decent with excel, but I am trying to help a fellow employee out at the moment who has very little knowledge of excel. She is doing a ...
-
How to copy data using macros? [Closed]
Hello, I have a sheet which has data, Sheet 1 A B C D 1 2 3 4 1 2 3 4 -- -- -- -- Now ...
-
Sorting data into different worksheets-Excel [Closed]
Hello, Here is my issue. I'm using Excel 2003, and I have a worksheet going with a list of names in column A, and their job title in column B. Wh...
-
Macro to compare and delete rows [Solved/Closed]
Hello, I'm a new b when it comes to macros. I'm looking for the best way to compare data in 2 sheets. If data in column A matches on both sheets...
-
excel formula if statement with link [Closed]
Hi all, so if cell a1:a50 contain 5 digit product codes, and b1:b50 contain prices on a serperate sheet there will be a list off 100 product coes fr...
-
Excel duplicates [Closed]
Hello, I have Windows XP, Excel 2003, and 2007. I use large Pivot Tables, using Multiple Consolidation Ranges, which are bank statements from...
-
Won't delete my empty rows! [Closed]
Hello, After I used the filter on my spreadsheet that only contained 650 rows, suddenely there were 65,000! But they won't delete. I've tried clea...
-
Unprotecting a sheet [Closed]
Hello, Is there anyway to unprotect a spreadsheet without knowing the password ? Configuration: Windows XP / Internet Explorer 6.0
-
Sort by columns [Closed]
Hello, I have been trying to create a macro to sort some arrival hours, I have 9 columns, the data I want to sort is on columns D, H and L, do you...
-
Match columns and bring back a third column [Closed]
Hi excel gurus, I have a problem and I need some help to match information in two spreadsheets, I need to match the first two colomns in sheet1 ...
-
Excel VBA macro to make sheets [Closed]
Hello, I'm looking for a macro that makes a sheet in the Excel-workbook. I have a mastersheet with all the persons working in a company in a partic...
-
Need macro for following condition [Closed]
Hello, I need help on the following condition. ID Type Time 1 A 2 1 B 3 2 C 1.25 2 D 2 3 E ...
-
Excel Fomula [Closed]
Hello, Trying to get excel to return a number only if it is in a range of two other numbers: A B ...
-
COLOR CHANGE AND CONTINUAL TOTAL...EXCEL!!!! [Closed]
Hello, I am begging for help !!!! I will explain what I need and then hopefully you can help me. FIRST ISSUE: If Cell F9 = E9 do nothin...
-
Macro to send email from Vlookup cell value [Solved/Closed]
Hello, I am trying to create a macro that will among other things send an email to each address in a cell. The only problem is that the cell with ...
-
a formula for comparing values in two columns [Closed]
Hello, I want to compare values in two colums excel, if the value is in both columns to return a 0, if not to remain as it is. kindly help ...
-
HOW DO I CHANGE DATES AUTOMATICALLY IN EXCEL [Closed]
Hello, Any clever person out there. I am a frustrated administrator. I need to forward plan with dates. Basically I enter a Date of Birth i...
-
Excel: Selection of Cells in column Between 2 [Closed]
All, Selection of Cells in a column Between two Values I am preparing a Statistical Data Sheet, for this I need to select and copy data from one...
-
Email Function in Excel [Closed]
Hello, I have created a spreadsheet containing Clients, invoice numbers, Due date for payment, Date reminder has to be sent to the clients and fol...
-
Excel macro to name ranges [Closed]
Hello, I have a spreadsheet which contains many DSUM criteria, and I would like to name each of the ranges so I can refer to them by name rather than ...
-
Add up the values of duplicate cells [Solved/Closed]
Hello, I am trying to sort out a problem in excel file. I have some duplicate strings in column C and there are some integer values in ...
-
office(Excel) 2007 shortcut keys [Closed]
Hello, Sir this is vivek, can anyone provide me shortcut keys for excel 2007. wud b vry gr8fl thx...Vivek Configuration: Windows XP / Saf...
-
Excel - Macro copy Date for "n" month [Solved/Closed]
Hello, Would you please help me to create a macro for generate Date schedule to Sheet2 It just like an installment schedule. Sheet1 Col ...
-
Kindly Help me on Macros [Closed]
Hi All, Kindly provide me a Macro for find and replace for an X no of dots in to a single / Example: manoj..............Kumar Rajesh..........
-
mapping jpeg name to excel database [Closed]
Hello, I've got a folder with a number of jpeg pictures each named after employee names. i need to rename with full names (First Middle Last Name) ...
-
Macro-To Create 1 [.csv] using multiple excel [Closed]
Greetings, I have more than one Excel Workbooks containing multiple worksheets in each of them. It would be a great help if some one provide me ...
-
Excel 2007 VBA If then offset [Closed]
I have a sheet where the rows size varies and I am looking for code to lookup column F starting in row 3 to the bottom and if the cell has a "Q" then ...
-
Internet connected but cannot browse? [Closed]
Hello, well here's the background to my problem: I'm running xp sp3 on a dell inspiron 1300 and 4 years old, and yesterday it updated and ran a ...
-
Remove value of "0" from blank Excel cell [Closed]
Hello, I need to set conditional formatting so if the number 0 - 999 is typed in a cell, the cell fill will be yellow. If the cell is blank, I need...
-
Excel issue - how to return data from a list [Closed]
Hello, I'm using Excel 2007 and I simply can't do what I need to and can't find an answer anywhere! I have a large table of approx 500,000 ...
-
Macro for more than 3 conditional formats [Closed]
Hello, I recently used the attached link to circumvent the limitation of excel's conditional formating (i.e. 3 conditions) and used the macro to exten...
-
Excel every 25th row [Closed]
Hello, I have over 7,000 rows and I need to find every 25th one and don't want to hand count. Is there a way to sort or is there a formula to find ...
-
excel urgent [Closed]
hi. This is possiable? i have a, large amount of employee data .sometime some employee runaway,or after vacation not come back.in this case i want to...
-
insert multiple columns then copy data [Closed]
I want a macro to insert varying number of columns then copy the corresponding data original data: ColumnA ColumnB Col...
-
Excel - Copy rows "n" times with calculation [Solved/Closed]
I need to have a macro that will copy rows from sheet1 to sheet 2 . The catch is from sheet 1 col C for e.g. C2 may have the number 5 in it. I need to...
-
EXCEL [Solved/Closed]
hi i always make our employee salary in excel. this file is very big. every month I have to put only OVER TIME,WORKING DAY and ABSENT...and i make all...
-
Can a macro add a number? [Solved/Closed]
I am working on a excel project where I will be able to click a button and the result would be a number added on another cell. For example, counting a...
-
copy columns one below another [Solved/Closed]
Configuration: Windows XP / Internet Explorer 7.0 hi i have data in the following form a b c d 1 6 11 16 2 7 12 17 3 8 13 18 4 9 14 19 5 10 1...
-
Combining 2 cells to 1 [Solved/Closed]
Hi, I have data like below in two column of excel sheet: 1-Jan | 2004 23-Jul| 2004 12-Feb|2003 ................ ......... Out out require...
-
excel [Closed]
Example : I have column A' where i am entering a number and this number (given by the user) has to be multiplied by 10 and the value/answer should app...
-
help excel: click & automatically copy paste [Solved/Closed]
I need some help Let's say I have 5 different tabs named London, Paris,... Each tab contains different kind of information about the cities: popula...
-
Macro to allow users to modify? [Closed]
Can anyone please create a macro that will give access only to few users to allow modifying data in an excelsheet.
-
Sorting and Suming # in Excel [Closed]
Hello Everyone, I need your expertise in this. I want to do the following. In a list I input data consisting of Amounts, Expense Type, and Date...
-
To read records from excel file and the limit [Closed]
I am preparing the code to read the records from the excel worksheet and convert the .txt file of that worksheet.. If i run my program than a .txt fi...
-
Ignoring blank cells [Closed]
I have a formula along the lines of..... =IF((a1=b1),1,0) How can i get the formula to ignore blank cells? Configuration: Windows XP / Interne...
-
Excel Date and Time issue [Closed]
Hello All, I wanna subtract "12/05/10 08:29:25" from "12/05/10 08:48:31' . Please help me out. Thanks and Regards, Subramanyam T C, Bangalore.
-
Search and Replace macro for microsoft excel [Solved/Closed]
I have two workbooks with identical setup. item name address 1 address 2 address 3 x 12 34...
-
Excel Macro formula for groups of numbers [Closed]
I have strings of numbers in a column (n) I need help with a macro that will total the groups with the sum in column (o) right of the last row of the ...
-
Copying Specific Data Selection to new sheets [Closed]
How can I select entire rows based on a specific value found in a column via a macro when the occurence of the specific value is variable? eg. My ...
Subscribe To Our Newsletter!
