The discussions
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...
Master password
ClosedHello, Please give me na master password Configuration: iPhone / Chrome 34.0.1847.114
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...
Product key of ms publisher
SolvedI want to know the product key of Ms publisher downloaded from your website.
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 ...
Unable to send pdf via email function in adobe reader
Hello all, I encountered this error message "Either there is no default mail client or the current mail client cannot fulfill the messaging request...
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
Can you give me pdf-xchange viewer pro serial number?
ClosedHello, Can you give me PDF-XChange Viewer Pro serial number? I will be very appreciated. Mr. Chao Configuration: Windows 7 / Chrome 34.0.18...
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 ...
Conditional formatting of entire column
SolvedHello, I have two columns in excel 2010 which are generated by sensors measuring the same thing. In theory the 2 columns should be the same...of c...
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...
Microsoft office accounting 2008
ClosedJust become a member with Kioskea. I downloaded Microsoft Accounting 2008 from your website but need a product key. Can you help?
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"...
Inserting a row when the value of a field changes
SolvedI was using this code as a start but can't seem to mak it do exactly what I want. Sub InsertRows() Dim r As Long, mcol As String, i As Long '...
Format cell color based on date range
SolvedHi, this is my first post. I'm glad to be a member of this forum. Based on conditional formatting, how can I select a cell and have the backgroun...
Concatenate cells losing comma formatting
Hello, I am trying to concatenate multiple number values into 1 string text, but I am losing the Comma formatting. Here is an example of 3 valu...
Formating cells
i am trying to change the colour of a cell based on the value of two other cells in Excel 2010. for example if R1 is the same value as C6 how do...
