How Can I Make A Persons Name Read A Formula

Jul 28, 2009

If I type the name Joe Bloggs How can I make whenever i type that name the computer knows to retreive a number or formula from a cell on another or same sheet.

View 9 Replies


ADVERTISEMENT

How To Make Columns Read Only

Aug 7, 2014

Is it possible to make Columns Read only? So not one can type or edit. Not all columns just the ones I need

B,C,D,I,J

View 2 Replies View Related

How To Make Cell Read Only

May 9, 2006

I have tried the following code, but doesn't work unless I protect the sheet:

Range("A1:A4").Select
Selection.Locked = True
Selection.FormulaHidden = False

If I protect the sheet, then it works fine, but how can I make a cell read only

WITHOUT protecting the sheet?

View 13 Replies View Related

To Read A File And To Make Changes Using VBA

Aug 21, 2009

I have attached three excel files .....In the file called 'sampleBook1latest' I have a button called 'click here to clear a schedule' If I click that button and choose OR,start time and duration of a surgery then a schedule that is already created wil get cleared.....I have the total number of nurses and number of nurses used saved to the side of the sheet..... The total number of nurses at the side is read from another excel file called 'Input file for # of nurses'

Now the problem is that if clear a schedule then the number of nurses used is not getting updated at the side.....if I clear a schedule then the number of nurses at the side should also get updated....for example(If I create a schedule with 3 nurses and if only a total of 3 nurses are available then..... the used number of nurses for that specific time at the side will get updated to 3 from 0 and if I clear that schedule then the used nurses for that time should again become 0)....

The other problem is that if I schedule a surgery then all details of the surgery will be saved in another excel sheet called 'input file for patient details' so if I clear a schedule then all the details of that surgery saved in that excel sheet should also be cleared......

View 11 Replies View Related

Make A File Read Only

Aug 30, 2007

I need to make a workbook read only depending upon certain conditions that are apparent only on start up. As I cannot assign the ReadOnly property, is my only solution to trap the Save command and dissallow "save changes".

View 9 Replies View Related

How To Make A Cell Read Only Decimal

Jul 1, 2013

I'm trying to create a formula in a cell that references another cell but I only need it to reference the decimal. How would I go about doing this and is it even possible?

View 3 Replies View Related

Make Workbook Read Only Upon Opening

Dec 12, 2007

way of changing the mode of a workbook to readonly upon opening it.

View 6 Replies View Related

Make A Worksheet "Read-Only"

Feb 15, 2010

I have four worksheets in my project and I would like to protect one of the sheets so changes can't be saved. In other words, I would like to make that specific worksheet "read-only". The other three sheets I want changes to be saved with the document.

View 4 Replies View Related

VBA To Read Text Formula And Related Constants And Insert As Formula Into Cell

Jul 30, 2014

I have a situation where I have to curve fit data, this can lead to different formulas being used with varying constants.

Is it possible to pickup a TEXT based formula and related constants from other cells, and then place this into another cell as a functioning formula. For Example

Cell A1 contains the formula as a text string whether it be y=a+bx+cx^2, or y=a+b/x, etc
Cells A2:A6 contain the individual constants, a, b, c, etc

I would then want the VBA to read the text based formula and put it into an output cell as a functioning excel formulae.g

In cell B10: =a+b*A10+c*A10^2

I understand picking the constants up and putting the formula should not be too much of an issue, however trying to insert the variable form of the curve fit is the part that I am struggling with, and am unsure if possible.

View 2 Replies View Related

Pop Up Appear If A Persons Name Appears More Than Once

Jun 20, 2008

I would like to have a list of names in column A1 Smith, A2 Jones, A3 Johnson etc. Everytime someones name appears in E1-E20 I would like the adjacent column next to that persons name to turn red. Example: I type Smith in E14 -> B1 turns red. If it's not too complicated it would be good if excel could recognize the name in any font,capitols etc.

Lastly if I could have a pop up appear if a persons name appears more than once in column E that would be great. Example type Smith in E1 and then when I type smith in E4 pop appears--Name already used once do you want to continue?

View 9 Replies View Related

Two Different Persons Locking Cells?

Jul 16, 2013

Is it possible for 2 different persons to lock different cells on the same worksheet?

View 3 Replies View Related

Count Of Persons Name In Range

Mar 11, 2008

