The discussions
Split data into several rows of same data
SolvedHello, 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
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
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
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?
SolvedI'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
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
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...
How to filter date-wise highest value
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
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
SolvedHello, 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
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
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
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
SolvedHi, 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
=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
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
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
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.
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
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
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
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 return date in excel
Hi , pls give me answer for this question A B C D E F 1 GUE...
Auto filling bill number and date
Solvedhi i need a macro for my office use the condition is like this sheat one input ...
Counting unique values in a given dataset
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
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
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?
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
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
Hello, Configuration: Windows XP / Chrome 34.0.1847.131 Hello, I am trying to set a conditional format using different columns and I can'...
Add one month to all the date...
ClosedHello, 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?
SolvedI 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...
Excel - shortcut key print preview
SolvedHello, 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?
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?
SolvedCONDITIONAL 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
SolvedHi 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
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...
Formula assistance
Excel..... I have a spreadsheet for shipping products. When I enter the amount shipped, I would like for that days date to appear in the next column...
The value of a name
SolvedHello, I've been playing a lot of dark souls 2, and I'm trying to make a spread sheet to have the value for armor (to start). I plan on making ...
Excel conditional formula
Here is my need. I have a visit date that I want to prepare for 3 weeks in advance. So if I have a date of 5/23/14 for the visit I want a cell to show...
How to find positions with repeated marks
Hello, Sir i have problem with finding positions of a class having equal marks can any body help me please. Configuration: Windows 7 / Interne...
Adding rows based on users selection
Hello, I want add rows with say Y1,Y2,Y3...Y10 based on what value the user selects from the drop down i.e. Say a user selects 5 then in the o...
Macro to copy worksheet based on criteria
I am fairly new to using macro's. I have 4 template worksheets and one input worksheet. Based on cell c4 in input worksheet I want to select either te...
How automate to search and move data from one excel to another
Dear Friends, I need a excel script to search columm A data from my lslpp-report and match the phrases in column A with the data from the lslpp raw...
Copy data from one work book to another
I am a beginner in excel so i need your help on this. The 2 work books in question are the links below. https://docs.google.com/spreadsheets...i...
Can the formula counta / count exclude 0 values?
SolvedIf I use COUNT or COUNTA, what can I include in the formula to exclude zero values? Thanks for any tips
Drop down list opens new window
I would like to create an excel that has a first sheet with drop down selections $2m >$5m >$7m Depending which is selected a different excel she...
Populate cells based on criteria...
Hello, A B C D E F ...
Transfer data into invoice
SolvedSo I've put hours and hours into this with no avail. Here's my situation...I have on "Sheet 1" a list of materials which could potentially be used dur...
If functions
Hello , I am able to create multiple if functions ( =IF(Site1!H2="y",Site1!G2,IF(Site1!H3 ="y",Site1!G3,IF(Site1!H4="Y", Site1!G4, IF(Site1!H5="y"...