The discussions
Macro to connect to paste all clipboard excel 2007
hello, I wish to make a macro that will paste All from the clipboard Excel 2007 ( do the same as the Paste All Clipboard button ) The cell is A1 sh...
How can i lock the column in excel
Hello, If I have a table or Excel sheet and I made a function in a cell A2 and drag this function to be coped in all column A and finally I wan...
Macro to sort clipboard paste all function
WINDOWS 7 EXCEL 2007 Hello, I would like to make a macro that would convert the data below to (See-Below) LIFETIME RECORD STARTS WINS 2NDS 3R...
Updating excel that has macros
Hello, How can you easily update an Excel workbook that already is using Macros? I need to insert two columns but once I do, I receive errors. T...
Vlookup ?
Hello, I have list of 1000 company names in col A and in col B 20,000 company names. I would like to know if the company in A appears anywhere in ...
Convert numbers to text format:
Hello, i got a problem in my data. there are many soluations already available for converting text format to number. But how can number format ca...
Formating date
SolvedHello, I have date in a cell now i want to see the next cell red color if the next cell is not filled up by the next 10 days from 1st cells date. ...
Help with comparing/deleting columns
Hello, I will be eternally grateful if anyone can help me with the following scenario. I have 4 columns Vendor_Name Vender_Code In...
Formulas
Hello, I ve forgotten some formulas used in excel. Please someone should with this formula used to set ranks eg, first, second, etc. Configur...
Cpoying data from one sheet to another
Hello, i have a excel file. in sheet on i have some data like sr no........name...........father's name.........roll no........ 1..............raj...
Match barcode between 2 sheets
Solved/ClosedHello, I have two diffrent sheets. One sheets has tens thausand lines with barcode value,description and quantity of product. another one has 2...
Excel multiple function
Hello, I need to put multiple functions into a one cell result in Excel. The result of one function (result A), squared (result B) and that numb...
I want to extract specific data from microsoft excell cell
Hello, i want to extract the following details into another collumn (bold ) from data in collumn B1 into C1. The information i want begins with 3 di...
How can i eliminate #value in calculated cells
SolvedHello, I am building an Excel calculation sheet for cookeries for christmas. In cell H$7 I have the input for how many times I would like to ...
Excel/toshiba problem
Hello, having a problem in Excel. my arrow keys seem to work spontaneously and are continuously scrolling me across the screen - makes it difficul...
How to find missing numbers in a seperate column from 2 columns
Hello, I have data in 2 columns (given below) and want to compare both the columns and want to get the missing numbers in seperate column. e.g ...
Convert currency (indian) into words
Hello, daer Sir, i need to convert currency (Indian) into words while working on my excell work sheet,as in Excell there is no farmula availab...
How you can get an atomatic serial number in a particular column
Hello, Suppose A1 is serial, B1 persons name, C1 amount due, D1 amount paid, E1 invoice number, F1 is invoice date and so on, that is A2, B2, C2........
Excel macro sort and data series
I'm looking for a macro that will accomplish 2 things: first I want to sort a range called "data" primary key is "com", secondary key is "cvt", next ...
Conditional formatting highlight entire row based on date
Hello, I'm trying to highlight an entire row in excel if the date in column B is later than today. Can you help? Please. Configuration: Window...
Help with a vba code
Hello, I'm trying to configure the DEL key to clear the contents and Unlocked the cell (if Locked). I create the module: Public Sub MyDelKey() ...
Look for values from a different sheet and return it
Hello, So I am working with a file that has 2 sheets. Sheet 1 has columns A,B,C,D Sheet 2 has Column. A B C D For both sheets, column A= ...
Macro help
Hello, I wrote the below macro but my problem is the number of rows change each month so i would like to have an autofill the formula from column ...
Copy range depending on a cell values
Hello, i am looking for a script that gives me the following : column A to D contains my data that I want to copy to another sheet, E/F contai...
Help with vba
SolvedHello, I'm trying to program a macro in Excell 2010. What I need it to do is look in a Range for the NotEmptyCells and change their property fro...
Copy data into next empty cell in new sheet
SolvedHello, I am trying to make a 2 sheet workbook which has the input details in Sheet1 A1 and this is changed weekly but the info in this cell shoul...
Copy rows a set number of times
Hello, I have a delivery manifest that shows the amount of products coming in, descriptions etc. that we use to produce barcode labels. Unfortunat...
Organizing data
Hello, This is not as clear as it could be but I will try. I have a spreadsheet that has two columns. The left column (A) is populated by 8-Digit ...
Excel vba/macro for keyword based search on listed urls.
Greetings respected team, Kindly advise if it is possible to create an Excel based VBA or Macro that helps search predefined keywords in predefined...
Macro to create sales report
Hello, i have a set of invoice] in excel formats in a folder. I need to generate a sales report for this. sales report should contain bill no, dat...
Worksheet columns added into one worksheet
Good Day! I need to take Column/Row: M18 from worksheets 05202011 thru 12302011 (example: sheet 14 thru sheet 46), add and enter in to blank/anothe...
Auto filter problem
SolvedHello, when i am filtering any item for adding value in that item, it will gets filter but the blank cell coming at last is much further behind th...
Recalculate formula when format changes
Hello, I have a VB module that sums cells with a specific color background. It works fine but I have to click on the cell with the formula to get...
Splitting list of names with formula - can you spot what's wrong
SolvedHi everyone, I have a list of 1805 names which are gathered in a single column. These names range in length and "format" (e.g. John Smith, John C ...
Vba query
Hello, I'm trying to program a macro in Excell 2007. I want to put up formular for multiplying various columns and dividing eg((A5*B5)+A5)/C5...
If function in excel
SolvedHello, my formula is =If(or(A5="016f7",A5="016b8",A5="017a3"),The monthly instalment is equivalent to...........,"") I want in place of ..........
Comparing two excel worksheets
Solved/ClosedHello, I am trying to find an easy way to compare and extract data from two excel worksheets. This is the scenario.. I have an excel worksheet ...
Help with populating multiple if functions
Hello, I'm working in an excel workbook with several sheets. I want information from the "Income" sheet to populate to the "Discounts" sheet whe...
Cut/copy in vba
SolvedHello, I am fairly new to Macros but I am trying to write vba code in Excel 2003 version that will enable me to cut/copy a table from one worksh...
Excel adding a price to data entered
Hello, here's my problem, I have a scanner which I scan my product with and it enters the product into a cell and I want excel to be able to recoginis...
Create a dbr - database reporting tool for a list of exceptions!
Hello, I am new to VB programming. I need your help to make a DBR - Data base Reporting tool for the back end process at work which could be als...
Convert
Hello, how to convert numeric to alphabet in excel ? Thanks Configuration: Windows XP / Opera 9.80
Macros in my spreadsheet
Hello, I managed to create a macro to show the following: If (I30,I3*G3,H3*G3) and this repeats itself for cell N3,R3, V3,Z3 ETC. I need this...
Automation
hello , i used to make a report on excel which exceed more than two hours every day i will mention the report in breif i have a big report whi...
Macro to move rows in excel automatically
Hello, I need to create a macro for Excel2010 that moves one to two rows of information to a preceding row and adds each row as a set of new colum...
Covnvert numbers to single words
SolvedHello, In excel 2010 i would like to convert numers to words i.e. 123.00 (one two three point zero zero) or 1006235.23 (one zero zero six two thre...
Leaving a cell blank if one value of the formula is blank
Hello, I was making a template to be distributed to multiple receivers. Since the template is blank and must automatically count the number of day...
Using multiple if functions with data validation
Hello, Im trying to create a pull down menu with data validation, however for example if M4 = VT-901 then I want to be able to select a size 1080,...
Compare and copy data from one column to another
SolvedHello, I'm trying to compare column A in Sheet 1 with column A in Sheet 2, then copy corresponding values in column N from sheet 1 to column N in ...
Excel mini challenge
Hi, I need to compare 2 versions of the same data which reside on 2 different worksheets (within the same workbook). On the first sheet (the...
