Protection For Limited Field In Doc

Sep 20, 2006

I need to attach some of my docs (either excel sheet or word sheet) to my client via email. Supposedly the excel or word sheet is to be fillled by them (certain field) but at the same time i need to protect amendment on some fields. for Example.

user can fill wording within the underline colume but they cannot change my "Diagnosis" word to something else.

View 3 Replies


ADVERTISEMENT

Run-time Error '50289' :: Project Protection / Module Protection / Module Visibility

Aug 18, 2004

I recieve an error :

Run-time error '50289':
Can't perform operation since the project is protected.

When i try and run my code.

The code does add parts to modules and workbook events, but I need the code to be protected.

View 9 Replies View Related

Auto Populate Field With Date When Other Field Is Selected From Validation List

Jul 4, 2013

In the following extract, I would like to have today's date placed into Col K when an entry is made into Col J.

Entry into Col J is from a validation list of 3 options. What I desire is that when one of these options is selected ("Complete"), then I would like today's date to be written into Col K.

Currently Col K has a validation list which comprises dates from 1st of each month from July to June.

I need a fixed date as text preferably, so was thinking the VBA function "Date" on a Change Workbook Sub.

The information is currently part of a Table in Excel 2007 that has about 500 records.

IdeasList

*
J
K

2
Status
Month Completed

3
In Progress
*

4
Complete
Jul-13

5
*
*

6
*
*

Data Validation in Spreadsheet

Cell
Allow
Datas
Input 1
Input 2

J4
List
*
=ValidationList_Status
*

K4
List
*
=ValidationList_Months
*

View 2 Replies View Related

If Function Limited To 7

Oct 1, 2007

I have this formula in a cell and it works....

View 2 Replies View Related

Macro To Preset Field With Text If Condition In Another Field Is True

Jun 9, 2006

I have a macro that imports a report. If the Charge Type in column A is BTOREPLX, I need to prefill the field next to it in column B with the text "REPLX", e.g. "REPLXCDROM". I've attached an example of the report.

View 5 Replies View Related

Change/Move Pivot Table Row Field To Column Field

Apr 23, 2008

In building my pivot table my data that I want to show in the column area is showing up as rows stacked on top of each other. In the column section I'm trying to show Total Budgeted Amount next to Total Actual Amount but on the layout it's showing the two stacked on top of each other is there some kind of hidden key that I'm missing?

View 3 Replies View Related

Getting Zero Formula Field When Data Field Blank / Empty

Feb 13, 2013

I have a simple formula ='info page'!b2&'info page'!b5 in places that on my sheet adds a company prefix to a item number, prefix in b2 and item in b5, we have a client that we cant use prefixes but now when I leave the field blank its giving a zero and thats not good either. I'm pretty sure an IFERROR or something will work but can get the syntax right.

View 5 Replies View Related

How To Sum Limited Time Only Offer

Dec 12, 2013

Basically I am trying to work out the impact of a limited time offer (say 6 months) which offers customers a discount on their phone bill for a period of time (say 12 months).

I'm getting stuck on the formula (if there is one!?) which takes into account the fact the build up and then roll off of customers - i.e. in month 14 the customers that signed up in the first 2 months will no longer benefit from the discount. I have attached a spreadsheet which hopefully illustrates this a bit better!

Marginal revenue.xlsx‎

View 5 Replies View Related

VBA Sort Limited To 3 Selections?

Nov 15, 2011

Any way to sort by more then 3 selections.

I want to sort by Date, Team, User, Item, then Sub iTEM.

View 9 Replies View Related

Memory Usage Limited To 1 Gig

Jun 24, 2006

I was reading in the sticky post about the new version of Excel that is due out this year. One of the improvements listed was the increase of usable memory by Excel from 1gig to the amount of Windows memory. In reading this, am I to understand that increasing a machine's physical memory above 1gig is useless for Excel in the current version? My specific issue is I have a very involved worksheet that takes about 2.5 minutes to calculate and this will increase as more data is added, it is heavy formula laden. I was going to increase memory from 2gig to 4gig to assist in reducing the calculation time.

View 3 Replies View Related

Workbook With Limited Rows And Columns

Oct 30, 2008

i've seen workbooks in the past that have a limited number of rows and colums but im not sure how to set that up in excel.

View 2 Replies View Related

How To Get The (average Or Sum) In A Limited Period Of Time

Jan 22, 2009

This code help me in typing the date and time in any cell of column (B) automatically just in case I enter somthing in any adjacent cell of column (A)

View 6 Replies View Related

Limited Number Of Characters In Cell?

Jun 14, 2013

I am looking too limit a cell too only contain 5 or 7 characters.

I can limit too one length, i.e. just 7, using the data validation function.

View 3 Replies View Related

Protecting Sheet With Limited Access

Sep 26, 2013

I need to protect a sheet with following access to users.

1. data can be entered in column a only... rest is automatically updated with formulas

2. users can insert/ hide rows. but can not delete any rows and can not hide/ insert/ delete columns

View 4 Replies View Related

Ifs , Vlookups ... Limited... Match / Index

Nov 11, 2009

I've started looking at a piece of work for ordering and bringing back matching data...

I just know i'm going to run out of If's only too soon...

Ive seen basic index and match formula, and use them now and again, but... do you "stack" them in the same way ... and would they assist with the limiting If's ?

I fear i will have around 20 "SPSA" type references ... and will need to look at diff columns depending on which is relevant... be very grateful for your guidance on the best way to approach this.. as i always end up with a messy workaround.. Thanks Chuf

=IF(LEFT($H10,4)="SPSA",VLOOKUP(J10,LookupLists!$L:$N,3,FALSE),IF(LEFT($H10,4)="SPSB",VLOOKUP(J10,LookupLists!$P:$R,3,FALSE),VLOOKUP(J10,LookupLists!$D:$E,2,FALSE)))

