The discussions

Auto generate workwheet from a list and from a template workshee

 Solved

Hello All, At the moment, I found out how to auto generate worksheet from a list. However, the generated ones are blank worksheets. May I ask ho...

6 replies Last reply on 10 Nov 2016 by
TrowaD

Excel - a macro to rename existing worksheets based on a list

 Solved

I have a P.O. spreadsheet with a summary page. Every year we need to create a new file but I would like to create a template that would just renumber ...

4 replies Last reply on 10 Nov 2016 by
vcoolio

Can't open a word 2007 doc created in the same ms word 2007

Hello, I have created a file in ms word 2007 and when I immediately tried to open the file , it does not not open--But a message displayed like--t...

1 reply Last reply on 10 Nov 2016 by
Ambucias

Inserting a picture with path name in a variable

Hello Guys, I am getting an "Error 1004: unable to get insert property of Picture class" with the following code. Looking forward for your guidan...

1 reply Last reply on 9 Nov 2016 by
ac3mark

Can only use microsoft office 365 online

Hi Everyone, How come I can only use Office Online and sometimes. I have found it hard to open it up offline which is a nuisance sometimes. As I am...

1 reply Last reply on 9 Nov 2016 by
Ambucias

Inserting image in a particular cell in vba

 Solved

Hello All, I wanna insert an image into the Activecell but the image is getting inserted into the same default area. Kindly help me regarding this...

6 replies Last reply on 9 Nov 2016 by
AdiK

Outlook not sending email

Hello, I have this problem, my outlook 2007 works fine when connected to DSL/Wifi of one ISP. But when connected to other ISP mobile/3G EVO it rec...

1 reply Last reply on 9 Nov 2016 by
Ambucias

Merge cell

Hello, What if the compared cell is a merged cell. Example, comparing the values in column C with the merged cell values in Column A, expectin...

2 replies Last reply on 8 Nov 2016 by
iqbal

Exel formulas

 Closed

Hello, To find position class of the student in Mark card

1 reply Last reply on 8 Nov 2016 by
Ambucias

Autoploting (master to other sheets)

Hello, I have a master file for all the transactions in one financial year. This file currently has 4 sheets: EGC,SSM,RSL,MF. The first three are...

3 replies Last reply on 8 Nov 2016 by
TrowaD

Macro - new sheet per name list and add template in each sheet

Hi all, I'm a new comer here, but looking forwards to learning and helping others!. I am trying to create a macro that will: 1. create a new s...

2 replies Last reply on 8 Nov 2016 by
Richie

If statements with dates and criteria

 Solved

Hello, I needs assistance with "If "statements and criteria within the statement . Column A has a set of start dates Column B has a set of En...

3 replies Last reply on 8 Nov 2016 by
Mazzaropi

Help with excel formula

Hello, I am a beginner at Excel. Trying to figure out formula for: IF DATE in column A is greater than DATE in column B, highlight. Configur...

1 reply Last reply on 7 Nov 2016 by
ac3mark

If a cell has specific data, copy entire row to new worksheet

Hello everyone :) This is my first post and I'm really needing some assistance if at all possible! I am a school teacher, trying to create a spreads...

1 reply Last reply on 7 Nov 2016 by
ac3mark

Difficult lookup formula

Hello, I have a difficult question that may not have an answer. At least, I haven't found a formula that works. A ...

1 reply Last reply on 6 Nov 2016 by
yg_be

Clash of clash

Hesabimin sifresini istiyom

1 reply Last reply on 6 Nov 2016 by
Soykan Soylu

Change the font of the equation symbols

Is it possible to permanently change the font of the Equation Symbols? Mine are set at Cambria Math and I'd prefer Arial. Thank you

1 reply Last reply on 5 Nov 2016 by
Ambucias

Duplicate values in multiple columns

 Solved

Hello, I'm looking for a formula for a case mentioned below: Consider we have values in three columns I need to find a formula which compar...

2 replies Last reply on 5 Nov 2016 by
M3TM3T

Copy data of one sheet to other sheets

 Solved

Hello, I want a VBA code or excel formula that automatic copy of data from one sheet to another sheets(either sheet 2 or sheet 3...etc)..suppose In ...

25 replies Last reply on 5 Nov 2016 by
vcoolio

How to activate the button as activecell

Hello Guys, I would like to know if there is any way to make the cell in which the button is inserted as the ActiveCell when i click the button? ...

1 reply Last reply on 4 Nov 2016 by
ac3mark

Report sheet

Pls assist me on how to gives a class position of students after tabulation of the finals scores based on highest to Lowest

1 reply Last reply on 4 Nov 2016 by
ac3mark

Respective names required

Hello CCM, Please give me solutions to solve my problem.. 1) I have created 2 worksheets, one sheet having two columns like below Code ...

10 replies Last reply on 4 Nov 2016 by
Mazzaropi

Want to implement a macro to find and copy to another sheet

Hello, I have tried to implement a Macro on Excel for my data, I have a search box made for my data on cell D1 I want to make a macro in which...

1 reply Last reply on 4 Nov 2016 by
vcoolio

Copying & pasting data in next available row in same worksheet.

 Solved

Hello, I would really like assistance to write a vba code for a macro (using a drop down list) that copies data from A4:E4 and pastes it down in t...

15 replies Last reply on 3 Nov 2016 by
vcoolio

Value from matrix table

 Solved

Trying to get rate in G14 that comes from the matrix E14 is a list of A3:A10 F14 is a list of B2:J2

1 reply Last reply on 2 Nov 2016 by
Mazzaropi

Trasfering data with vba

Hello, I have sheet1 of data with 2 columns with 26 row And i want to copy this data to sheet2 but when i copy this data it overwrite the old one ...

