The discussions

Formulas

I know the basic but I am trying to formulate cells that will automatically that when you enter a figure in the cell it will multiply that said number...

3 replies Last reply on 28 Jul 2017 by
ac3mark

Automatically insert rows in associated spread sheets

Hello, I have created an accounting workbook of 15 sheets to produce accounts and associated information for a group of around 85 people. The names...

2 replies Last reply on 28 Jul 2017 by
ManxEd

Formatting a cell containing text

I have a task tracker where once the task is completed and the 'hasten' cell is 'yes' then I want the entire row to be formatted so the text within th...

1 reply Last reply on 28 Jul 2017 by
stankirsolkar

True or false value based on 3 difference cells' criteria

 Solved

Hello, I need a True or False (or Y/N) return if for example: A1>=30 AND B1>=80 AND C1>=80 but I have been unable to get IFS to work with t...

1 reply Last reply on 26 Jul 2017 by
ac3mark

Copying rows with data from multiple sheets to one master sheet

Hi guys, I'm trying to figure out how to copy rows from multiple sheets with values in column Q to a master sheet. I have seen a set of codes a...

1 reply Last reply on 26 Jul 2017 by
vcoolio

Saving input into 2nd worksheet while keeping the 1st empty

Hi there, Spoiler alert: Excel dummy I hope you can help me with this. I need to have a worksheet that would be used on daily basis and can be ...

1 reply Last reply on 25 Jul 2017 by
TrowaD

Compare and separate data

Hi, I am obviously new to the forum here, but I came across a question kind of inline with my own on here and wanted to see if I could get some hel...

3 replies Last reply on 25 Jul 2017 by
TrowaD

Inventory master list help

Hello, So I have a workbook with an inventory master list that i would like to pull inventory numbers from all of the other sheets in my workbook....

1 reply Last reply on 24 Jul 2017 by
ac3mark

Record scenario iteration results macro

Hello, I have a financial projection spreadsheet that will result in a residual value in a certain cell. I want to run 1000 iterations using a macro a...

1 reply Last reply on 24 Jul 2017 by
ac3mark

Converting data in one column spanning three to four rows

dear sir i have an address book over 500 addresses in column A. i am not able to index the book alphabetically i need to shift the data in a2 of ...

5 replies Last reply on 21 Jul 2017 by
BrianGreen

Macro for coloring cells according to the value of the cell

Hello, I have 10 experiments. Every experiment has some info (for example temperature, pressure etc) like it is on the picture. So each experiment...

1 reply Last reply on 20 Jul 2017 by
ac3mark

Macro for coloring cells according to the value of the cell!

Hello, I have 10 experiments. Every experiment has some info (for example temperature, pressure etc) like it is on the picture. So each experiment...

1 reply Last reply on 20 Jul 2017 by
ac3mark

Repeating a simple macro loop up to 1,500 times

 Solved

Hi All, Office 2013 user here with a first time macro question... I have a large XLSM file with simple text labels in Column A. There are 1,500 ...

5 replies Last reply on 20 Jul 2017 by
TrowaD

Excel external data connection not working properly

 Solved

Hello, I made a connection between two workbooks where there is a master workbook and non-master workbook that uses the master as an external sourc...

1 reply Last reply on 19 Jul 2017 by
kvil

Conditional row copy/consolidate

Hello, I am working with a database that deals with student scheduling in schools. I am getting repeated lines for each class a student is enrolle...

3 replies Last reply on 18 Jul 2017 by
ac3mark

How to create a macro to copy and paste

How do I create a macro in excel to copy and paste row 1 through 18 in column A into column C. I want to copy and paste every 18 rows in order in colu...

3 replies Last reply on 18 Jul 2017 by
ac3mark

Macro for coloring cells depending on values and presenting them

Hello guys!! I have an excel file with 2 columns of percentages. The first column has theoretical values of an experiment and the second column has...

1 reply Last reply on 18 Jul 2017 by
TrowaD

I need to create a formula if with dates and 2 variables

Im trying to create the following formula in excel If theres number greater than 0 in a column and if the date in the other column is before one mon...

1 reply Last reply on 15 Jul 2017 by
Mazzaropi

Compare two column from two different sheets

Hi...I want to compare two column from two different sheet which contain time and date.In sheet A column with date and time.In sheet B , there are two...

1 reply Last reply on 14 Jul 2017 by
ac3mark

Search option did not getting in filters

Hi All, Hope you doing well !! When I update fliter in my Excel sheet then I did not getting the search like this, please find the snip below. ...

1 reply Last reply on 14 Jul 2017 by
ac3mark

Urgent help-vlookups in excel

Hi, can we compare 2 excel sheets in which we have date related to Emails ID'S (Email recipients) but one sheet is having 230 rows and other 160 , i n...

1 reply Last reply on 14 Jul 2017 by
ac3mark

Create a date from 3 different cells

 Solved

Hello, In excel I have date spread across 3 cells; 1 with the day (A1), 1 with the month (A2) and 1 with the year (A3). I want to put these 3 numb...

11 replies Last reply on 13 Jul 2017 by
Udeni

Check register with vlookup

Check Register Col.A Col. B Col.C Col H Col I 1 Payee ...

1 reply Last reply on 13 Jul 2017 by
TrowaD

Comparing two excel sheets and copying like data to third

Hello, I used the below answer and it works but i actually need to tweak it to copy from the second sheet. So I have sheet 1 has full data and co...

3 replies Last reply on 13 Jul 2017 by
vcoolio

Creating a calendar that autopopulates from multiple sheets

Hi all, I am attempting to make a calendar that will auto populate or vice versa from multiple other sheets. This is all to track training hours fo...

1 reply Last reply on 12 Jul 2017 by
kadrleyn

+1 for every letter "s"

