Excel Forum
-
convert numeric date into words [Closed]
hi want to know how to convert date into words(english) in excel 2003 or 2007 for eg. 22.04.2010 - convert it into Twenty Two April 2010 or Twenty Tw...
-
Macro in Excel to copy and paste selected from one Sheet [Closed]
Hi I have an excel with couple of sheets. 1st sheet contains summarized data. Now I want to scatter the summarized data and copy the same data in t...
-
EDATE if then scenario [Closed]
I have a date column of original date of action. I have another column that has a formula to give me 6 months from that date (which is when additiona...
-
insert one new copy row [Closed]
i need help pleas :) i want to insert one new row every time Verifies the condition and also copy some cells from last row like if(y3="y",...
-
automatically insert the current date into one cell when "x" is [Closed]
I'm trying to create and IF formula. What I want it to do it automatically insert the current date into one cell when "x" is typed into a different ce...
-
To get a price from price list while making a purchase order [Closed]
Hi,I would like to know how to create a macro code I have two files one named Price list and other Purchase Order. Actually I wanted like this ,the pr...
-
Grading on excel [Closed]
i need some help to grade marks from a b c d e on excel 2010
-
Creating automated Attendance [Closed]
Herewith enclosed Attendance sheet which I am trying to figure out. Here are my few queries as of now: 1. Firstly I want to put restriction on RH (...
-
Use Conditional Formatting To Copy Entire Rows [Closed]
Hello, My name is Brandon I'm new to the forum and am thrilled to have found a community that specializes in excel. The current issue I'm having i...
-
To get a price from the price list while making a purchase order [Closed]
Hi,I would like to know how to reate a macro code I have two files one named Price list and other Purchase Order. Actually I wanted like this ,the pri...
-
Pivot Table Setup [Closed]
I need some simple pivot table help to get me past a stumbling point. The database I am working off of has the following columns. A: INVDATE B...
-
page set up [Closed]
Hi.. In Excel , I need to have at last paper from the sheet a different ( first row ) not matching the (repeated rows at the top of each paper from...
-
Macro to copy specific data from multi sheets based on criteria [Closed]
Hi, I am trying to copy specific cells from different sheets to master sheet under the following criteria: * Master sheet should be generated when...
-
Bold Text [Solved/Closed]
Hello Sir, I required the macro to bold some specific text in cell like: Below mentioned formula is written in cell ="We are enclosing herew...
-
Broken brain! Can you help? [Closed]
Hi guys, As a relative newbie to excel I've been trying to solve a referencing problem for days and I'd be hugely grateful to anyone who can solve ...
-
Auto-copy rows based on their values to a new sheet [Closed]
Hello, This is my first time in a forum like this but I have already browsed through a lot of sites regarding how to do this. I have been using ...
-
Finding duplicate value and display the duplicate cell address [Closed]
Hi, I'm a new member. I've data of different roads with their distance data in multiple sheets ie., different sheets for different years. I want chec...
-
VBA CODE FOR Sub Total, 13% HST, G/Total, Adv Paid and Balance ? [Closed]
Hi Friends, I'm working on a VBA excel project and need help to write a Code, which can calculate the Amounts (as described Below) and Show on the Us...
-
Column namewise data copying from multiple sheets and work books [Closed]
Dear Friends I need to copy data from mutiple sheets and work books according to column heading wise. In my master Excel sheet, I have 48 Column...
-
need vba Code to Transfer Data from Sheet3 to Row1 of Sheet2? [Solved/Closed]
Hi dears, I need a VBA Code which can transfer the LAST ROW's (ie 15 or 29 or may be any other) Data of Sheet 3 to ROW 2 of Sheet 2 . Reason to Trans...
-
excel program [Closed]
Hello, im eve, im just want to ask if how can i make a formula which column D automatic less when column C change. then after all the value of col...
-
preguntas en excel en computacion [Closed]
digame cual la funcion que de daba la fecha y hora en excel
-
Want to create macro...help required [Closed]
Dear All, I have two sheet one containing first sheet containig below columns 1)customer name 2)customer type 3)customer tel no. 4)customer res...
-
Copy & Paste in Excel using macros [Closed]
Dear Friends, I have a interesting query about the heading. I have a master excel file, in which I want to copy the content of the another Excel f...
-
Copying rows from one master to sheet to different worksheets [Closed]
I have a group of 16 people. I am trying to take a large spreadsheet, 30 columns and eventually several hundred rows and trying to automatically copy...
-
Excel - can I return a date from 2 values in different columns? [Closed]
Hi everyone, I have a spreadsheet which uses weeks (1,2,3 & 4) and days (M,T,W,T,F,S,S or 1,2,3,4,5,6,7 doesnt matter which). Can I use a look up t...
-
Excel Clarrifications... [Closed]
Hi, i need to convert the values into currence words, and i got the module codes, once i pasted those codes the spellindian function is working prope...
-
Split data into several rows of same data [Solved/Closed]
Hello, I would like to split a row of data into several rows of same data in MS Excel. For example, I have an item with standard packing size of 100p...
-
I want to run macro and [Closed]
Dear All, On daily basis i am gunning some barcode in sheet1 i also have one master excel sheet where all barcode and schedule number available and...
-
warning to come up if today surpasses a certain date [Closed]
Any ideas what is wrong with this formula? I want the warning to come up if today surpasses a certain date. It is to warn me of when permits need to b...
-
I need to know how to split a excel file in to sheets [Closed]
Hi, I would like to know how to split the excel fille in to diffrent sheets based on a criteria. My criteria is , I have Headings A to Z. and ...
-
How to count number of cells dated this week? or next week? [Solved/Closed]
I've got lots of cells with dates. I want to know how many are THIS WEEK and NEXT WEEK. I'm not sure how to do it... Help would be appreciated...
-
Merging information [Closed]
I am taking inventory by sku number and have downloaded info from scanners and now I have it in excel and my original database is excel and I want to ...
-
create a macro to move address line from 3 rows to 1 single row [Closed]
I created a macro moving address data as follows to a single row: Select C1 move to B1 Select C2 move to C1 Select C3 move to D1 Select I3 move to...
-
Create Excel Condition involving Name of Day [Closed]
How to create a formula, if the value falls on say Saturday, the value must step back for a day say Friday??? Our inspection date should fall on wo...
-
Transfer data to a Report [Closed]
Hey Guys, So my dilemma is I have (2) separate workbooks. Workbook (1) has A1 with all basic data...name, address, phone #, etc. going down to A32....
-
how to filter date-wise highest value [Closed]
i have a data with two columns. first column is date and second column is amount in first column same date will be repeated for more number of ti...
-
Split data in excel to multiple sheets [Closed]
Hello, Need help to write a macro to segregate data in one sheet to multiple sheets. I have posted a sample data below: Name Emp ID Org. Addres...
-
Date counting with user inputs [Solved/Closed]
Hello, I'm looking for a date counting formula between two dates, where the user defines the total number of days, and Excel will tell them which ...
-
Excel Macro [Closed]
Hello All, I am trying to create a macro with formula. I need help in there. I have to get a formula for a column for more than one sheet. The formu...
-
set up a macro for quarterly reports I produce [Closed]
Hi, I was wondering if someone could help me... please! I would like to set up a macro for quarterly reports I produce. I would normally downloa...
-
Setup Userforms assetmanaging [Closed]
I have the following issue, am totally unfamiliar with UserForms, but need help with next. I have an excel file which works well, now I have some ...
-
Create file xls based on colums & populate data with criteria [Solved/Closed]
Hi, I need a macro that create some new file (txt or xls it doesen't matter) starting from an existing xls. The existing xls named "Arretrati" h...
-
Using DATE and IF [Closed]
=IF(B3="",09-01-2014,)*DATE(YEAR(B3)+G3,MONTH(B3),DAY(B3)) This is my failed furmula. I am trying to write a formula that will take the date in B3...
-
Macro: Cut/Paste Entire Row Into New Sheet Based On Cell Value [Closed]
Hi there, I'm struggling to create a working macro that finds a specific value in a column and then, only if the condition that the cell's value eq...
-
Macro: Add one month to all the cells with date data in workbook [Closed]
Hello, Need help in a macro that will add one month to all the cells that contains date data like 2/3/2014 will become 2/4/2014 Thank you. ...
-
Macro for comparing 2 sheets in excel and removing duplicates [Closed]
Hi, Kindly help me out with Macro for " Comparing 2 sheets in excel and removing duplicates in sheet 2 by replacing duplicates with blanks" so orde...
-
Combine,match and align 2 excel sheets. [Closed]
I want to combine two excel sheets. First excel sheet has patient ID (below 18 years) and their gender, age and race.Second one has patient ID (above...
-
Change value to an alternative value [Closed]
I am wanting the instructions to design a formula so that each time a value eg $90.00 appears in a cell that the system will automatically change the ...
-
Macro - Help please - Newbie on macros [Closed]
I am new at this macro stuff and I would like to learn more. A project I'm doing now is for staff assessment forms. I already have a working macro for...
Subscribe To Our Newsletter!
DON'T MISS
- How to Recover Your Yahoo Account
- How to Disabled Write Protection on a USB
- Facebook Code Not Received
- How to Get More Followers on Instagram
- Computer Boots to Black Screen
- How to Upload High Quality Photos to Instagram
- How to Install a VPN
- How to Get Free Diamonds in Free Fire
- How to Recover a Disabled Facebook Account
- How to Create a Gmail Account
- How to Fix a Blurry Snapchat Video