Excel Forum
-
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...
-
compare and sort random data between different sheets [Closed]
Hello, In one sheet I have 200 Names and their phone numbers ( in 2 columns) . In the 2nd sheet, I have 100 names ( those belong to original 2...
-
how to transpose every nth cell of column to nth row of other sh [Closed]
Hello Sir how to transpose every nth cell of column to nth row of other sheet. In my Case ,In Sheet 1 " CPP " 'LOI' Value come F4 ,F8 , F12 ,F16, ...
-
HOW TO RETURN DATE IN EXCEL [Closed]
Hi , pls give me answer for this question A B C D E F 1 GUE...
-
auto filling bill number and date [Solved/Closed]
hi i need a macro for my office use the condition is like this sheat one input ...
-
counting unique values in a given dataset [Closed]
I am using Excel 2007. I have to track the number of visitors to various farmers markets by zip codes on a given market day. I have all of the zip c...
-
Excel facing a problem with automation [Closed]
Hi everyone, I am currently facing a problem with automation of Ms. excel for my work and would highly appreciate any kind of help in this case. ...
-
Creating lists that are conditional on info in other cells [Closed]
Hi there, I'm new here so I'll try and explain as best I can. This is probably really easy but I can't quite find the correct formula to do it, I ass...
-
How to extract dates that a person is absent in a month? [Closed]
How do I extract the dates that a person is absent during the month and the dates extract to be in a single cell? Thanks!
-
Hide Rows Macro [Closed]
Dear Sir i have some Record in Sheet1 Parts Name Parts Used in Section parts Used Quantity if my parts used Quantity is 0 then Row will H...
-
Conditional Format [Closed]
Hello, Configuration: Windows XP / Chrome 34.0.1847.131 Hello, I am trying to set a conditional format using different columns and I can'...
-
Automate Data From Excel To The Website [Closed]
Hello, I have an Excel Sheet which contains 3 columns(Docket Number, Resolution, time), and 100 rows and I Just Need to paste in a website, I need...
-
Add one month to all the date... [Closed]
Hello, Sub Sample() Dim ws As Worksheet Dim lRow As Long, i As Long '~~> Change this to the relevant sheet Set ws = ThisWork...
-
How to insert multiple conditions in a formula? [Solved/Closed]
I have 2 cells, and I proceed like this with a formula and basically, if cell A2 meets a condition, then cell B4 shows the word "Good" =IF(A2>=100...
-
match the same no of data1 with data2 with respective qty and pr [Closed]
data2 data1 partno qty price partno qty price 0411175858 4 411.00 0437160070 5 89.50 0...
-
Excel - Shortcut key print preview [Solved/Closed]
Hello, What is the short cut in excel 2003 for print preview. Please give me solution. Configuration: Windows XP / Firefox 3.6
-
Multiple Results with simple criteria? [Closed]
Hello! Here's what Tab A looks like: Cap Type 220 N 3993SNB34 180 N 7113038KH34/32 220 N WS450BKXL 100 N ED303BK38/32 180 N 874OG36/32 ...
-
Insert word in cell based on value in another cell? [Solved/Closed]
CONDITIONAL FORMATTING for cell A2: if value in cell C3 is > than 500, then insert word "alert" in cell A2 what would the formula look like? I ...
-
Round UP Formula for TIME [Solved/Closed]
Hi All. I need an excel macro to populate a cell with a time slot based on the previous column which is a datetime value. e.g. if column A is 1-Apr-...
-
Formula for percentage calculation [Closed]
Needed a formula in A which will be then pulled down throughout the column. Wanted the result in A where B multiplied by C & D and deducting the val...
Subscribe To Our Newsletter!
DON'T MISS
- How to Upload High Quality Photos to Instagram
- How to Install a VPN
- How to Fix a Blurry Snapchat Video
- How to Create a Gmail Account
- How to Recover a Disabled Facebook Account
- How to Disabled Write Protection on a USB
- How to Recover Your Yahoo Account
- Computer Boots to Black Screen
- How to Get Free Diamonds in Free Fire
- Facebook Code Not Received
- How to Get More Followers on Instagram