Excel Forum
-
Cut/Copy in VBA Solved/Closed
Hello, 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 Closed
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! Closed
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 Closed
Hello, how to convert numeric to alphabet in excel ? Thanks Configuration: Windows XP / Opera 9.80
-
macros in my spreadsheet Closed
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 Closed
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 Closed
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 Solved/Closed
Hello, 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...
-
Tranferring of Excel Closed
Hello, I have two excelwork sheets For example A and B. Sheet1 of Workbook A consists of data and sheet1 of workbook B is empty. I want to transfe...
-
Leaving a Cell Blank if one value of the formula is blank Closed
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 Closed
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 Solved/Closed
Hello, 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 Closed
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...
-
Forluai Closed
Hello, I am using Microsoft office as well excel, I am not expert in excel. Could you give a favour for its formulas and their applying tricks and...
-
MS OFFICE EXCEL Closed
Hello, HOW DO I FIX A FORMULA TO CHECK THE FOLLOWING: IF YEAR "2012" AND MONTH "FEBRUARY" THEN NO. OF DAYS IS 29 OR ELSE 28. FOR JANUARY, ...
-
excel formulaes Solved/Closed
Hello, If there are two conditions, how to use the IF formulae. Regards
-
Help on generating a number series using a macro Solved/Closed
Hello, I would appreciate your help with a macro I am trying to create in Excel 2010 my Data is as below Column1 Column2 Column3 (Name) (start nu...
-
Hide rows meeting multiple criteria and search for unique values Closed
Hello, While hours reading posts and forums have increased my knowledge of VBA in which I can create parts of the following request I am still unab...
-
Conditional Formating a word within a sentence - Resent Closed
Greetings, I am trying to highlight a word in red or blue that is located with a sentence in excel. The word "Reversal" exist in several sentenc...
-
dynamic range and named ranges Solved/Closed
Hi, I have a list of students in Sheet 1,2,3 where being updated regularly. They are named ranges "Boys" & "Girls" in Column A & B respectively. In...
-
Excel 2003 Closed
Hello, Can you help me, I am trying to write a conditonal formula in Excel 2003 that goes something like: If current date is 6mths from date o...
-
complete payroll computation Closed
Hello, i would like to learn how to do payroll transactions. can you help me? thanks Configuration: Windows 7 / Chrome 23.0.1271.64
-
compare 2 cells in different worksheet and place the value Closed
Hello, I am not expert in excel, and i need help to use a formula to compare 2 cells in other worksheet and fill the value in a blank cell if it is t...
-
Delete certain data from Excel Closed
Hello, Im playing with big numbers of data in Excel. I want to do data cleansing process. How I want to delete certain rows that unnecessary anymore...
-
Excel Dates Closed
Hello, I have two excel sheets. In sheet one i have certain dates associated with certain IDs. In sheet two i have certain dates associa...
-
Calculate Sales Closed
Hello, I want to keep track of my sales.I have four columns.Below is excel data. Show only one day at a time. Date X Y Z 08-11-1...
-
Macro - Add row, auto fill text and formulas with relative OFFSS Closed
Hello, I have very big problem and I can't find answer for it. Maybe You can halp me. 1. In Sheet "Intro" I have row (5), in wich are formulas:...
-
compare dates in excel Closed
Hello, Hello, I have two excel sheets. In sheet one i have certain dates associated with certain IDs. In sheet two i have certain da...
-
If row in column contain word, insert text next column Closed
Hello, I have an excel files, and in column B I have a file path, but if it contains a specific word like "proprietary" I need to insert into the ...
-
multiple data in one column Closed
Hello, How do I plot multiple data in one column? Example: I submitted 10 for today. So my column chart will show a column with a value of 10...
-
multiple data in one stacked column Solved/Closed
Hello, i am trying to plot a column chart and I want multiple data to appear in one column. example: I am plotting all the submitted inspections...
-
Matching columns in one spreadsheet Closed
Hello, I have a spreadsheet that has last names in column A and first names in column B. Somehow they no longer match. For instance -Mary Smith...
-
formula 3 books open in excel Closed
I have 3 books open in excel (Book 1) I would like to make my template. (Book 2) is a spreadsheet of stores. (Book 3) is a spreadsheet of opera...
-
array example to remove duplicates entry Closed
Hi there, I have three column for lookup and i used combination of all there as a primary key to look into master sheet. want to remove the dupl...
-
macro to create new workbook for each column Closed
Hi All, I would like to ask for your very kind help to the below query. I have a big excel files say containing 100 + 1 extra columns. I wan...
-
Creating a Macro Closed
Hello, I am trying to remember how to create a macro that will allow me to compare values in column A from sheet 1 to column A on sheet2 and if th...
-
Matching similar data in 2 columns Closed
Can any super Excel guru help me please? I am trying to find out the same item from 2 different database: I have 2 columns of product code, for exa...
-
VBA for deleting data in row but not formulas Solved/Closed
Hello, I am working on a spreadsheet where I have to copy data over to a new sheet, once the data is copied I want to delete the data in the row f...
-
drag the mouse Closed
Hello, i could not drag the mouse. how to do drag the mouse to down, what are the settings ? Configuration: Windows XP / Firefox 16.0
-
Automation of running excel macros Solved/Closed
Hello, I have a macro in excel which needs to be run twice a day and I dont even want to open the excel sheet. How can I make this process automati...
-
Help in Writing VBA Macro excel Closed
Hello, I wish to write a macro for following: 1. Delete entire rows if column L or column M contain DATE. 2. Move deleted entire rows to other...
-
Comparing two cell in different spreadsheets Solved/Closed
Hello, I'm currently struggling to do the following: Spreadsheet A Sheet1 Name Expenses Date ...
-
Insert X Number of Rows Below Based on Value of X Closed
Hello, I have in Cell (B,3) a count indicating number of rows to be inserted below without deleting values in subsequent cells, in cell (B,4) anot...
-
search & copy function (macro) Closed
Hello, First of all, i will thank all who reads this question. And such a good forum. I have a question regarding a Macro. Basically i have...
-
Comparing Two Lists of ID Numbers in Excel Solved/Closed
Hello, thanks in advance for reading this. I have a list of student ID numbers which I would like to use as a student check-in. Column A is the num...
-
loops Closed
Hello, I have a spreadsheet that was converted from pdf, but the info is not in rows like a normal database. The headings are repeated throughout...
-
Update cell value by Command button Closed
Hello, I would be very grateful if someone can help me in the following issue. I have excel sheet with almost 300 rows. One of the columns I fil...
-
Reminder in MS Excel 2003 Closed
Hello, I would like to add reminder which displays reminder message once it opens. Onething I dont know the VB or something extra programming soft...
-
excel i want to sum only numeric values except alphabetic values Solved/Closed
Hello, in a school resultsheet where each student having numeric values of their marks in 5 subjects.i am using formula =D6+F6+H6+L6+P6 for total ...
-
change cell color based on input in a range of cells Solved/Closed
Hello everyone, I have formatted a cell based on a specific text entered in one cell. Example, A1 will turn green if I write "yes" on B2, using cond...