View 9 Replies View Related

Macro To Merge Csv To One Master But Limited

Dec 11, 2009

I am in need of a macro to merge approx 30 csv files, kept in same directory. Csv files are identical format, have one populated worksheet, 6 columns, no headers. However, number of rows will vary. I would like to merge them to a separate excel workbook, with data stacked to one master sheet. Is it also possible to only bring over rows that have than 0 in column E. I have the following macro to merge however, it merges .xls files and it brings over all rows.


Dim ToBook As String
Dim ToSheet As Worksheet
Dim NumColumns As Integer
Dim ToRow As Long
Dim FromBook As String
Dim FromSheet As Worksheet
Dim FromRow As Long
Dim LastRow As Long........

View 9 Replies View Related

Limited To 5 Dependent Validation Lists

Oct 4, 2006

Is there any way to make Hack#24 work with more than 5 lists? I followed the information in the book and was able to get 5 secondary cells to have a drop down list that was dependent on the primary cell selection (also from a drop down list). But when I tried to apply this to the next six primary and secondary cells it would not work.

View 5 Replies View Related

Auto Populate A Field In One Tab By Comparing Another Field In A Different Tab?

Jan 25, 2013

I have a tab called 'Tab1' in which I have column called 'Col1' and 'Col2'.

I have another tab called 'Tab 2' with columns 'ColA' and 'ColB'. When I enter a text in Col1(Tab1) I would like that text to be compared to data in 'ColA' from Tab 2 and when match found then get the corresponding value from ColB and autopopulate it in Col2 of Tab1.

View 2 Replies View Related

Changing A Numerical Field To A Date Field

Dec 28, 2006

in coverting these fields into a date field.

Example 91306 to 060913

I have encloed the file.

View 14 Replies View Related

Counting Per Date Field And Data Field

Apr 29, 2006

I am trying to count the number of times that data is in a field and in any field the date is greaert than today's date. This date field could be blank and that is where I am having the problem.

Example

See Attached

View 4 Replies View Related

Formula Required To Return Limited Range Value?

Jun 12, 2014

I'm looking for a formula to do the following:

I'm building a table (see attached) where I could have a value in cells D6 to P6 that ranges from 0 upwards. In the respective cell beneath each 'value' cell (D7 to P7) I need a formula that will return a figure of 10 if the value in the cell above is 0.4 or below reducing to 0 if the value in the cell above is 1.0 or above.

View 1 Replies View Related

Average Function Limited To The Number Of Students

Feb 5, 2014

I am working on an excel master marksheet which will be distributed to many teachers to fill in their students marks. How can I enter an average function that can work out the mean for those different classes. For example I'd like the main average function to be like this =average(d5:d50) but if a teacher has thirty students in his list the mean will be only limited to the marks of those thirty students. Same thing I want for the mode function and the median function.

View 7 Replies View Related

Create Limited Number Of Columns/rows

Dec 11, 2008

is it possible to create or customize a worksheet with 30 columns and 120 rows only.

View 4 Replies View Related

Ctrl-A Selecting Limited Range Of Cells

Apr 8, 2009

I have a spreadsheet wherein if I press ctrl-A (normally Select All) it is only selecting a limited range of cells ($B$12:$M$22). If I press ctrl-A again from there then it selects all.

I can see something like that being useful in some cases and annoying in others, but I have no idea what is causing it. Some of the cells in that range are locked and others are not. Some of the cells outside that range are also locked while others are not. In any case, the sheet is not protected.

View 3 Replies View Related

Derive Exponential Function From Limited Information

Dec 5, 2009

I've been working on a ss that requires me to create a function to determine a value from a exponential curve where the area of the curve is variable . The terminal points, 0,0 and 100,100 remain constant and the curve is symmetrical at the 45degree angle. How can I derive a function knowing only these things.

Here is an image to crudely illustrate what i mean [url]

The area can be 10, 20, 35% it doesn't matter, I need a way to determine the function from just the area!

View 14 Replies View Related

Worksheet - Show Only Column And Rows Limited?

Apr 8, 2014

in my worksheet i want to show only column from A to BA and rows only 1 to 5000

View 2 Replies View Related

Changing Formatting On A Cell For A Limited Time

Feb 13, 2009

I'm not sure how this could be done though i'm pretty sure its going to require some VBA instead of conditional formatting. I would like cell B2 to have background colour red for 10 seconds after cell A1 is edited. So every time A1 is edited B2 will change colour for 10 seconds and then back to original formating.

View 4 Replies View Related

Formula: Give User Limited Control

Jan 26, 2010

1. The example is cell B1 has a drop down list with the following options: MIN, MAX, AVERAGE, MEAN, SUM

The range F2:F20 hold the values upon which I want the formula to work

Cell B3 is to calculate the result of performing the the function defined in B1 over the data set in F2:F20

What formula do I need in B1. I have tried various of methods of forming the above into a text string and then preceding with INDIRECT but my problem seems to be with the range part.

2. Same as above but I want to the users to write as text (without equal sign) the formula they want to use

View 9 Replies View Related

Time Limited To Open Exel File

Aug 1, 2007

I have one excel file which I plan to send to other person. But I need this file to be openable/valid by this person just 20 days after first opening of the file.

After 20 days this person will not be able to open the file any more.

View 9 Replies View Related

Import Text Fundction Only Allows Limited Lines

Aug 7, 2008

I have to extact a HUGE (100MEG) .TAB file into Excel 2003. Using the 'import text' fundction it only allows me to import the frst 66536 lines and tells me that I can import the rest by repeating the process, somehow excluding what I have already imported.

View 9 Replies View Related







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