The discussions
Vba excel help colour a cell that contains 0
Hi, I have a table that displays data from another tab using VLOOKUP, although i have some cells that contain a 0 I have tried using conditiona...
Create workbooks from a list
Hi I'm totally unfamiliar with Marco's, so I hope someone can help. I need to create 200 excel sheets from a template and save them with the name ...
Comparing 2 worksheets in excel
Hello, I wanted to compare 2 worksheet. If there is a different it return the as below Sheet 1: Apple vs Sheet2:Orange and if no different ...
How to find the microsoft product key?
ClosedHello, i download microsoft but how can i enter product key System Configuration: Windows / Chrome 68.0.3440.84
Automatically setting a due date using ms access
Hi, I am looking to set a field to automatically set a due date based on a frequency (1-9), period (d, ww, m, yyyy) and date recorded. To this end...
Days from date and stopping counting issue
Hello, I am trying to create a new tracking sheet, and it focuses around this forumula I can't seem to find out how to fix. The formula I'm workin...
Making my macro independent on future sheets
SolvedHello All; 1st time posting anything so please bear with me. I really need some help and have going out of my mind for days with what I believe is...
Outlook syncing/sharing.
SolvedHi All, Do we have any Outlook gurus here? Something I've never had to do before, and dont know how to start - even google searches arent helpful a...
Making formulas work, which work on other computer
SolvedHello, My boss is using a large spreadsheet with multiply formulas in and has been using it for quite a while, updating the figures as and when ne...
Help creating a macro
Hi, I am trying to create a Macro to copy paste the particular range of row in the same sheet based on the cell value in the previous sheet Sce...
Removing a 'false' result
SolvedHello, In the following formula, I am getting a 'FALSE' as opposed to a '0' result. =IF((F28+F31)
Vba: create sheets from list
Hello, suppose i have value in column A from 1 to 10 then i want to create a sheet from 1 to 10 using macro System Configuration: Windows / C...
Microsoft office product key
ClosedHello, I downloaded your microsoft office 2010, when i tried to install it is asked for a product key. where do I get that ????
Vba code - conditional formatting
Hello, in VBA, I want to do conditional formatting of cells in a column with below background & font colours. Below 25: (RED Background-RGB-255...
Use a checkbox to copy a row and paste at end
Hi, Relatively new to VBA so please bear with me. I am looking to add a checkbox button that when clicked will replicate the row of data at th...
How to download open office?
can you please help me download the open office
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...
