The discussions
Multiple if statements in excel
SolvedHello, I am trying to calculate a cell based on values , so if A1 =between 1 to 10 than it will equal 10.00 if A1 = between 11 to 20 that it e...
Excel compare and return result
Hello, I have a set of field to compare in 2 different spreadsheet out of which any match will then check and return for a specific value in anoth...
Searching two columns and displaying a third
Hello, Hello everyone...quick question...I need a formula to search data from two columns and find the single row which matches the specified criter...
Copy certain number of rows using vba
Hello, Hello I am trying to copy a certain number of rows from sheet 1 to sheet 2 this number is dependent on a value i have set in sheet 3 A1. T...
Highlighting future dates
SolvedHi I have been tasked with building an excel spreadsheet for all staff training. I have managed to highlight cells where the date has expired, but...
Copy rows to other sheets based on value in column
SolvedHello, I have worked through this topic and the have modified the code for my worksheet, but I am having a problem with the F5 function. It works...
If several dates are entered a yes is entered
Hello, I'm trying to figure out how to do this in Excel. I'm trying to come up with a formula to say if several dates are entered into cells it'll...
Copying time fields down
Hello, I am attempting to put the time starting at 12:32:44 AM for 128 rows and click up the time by one second to 12:32:45 AM for the next 128 rows...
How to change date format in excel?
Hello, Sir I want change date format in 25-06-2018 to 25th June 2018 How can change 25 in Th letter in upper case Please tell me any one
Make userform
Solved/ClosedHello, I need to make a userform and list all sheet names and for each sheet name i need all named ranges from book. Is that possible? Thanks in ad...
How to download the free download ms office 2010
dear friend, i try to download free ms office2010. but suddenly stop and i recieve message failed. i presently using ms office 2007. can i get a...
What is in office 365
dear friends, Supposedly, I purchase a office 365, what equivalent the software i can get there like for example msexcel, mswords, ms outlook etch...
Copy cells to separate workbook using vba
Hello, I am attempting to take a range of data, in this case A1:I42, and copy it to a separate workbook. So I want to copy A1:I42 from Sheet 1 in ...
Find in column and copy it's row code for google s
Hello, I have created code in MS Excel for finding particular text in column and after finding text the entire row should be copy and add in next sh...
Vba code for create a copy of one excel file
Hello, I want a VBA code for create a copy of one excel file that contains all the contents without macros and also I want to send that work...
Copy command button in message box
Hello, I want to create copy command button through message box in VBA. In message box the information which is going to reflect should be copie...
Vba code for copy & paste items for multiple times
SolvedHi, I'm a very beginner in VBA and would need this problem solved urgently. I'd like to copy each line item and paste them in a new sheet 9 times. I t...
Create sheets for additions to list on sheet one.
SolvedI have a running list of names in a workbook that are kept in alphabetical order on sheet one. Those names are updated daily with new additions. Eac...
Overwriting data during transfer
SolvedSir, I had created vba code to transfer data from one workbook to another. it's working 1st time . but second time when I'm tapping the command butt...
Windows scrift hostalert message error
Title: Windows Scrift HostAlert Massege error Hello, I am SHAMSUL. I have a massege on my laptop screen as can not find file " C:\Users|BBC...
Date formula counting days
Hello, If anyone could help me, I would greatly appreciate it, I need help with counting days if there is not an end date on the report. Ex: Count...
How to find the total tax?
ClosedThe excel sheet below, shows different Items that are either purchased and paid up front, not paid or purchased through layby from AGRIQUIP. If Column...
Open office product key
Hello, i have download free office, i need product key. System Configuration: Windows / Chrome 67.0.3396.87
Change date format in excel
hi there i just need to make 1 cell for a date but with auto population of slashes so if i type 21062018 in the cell it comes up like 21/06/2018 ...
Comparing two columns in excel
Hello, I have to compare the following 4 columns; Code Amount Code Amount 100 213 101 25 101 465 ...
Numerical value to appear in d31 automatically
1) Hi there, I'm trying to do a formula in a cell and need some help please. For the sake of this example, I'll be typing certain text into C31 and I'...
Autopopulate info from master to individual ws
Hello, I have a series of data that are categorized by a prefix (P, UR, A, CAPA, etc.). I want to pull only the CAPA record information into a secon...
Populate cells in worksheets from an updating list
I have a club workbook with 150 member Worksheets that need to be populated from the members list. First Member is starting with A2 Second A3 etc....
Vba code for command button
Solved/Closedhello everyone, i had created a macro enabled workbook (abc123.xlsm)which holds about 10 user forms and every user form complies data to separate wo...
Auto scroll in phone
how to auto-scroll pdf files in android phone? please suggest the method or the relevant software.
Multiple text in a cell
Hi Please can someone help I have text in columns that uses multiple words example, annual leave, sick leave, maternity leave and i want to add...
Compiling data in excel
Hello, I am working with a large spreadsheet of contact information for people in my industry. I have columns titled with different interest areas...
Looking for vba code.
ClosedHELLO EVERYONE, I HAD CREATED A MACRO ENABLED WORKBOOK (ABC123.XLSM)WHICH HOLDS ABOUT 10 USERFORMS AND EVERY USERFORM COMPLIES DATA TO SEPERATE WO...
Ms office 2010 for mac
Hello, I need to download office2010 for Mac.Can you please help to get download linx System Configuration: Windows / Chrome 67.0.3396.8...
Need product key of ms office 2010
Hello, Kindly help me to avail the product key to use MS office 2010 System Configuration: Windows / Chrome 67.0.3396.87 Regards,
Access to word mail merge
Hi there, I am using MS Office 2016, I did a data base in Access for my team, such as Employee ID, Name, Mobile, ... and signature. when I expor...
Auto update of data from one sheet to other
Hello, Pls guide me regarding how to update data from one sheet to other in excel. In sheet1, if i update the details of the student it sho...
Creating excel email alert for expiring dates
Hello, all I want to do is to create a code that will send me an e-mail when one of my docs will be expiring or expired. The problem is that there...
Copying and looping data from one file to another
In one tab I have information, where I have made it output the information on a second tab (It's more in depth than this but I tried making this as si...
Not able to activate mobile pdf or albite reader
I want to have a PDF reader for my Java-enabled mobile phone (Samsung Metro B313E ). I have downloaded Mobile PDF and Albite Reader, both of which ...
Convert date to the english spelling
Hello, My date of birth 1-3-1995 Please convert to the English spelling System Configuration: Android / SamsungBrowser 2.0
Can i recover anything from a 0kb pst file?
ClosedIt's urgent. The Outlook data file which was absolutely fine yesterday has now turned into a 0KB file. This morning when I tried to open it, I rec...
Vba - how to repeat a set number of values x times
Hi, I am having an issue with a code I am writing. I want to insert 1,2,3,4 down an empty column X times ( where X will be inserted by the user)...
Mac vba & excel, auto change image based on a cell
Hello, I'm trying to produce a simple excel spreadsheet on my Macbook which automatically changes the image in cell B3 when I change the name in A...
Auto populate when changing from quoted to sold?
Hello, I am working on a work book in excel for work. On one page, I am tracking quoted / sold cases when a case sell, I have it change colors. ...
How do i install excel on my pc
how do i install excell on my pc
How can i separate each slides from one ppt file?
SolvedHi Everyone. I have a powerpoint file(Power point 2016) which has 100 page(slides). What I want is to automatically separate each slide to create ...
Microsoft 2010 product key
ClosedI downloaded free version of Microsoft office 2010 from your site its asking for a product key. Where do I get that from? Knemet