I am trying to add 1 for every letter "s" between C5:C53,F5:F53,I5:I53. So far I have this formula =SUM(IF(C5:C53="S",1,0)) Which is giving...

5 replies Last reply on 12 Jul 2017 by
Mazzaropi

Macro to insert multiple rows between existin

 Solved

Hello, I am trying to create a macro that will insert 2 blank rows into an existing spreadsheet after every 2 entries. The amount of rows needed wil...

7 replies Last reply on 11 Jul 2017 by
Pedro

Conditional format help

I have an excel spreadsheet set up with 4 columns: Start Date/30 days after Start Date/60 days after Start Date/90 days after Start Date What I wo...

1 reply Last reply on 11 Jul 2017 by
Mazzaropi

Student position formula

Hello sir : I want to find the student position. But those student who fail in exam not incldue in the position.

1 reply Last reply on 11 Jul 2017 by
Anonymous User

Macro for creating separate files with fixed password from colum

Hi All, I need urgent help for a macro which will create separate files from a column value I have this data in the picture attached http://sta...

1 reply Last reply on 10 Jul 2017 by
pamla143

Copy and past the not equal value using macro

 Solved

Hi guys!! Please help me with this. I'm trying to compare two sheets in excel. If it is NOT a match then copy the entire row into a new third sheet. ...

3 replies Last reply on 10 Jul 2017 by
Sam

Cf using date to change font/backgroundcolor to another cell

Hello, Good day, can you help me how can I change the font/background color of another cell base from the list in another cell. Example in A...

1 reply Last reply on 9 Jul 2017 by
Mazzaropi

Excel formula

who to pass in exam give the grade and who to fail in exam not give the grade show the empty cell excel formula

1 reply Last reply on 9 Jul 2017 by
Mazzaropi

Script is really slow and sometimes crashes

 Solved

Hi, My script is really slow and sometimes crashes when there's too many rows. Can someone help me figure out how to make it faster? Dim b A...

5 replies Last reply on 7 Jul 2017 by
vcoolio

Need vba macros to copy specific data based on condition

Suppose I file A which contains yearly data which we update on daily basis. lets say File A contains the data for year 2017 with following columns. ...

1 reply Last reply on 7 Jul 2017 by
ac3mark

Need help creating a formula for excel

I'm not too familiar with excel, i'm trying to start a small home business and i'm creating invoices using excel. I need help with a formula that woul...

3 replies Last reply on 5 Jul 2017 by
five2588

Colour excel cell based on regional post code

I want the cell colour to change based on the Regional Post Code I have used in segmenting the UK. It's my own project.

1 reply Last reply on 5 Jul 2017 by
ac3mark

Need help with script or formula

 Solved

Column A shows "Date" while column B shows "Passenger #" I want to Copy and paste the Passenger # to Column C "Total Passenger" The problem is I o...

5 replies Last reply on 5 Jul 2017 by
josh07429

Matching cells but exclude blanks

 Solved

Hello, I am trying an "IF" formula to see if A1 matches B1 and if so I want to return C1 but if the two cell are blank its working I want to exclud...

11 replies Last reply on 4 Jul 2017 by
Hira

Vba code for adding sheet from range specified in another sheet

Hi Everyone, I am not well versed with VBA. I m looking a code if any one can help. I have a fixed template in sheet"4" which contains the name o...

6 replies Last reply on 3 Jul 2017 by
hitrus87

Rounding up time

 Solved

Hi, Im having a problem on rounding up time, I've use =mround(A1,"1:00") it works fine on dates and time like this "5/2/2017 7:01 AM" but whe...

1 reply Last reply on 30 Jun 2017 by
nickname missing

Adding formulas

Hi guys need help with some formulas I am currently trying to combine. the Rules is 1. If there is a "Form submitted" in the day I have to copy wh...

1 reply Last reply on 29 Jun 2017 by
ac3mark

Automatically copying columns from one work book to another.

Please I need assistance with a problem I've struggled with for quite awhile. If I could write code I'm sure it would be quiete easy. My issue is: I...

1 reply Last reply on 28 Jun 2017 by
vcoolio

Graphing student data

As a tech teacher, I run typing reports on my students each day/week. Each report is saved as a worksheet in a quarter workbook. The list of student ...

1 reply Last reply on 28 Jun 2017 by
ac3mark

Vba compile error: do without loop

 Solved

Hello, So I modfied this code from an CCM post. I have Do I have an End IF Why am I getting the Error? This query is copying data from s...

1 reply Last reply on 28 Jun 2017 by
ac3mark

Inserting pictures from a file name that is made from 3 cells

I am looking for a macro to insert all of the pictures from a folder who's address is derived from multiple cells. Picture location is as follows: ...

3 replies Last reply on 28 Jun 2017 by
ac3mark

Sorting the highest value with dates

Need help with formula or script Where I need to look for the Van's highest Passenger# with the latest month available for example van 800's l...

6 replies Last reply on 27 Jun 2017 by
ac3mark

Conditionally copy col values from one sheet to master sheet

I have 3 workssheets, Master , Billing and EA.I'm trying 2 diff things: 1. update the master sheet when either of the Offer or EA sheets are updated/...

9 replies Last reply on 27 Jun 2017 by
hitrus87

Compare of two column

I have 2 columns column a have unique record in repetition and in column b I have non unique values ...now what I want ...I want to place the remark...

1 reply Last reply on 27 Jun 2017 by
TrowaD

Dates in excel are all mixed up and won't convert

Hi, I downloaded some data from my bank for some transactions. Using MS Excel 2008 V 12.2 on a Imac 2015 I usually convert the dates to YYYY-MM-...

1 reply Last reply on 27 Jun 2017 by
TrowaD
Results 901 - 950 out of a total of 7,066