I want to count how many times a name is listed in the first 5 rows of 36 columns.

View 9 Replies View Related

How To Send Email To Different Persons With Different Information / Files

Sep 14, 2013

I am running a small size company, creating several excel works to automate the order/ shipment / invoice work. Try very hard to know how send invoice / AR summary email to different customers.

View 2 Replies View Related

Summing Data Over Multiple Sheets According To Persons Name

Jan 16, 2012

formula that will find "John Doe" through sheets 2-10 and check the Win column for a "w"..if a W exists, Sheet 1 will calculate numericaly how many times it shows progressively, but only for his name and not others.

Sheet 1 B7=John Doe
C7 = total W's though sheets 1-10 for John Doe
Sheet 1
B7 C7
John Doe total W's

[Code]...

This is a alteration to an existing question I asked 2 Days ago, I redesigned a new spread sheet to start over with a new approach to it.

View 2 Replies View Related

Five Digit Numbers That Represent A Persons Code

Dec 1, 2009

In one column (f5:F100) I have five digit numbers that represent a persons code. I have five groups of codes, they are 10000-15000, 16000-19000, 20000-25000, 26000-29000, and 30000-40000. In another column (Column H) I have an "X" saying the are qualified in something.

I am looking for how to write a statement that says answers this question:

How many people are qualified in the codes between 10000-15000.

Ultimately I am going to take this number and divide it by the total number of people in the group to get a percetage of qualified people in the group.

View 9 Replies View Related

Calculate Persons Age Based On Current Date

Jan 22, 2008

how do you calculate someone's age nearest today

View 3 Replies View Related

Macro For Sending Emails To Persons Listed In A Column

Mar 30, 2008

I have attached an excel sheet which i wanted to write macro as an attachment. .

when I run a macro an email has to be sent to each persons listed in column A with Voucher # in the subject line and URL in the body of the message after the URL, the body of the message will remain same for all the emails:

so I have typed the body of the message in 2nd sheet:

View 14 Replies View Related

File May Be Read-Only, Or You May Be Trying To Access A Read-Only Location

Jan 4, 2007

I'm trying to open a file on a network drive...but I'm getting the following error message when it opens: "This file may be read-only, or you may be trying to access a read-only location. Or the server the document is stored on may not be responding." Now, the file itself has no rights restrictions and is not read only. It doesn't appear to be locked.

Now, there are other Excel files in the same directory which I could open fine; however, the Excel documents having the above problem all have a little black icon "appears to be a padlock" (image attached) at the bottom left hand side of the Excel file icon. I tried the following:

- Renaming
- Converting to a different file format (didn't work, it won't let me)
- Opening in notepad...etc doesn't work.

This file is dated back in 2004...do you think it's corrupt? Is there anything i can do to open or recover this?

View 2 Replies View Related

Formula To Read Two By Two Excel Matrix?

Mar 13, 2014

I was wondering if it is possible to write a formula so that the below table can be read based on the input (in this case start month and cut-off month) and return the value from the table. I have also attached the excel with the data and some examples.

Start Month >>>>
AprMaiJunJulAugSepOktNovDezJanFebMrz
"Cut-off Month

[Code]....

View 3 Replies View Related

Code To Read A Formula As String

May 19, 2009

I am using the following code to read a formula as a string. But sometimes the use r may forget to enter formula in the particular cell. In this case I want to check if the first character of the string is a Equal-to Sign (=). In case it is then macro proceeds further otherwise a message prompts user to enter a formula first. how to check if the first character of the string is a '=' sign?

View 5 Replies View Related

Altering Formula To Read An <= Query

Sep 4, 2007

In cell AD17, I have a formula that returns the number of days or draws(Skips), since the number in cell AD2 has been drawn. The following cells AD18.......... returns the next skip and continues untill all the hits( AD3), are accounted for. My question, Can the formulas be altered to read a "

View 9 Replies View Related

Formula To Read Alternative Columns - Instead Of =

Jul 14, 2008

I have got several columns of data with subtotals, months, total unit per month, total sales per month, Example

jan feb

total unit total value total unit total value

60 600 35 180

SOLUTION

dateunitsale01-Jan6060001-Feb3518001-Mar335801-Apr911220

I am having to use = sign (=A10 --) transfer the information to solution, is there a formula that I use instead. I have try $A10,A$10 to ancher the column?. ideal I need formula that read alternative columns for date, unit and sales- that I can copy down?