3 replies Last reply on 2 Nov 2016 by
rogerm34

Vba: lookup a value and deduct a value

Hello! I hope you guys are well! I oh so desperately need your help. Here's what's going on...I'm gonna try to explain this as clearly as I can....

1 reply Last reply on 1 Nov 2016 by
TrowaD

Auto create sheets and dates for days and months.

Hello, Greetings. I am seeking for a help. I'm a noob to Microsoft Office apps. I need to do something using excel. The issue is how can I auto...

1 reply Last reply on 1 Nov 2016 by
TrowaD

How to manage drop list

Hello, if i have two dependent drop list one in E15 include 3 item ( only fresh ; only exhaust and both ) other in f 15 when selec...

1 reply Last reply on 1 Nov 2016 by
TrowaD

Two tables values with diffrent order and number of values

 Solved

Hello, I have 2 tables of products (diffrent number of products). 1st table contains: all products (name, SKU): NAME | SKU asd.........21398763 ...

3 replies Last reply on 1 Nov 2016 by
Mazzaropi

Set range for macro running

if i have macro locked cells with change value of other cell , but this macro work from A1 i ask if i can modified code to let macro begi...

3 replies Last reply on 31 Oct 2016 by
TrowaD

Conditional formatting

On my spreadsheet I have the following formulas on a date; Ex.J6+30=K6(Due Date), then Today()-K6=L6 (Days to implemetation). Now, when I have no dat...

3 replies Last reply on 31 Oct 2016 by
Snowhite66

Automatically transfer data to another tab via drop down

Hello, I do not know much about excel I'm afraid and have been given a task at work but unfortunately am struggling big time - tried to google it ...

1 reply Last reply on 30 Oct 2016 by
vcoolio

Clear content without clear formula

Hello, i have cells contain formula say ( $e$10 = $e$8+$e$7) i need to clear e10 if e7 = 10 but formula still found when auto fil...

1 reply Last reply on 30 Oct 2016 by
Mazzaropi

Calculate my service expense as %

 Solved/Closed

Hello, I would appreciate if someone can help me with this problem solving question. I would like to know how to calculate my Service Expense as % ...

1 reply Last reply on 28 Oct 2016 by
Mazzaropi

How to create several rules to change a cell's format.

Hello, I'm trying to create an excel spreadsheet to manage a property but I'm having difficulties in creating rules. Here's the schedule I'm m...

1 reply Last reply on 28 Oct 2016 by
Mazzaropi

Compare two columns and add data from other columns if match fou

Ok i have names in Columns D and Columns I. I want to compare those two and if they match i want to copy the data adjacent to column I (J and K) to ...

3 replies Last reply on 27 Oct 2016 by
Mazzaropi

Error "range of object global failed"

 Solved

Hello Everyone, Kindly check my code for mistakes. I am getting an error in this part of my code as "range of Object _Global failed". Dim feat...

2 replies Last reply on 27 Oct 2016 by
adikademani

Excel- if this, than return that?

 Solved

Background: I work for a Recruiting Group & we have a list of candidates in Excel with all mailing info, including the County they live in. I need to...

2 replies Last reply on 27 Oct 2016 by
HappyAdminy

Macro to copy rows and populate month/year based on start date?

Hi all, I have a set of data where I need to create a row for every month through December 2016 based on a start date. For example, below is how the d...

1 reply Last reply on 27 Oct 2016 by
TrowaD

Trying to concatenate a letter with a date

 Solved

Hello, I'm trying to keep a date in a recognisable format and precede it with a character. e.g. I want "D" and 27 July 2015 to appear as D 27 J...

1 reply Last reply on 27 Oct 2016 by
GBW

Set up automatic email after file is updated?

I have no code writing experience what so ever so I apologize upfront about my ignorance regarding VBA. Just wanted to see if someone could help me ou...

3 replies Last reply on 26 Oct 2016 by
ac3mark

Vba code for inserting an image

Hi guys, I am in an urgent need for a command or code to insert an image from any directory in my computer to a particular cell in Excel using V...

6 replies Last reply on 26 Oct 2016 by
ac3mark

If cell contains this text then....

Hello, Basically I'm looking for a formula that would let me do something like this: If cell d1 contains ANY part of Apple (ie apple pie, apple ca...

1 reply Last reply on 26 Oct 2016 by
Mazzaropi

Insert picture in excel macro, after crop it, save it to a file

 Solved

Hello friends, I need to open a macro, after place the name in A1 cell, push a button to insert a picture, base on A1 name, then, after crop it and re...

1 reply Last reply on 25 Oct 2016 by
juancarlosmm

Pictures keep pasting over each other when vba code executes

Credits to TrowaD in this Forum I was able to use his VBA Code for what I wanted but it just need a touch more to make it complete....The code below p...

1 reply Last reply on 25 Oct 2016 by
TrowaD

If function with multiple statements including vlook up

Hello, Id like for my formula to read if vlookup is found (H:H is found in the freedom report and column x matches text in AV1, say registered. ...

4 replies Last reply on 24 Oct 2016 by
ac3mark

Unable to restore emails from .edb file

 Closed

I decided to migrate to a new Exchange server due to the crush of my old server. And now I am on the Exchange server 2010. But I understood (too late ...

2 replies Last reply on 24 Oct 2016 by
captainashish

Need password

Hello, I for got my password Configuration: iPhone / Chrome 49.0.2623.91

1 reply Last reply on 23 Oct 2016 by
Ambucias

Date if function

Hello, I am looking for the formula to show the date if. Ex: I have been provided with the start date (10/4/2016) and i need to add 28 day's (=...

1 reply Last reply on 22 Oct 2016 by
Mazzaropi
Results 1701 - 1750 out of a total of 12,258