The discussions

Making my macro independent on future sheets

 Solved

Hello 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...

7 replies Last reply on 2 Aug 2018 by
vcoolio

Outlook syncing/sharing.

 Solved

Hi 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...

15 replies Last reply on 29 Jul 2018 by
Ambucias

Making formulas work, which work on other computer

 Solved

Hello, 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...

3 replies Last reply on 25 Jul 2018 by
ac3mark

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...

1 reply Last reply on 24 Jul 2018 by
ac3mark

Removing a 'false' result

 Solved

Hello, In the following formula, I am getting a 'FALSE' as opposed to a '0' result. =IF((F28+F31)

2 replies Last reply on 24 Jul 2018 by
Andrew

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...

2 replies Last reply on 24 Jul 2018 by
TrowaD

Microsoft office product key

 Closed

Hello, I downloaded your microsoft office 2010, when i tried to install it is asked for a product key. where do I get that ????

1 reply Last reply on 20 Jul 2018 by
ac3mark

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...

2 replies Last reply on 19 Jul 2018 by
TrowaD

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...

3 replies Last reply on 17 Jul 2018 by
ac3mark

How to download open office?

can you please help me download the open office

1 reply Last reply on 17 Jul 2018 by
xpcman

Multiple if statements in excel

 Solved

Hello, 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...

2 replies Last reply on 17 Jul 2018 by
Nesto2008

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...

3 replies Last reply on 16 Jul 2018 by
Zohaib R

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...

1 reply Last reply on 16 Jul 2018 by
TrowaD

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...

2 replies Last reply on 15 Jul 2018 by
vcoolio

Microsoft office 2010

 Closed

HOW CAN GET KEY PRODUCT FOR MICROSOFT OFFICE 2010

2 replies Last reply on 13 Jul 2018 by
ac3mark

Highlighting future dates

 Solved

Hi 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...

4 replies Last reply on 13 Jul 2018 by
Hoffy

Copy rows to other sheets based on value in column

 Solved

Hello, 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...

2 replies Last reply on 13 Jul 2018 by
Need_2Know

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...

1 reply Last reply on 12 Jul 2018 by
TrowaD

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...

8 replies Last reply on 10 Jul 2018 by
TrowaD

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

2 replies Last reply on 10 Jul 2018 by
TrowaD

Make userform

 Solved/Closed

Hello, 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...

1 reply Last reply on 9 Jul 2018 by
ac3mark

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...

1 reply Last reply on 8 Jul 2018 by
Ambucias

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...

1 reply Last reply on 8 Jul 2018 by
Ambucias

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 ...

3 replies Last reply on 8 Jul 2018 by
ProWHP

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...

9 replies Last reply on 7 Jul 2018 by
Nvcworld

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...

1 reply Last reply on 6 Jul 2018 by
ac3mark

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...

3 replies Last reply on 5 Jul 2018 by
TrowaD

Vba code for copy & paste items for multiple times

 Solved

Hi, 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...

4 replies Last reply on 3 Jul 2018 by
andrewhu91

Create sheets for additions to list on sheet one.

 Solved

I 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...

9 replies Last reply on 2 Jul 2018 by
TrowaD

Overwriting data during transfer

 Solved

Sir, 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...

3 replies Last reply on 2 Jul 2018 by
MUKUL_1308

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...

1 reply Last reply on 30 Jun 2018 by
Ambucias

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...

8 replies Last reply on 28 Jun 2018 by
Brande74

How to find the total tax?

 Closed

The excel sheet below, shows different Items that are either purchased and paid up front, not paid or purchased through layby from AGRIQUIP. If Column...

1 reply Last reply on 27 Jun 2018 by
ac3mark

Open office product key

Hello, i have download free office, i need product key. System Configuration: Windows / Chrome 67.0.3396.87

1 reply Last reply on 27 Jun 2018 by
Ambucias

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 ...

2 replies Last reply on 26 Jun 2018 by
TrowaD

Comparing two columns in excel

Hello, I have to compare the following 4 columns; Code Amount Code Amount 100 213 101 25 101 465 ...

2 replies Last reply on 26 Jun 2018 by
TrowaD

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'...

1 reply Last reply on 26 Jun 2018 by
TrowaD

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...

1 reply Last reply on 21 Jun 2018 by
vcoolio

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....

2 replies Last reply on 20 Jun 2018 by
LazyDave

Vba code for command button

 Solved/Closed

hello 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...

4 replies Last reply on 20 Jun 2018 by
MUKUL_1308

Auto scroll in phone

how to auto-scroll pdf files in android phone? please suggest the method or the relevant software.

1 reply Last reply on 20 Jun 2018 by
ac3mark

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...

1 reply Last reply on 19 Jun 2018 by
ac3mark

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...

1 reply Last reply on 15 Jun 2018 by
ac3mark

Looking for vba code.

 Closed

HELLO EVERYONE, I HAD CREATED A MACRO ENABLED WORKBOOK (ABC123.XLSM)WHICH HOLDS ABOUT 10 USERFORMS AND EVERY USERFORM COMPLIES DATA TO SEPERATE WO...

1 reply Last reply on 15 Jun 2018 by
Ambucias

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...

1 reply Last reply on 15 Jun 2018 by
Ambucias

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,

1 reply Last reply on 14 Jun 2018 by
ac3mark

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...

11 replies Last reply on 14 Jun 2018 by
ac3mark

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...

1 reply Last reply on 12 Jun 2018 by
ac3mark

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...

3 replies Last reply on 12 Jun 2018 by
ac3mark

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...

1 reply Last reply on 11 Jun 2018 by
ac3mark
Results 651 - 700 out of a total of 12,258