View 9 Replies View Related

Left Formula Read Zero If In Front Of A Number

Jun 20, 2012

reading a zero number in a cell

here an example :

on Cell A1 = 01
on Cell B2 = 10

so I write at C1 the formula is =left(A1,1) but how come the number that comes out is 1 not 0 (zero) ?

but if I write at D1 the formula is = right(A1,1) the number comes out is 0 (zero)

how to make the formula that can read the zero in Cell C1?

View 9 Replies View Related

Formula That Can Read Row And Column Labels And Return Value?

Jan 30, 2013

I would like to know if there is any formula that can read this:

Measure1 Measure2 Measure3 Measure4
Facility1 10 15 11 18
Facility2 20 16 32 21
Facility3 9 18 17 13

All this is in one big table and I have around hundred columns. I wish to create one lookup table that will pull values out of this, on a separate worksheet. This is how my lookup table looks like:

Measure3 Measure8
Facility1
Facility2
Facility3

My raw labels will be complete and they should match with lookup table labels. I need to extract Measure3 and Measure8 for different facilities, depending if I have any data in there. The search criteria for column labels should be dynamic and if I change label for let's say Measure1 it would update for all facilities. What formula can read both raw labels and column labels and return value at the interesection of both these criteria.

View 4 Replies View Related

Excel 2013 :: Calculating Count Of Persons Of Certain Ethnicity Relatively To Place Of Birth

Mar 16, 2014

I am Using Excel 2013 on windows 8 OS,

I have no programming background but I have an Idea about it and I try to write some VBA Macros.

I have 27 Excel files which contain each of them 257368 Row Concerning personal information about persons
the File Format is as Follows:

Place of Birth (POB); Name; Father's Name; Family Name; ID Number; Ethnicity,>>

View 2 Replies View Related

Numberv To Time Formula: Change 66 To Read 00:01:06 I.e. 1 Min 6 Seconds

Nov 5, 2009

How mould i change 66 to read 00:01:06 i.e. 1 min 6 seconds? i know i'ds use mod and int but not sure how.

View 2 Replies View Related

Formula To Rank Text Objects Based On Numbers, Interesting Read

Dec 30, 2008

I'm attempting to create a formula that will find the name associated with a value, and return that name on the same column as that value in a later equation.

OK OK to illustrate it a little better:

There are three people: Bill, Ted, and Andy. Each one is ranked in Points, so my table looks like this:

A B

1 Bill 10
2 Ted 20
3 Andy 30

Later on, I want to rank the individuals based on their score, using a formula. Right now, I can rank the scores based using LARGE(B1:B3,1), then LARGE(B1:B3,2), and lastly LARGE(B1:B3,3). That ranks the numbers in descending columns. However, I want the information to automatically populate the name associated with that particular point total. So, I want the system to know that B1 is Bill's score, and rank it, in descending order, later on in the spreadsheet, with Bill's name.

View 9 Replies View Related

Make A Formula Look For Something That IS NOT There?

Sep 23, 2008

Total newbie trying to use excel for work here. I have two problems that both need the use of "is NOT in another column". 1. I need to count the number of instances in a column that do NOT have the word "fly" in column G. The current formula is...

View 2 Replies View Related

Formula To Make Every 50 Add 1

Feb 24, 2009

If i wanted to tack on something to the end of a formula so that it would make every 50 add 1 (example: 200 would convert to 204, because 200 divided by 50 is 4).

View 9 Replies View Related

How To Make MAX Formula Smarter

Jul 25, 2014

I'm currently using this formula to show the last date of a entry ie A15, on a 2 different worksheets, the forst worksheet always has a A15 entry and the 2nd worksheet currentmonth! sometimes has and entry.

=MAX(LOOKUP(99^99,currentmonth!A:A/(currentmonth!B:B=A15),currentmonth!A:A),LOOKUP(99^99,mainlogbook!A:A/(mainlogbook!B:B=A15),mainlogbook!A:A))

and if I don't have and entry in this section of the formula (LOOKUP(99^99,currentmonth!A:A/(currentmonth!B:B=A15) which sometimes I don't.

It yields a #N/A Error.

Is there a way to make this formula work if there is no entry of A15 on the currentmonth! worksheet?

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved