Cell Protection After Entering Data

Mar 1, 2012

Having the cell protected after entering the data. From the below table, i need when a date is entered and moved to next cell, the cell which contains the data should be protected. I need to this for the comments column as well.

Number
DateStart timeEnd TimeActual Time takenComments
123459132546132156135469654814846543

View 1 Replies


ADVERTISEMENT

Entering Data In A Cell

Jan 5, 2007

Earlier this morning I had a telephone call from a customer who uses a spreadsheet I created.

She explained that once she'd entered information into a cell [and clicked elsewhere] she couldn't then add to the former; rather, she had to click on the cell and type it all out again.

I assumed that, as an inexperienced excel user, she was unware of either double-clicking the cell, or selecting and pressing F2. I explained these methods to her.

She later emailed me with this:

"Further to our phone conv this morning I have just tried double-clicking on cells but it deletes everything in the cell rather than lets you edit what is there – F2 does the same thing. This applies to any cell, whether it is text, date or number."

I've been using excel for a while now, and I've never come across such a thing before.

Has anyone else? Could it be to do with her own excel settings? (other customers have had no such problem)

View 9 Replies View Related

Lock Data In Cell After Entering Value?

Feb 2, 2014

0: i have a sheet 1 protected and few edit range (Col A,B,C,D,E and F).

1: I have a validation on multiple adjacent columns (like Col A, Col C, Col E).
2: I need a code where if i select value in col a (cell A2) cell B2 should get current date and Time and both the cells (A2 and B2) should be locked. when i select data in cell C2 , D2 should get current date and time(Cell C2 and D2 should be protected).
3: User can enter data in A3 and B3 will get current date and Time (now A3 and B3) should be locked.
4: I need a function where user can call it and unlock the locked cells and edit the data and re-lock the cells again.

apart from the Col A,B,C,D,E and F, other columns and cells remain locked.

View 2 Replies View Related

VBA Code To Lock Cell After Entering Data

Feb 2, 2014

I have a worksheet, i want to lock the data entered in a cell of a particular column . e.g. if i will enter the data in A2, A2 should be locked, when user enter data in cell A3, A3 should be locked. I want this code to apply on multiple columns (A,C,E,G).

View 3 Replies View Related

Entering Data In 1st Blank Cell In Specific Row

Mar 5, 2014

I have created a form where a date and remark is added every few days. I am using Phone Number as the base of VLookup. I want a code so that the date and remark which is entered in a Text Box, is stored in the first available blank cell pertaining to that employee. I want the first date and remark to be under "Date 1" and "Remark 1".

Thereafter, if another remark is subsequently added for that employee, the form would ask to enter his phone number to identify which employee the remark pertains to. Then the Text Box where remark is entered should be stored under "Remark 1" if there has been no remark before, "Remark 2" if "Remark 1" already exists, "Remark 3" if "Remark 2" already exists and so on.

I do not want to enter it in a new row. I want to enter the remark in the next blank cell of the row which matches the employee Phone Number.

Untitled.png

View 5 Replies View Related

Entering Data In Cell And Having It Round To The Nearest .25

Sep 24, 2007

Is it possible to have this function work to round in the same cell the data is entered in? ...

View 9 Replies View Related

Cell Protection :: How To Stop Type Of Data But By Selecting Drop Down ...

Feb 4, 2008

is it possible to restrict a cell in such a way that it is impossible to type data into it, but rather select data from a drop down, through validation?

View 9 Replies View Related

Move Data From Multiple Worksheets To Single Sheet Without Manually Entering Each Cell Id

Feb 5, 2014

I have a number of worksheets and need to move data from the same cells of each work sheet to a summary worksheet. I manually entered the cell id's for the first sheet.

Example =Jan!M6, =Jan!N7, =Jan!O9 etc.

I know I should be able to automatically enter these same cells for the remainder of my worksheets with out manually going in and typing each one (there are a lot of entries.) I just can not remember how to do it. The next sheet is named "Feb" and "Mar" etc.

View 5 Replies View Related

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

Entering Data Into Cells

Aug 19, 2009

I'm building a database which I intend to upload to an ecommerce website. I am retrieving information on some of our products from the manufacturer's website. The information appears on the manufacturer's website as follows:

Part No : DP9970

* Description : Disc Pads
* Manufacturer : Trupart
* Unit Of Sale : Boxed Set
* Width (mm): 130
* Height (mm): 62
* Thickness (mm): 19
* Note: 4 pads with top clip

When I copy and paste this info into excel, it gives each individual line of information a separate cell. I need the information to appear in one cell in order for it to display properly on my website.

View 4 Replies View Related

Entering List Of Data Using VBA?

Aug 1, 2014

I have a list of number I want VBA to add to a sheet. right now i have a VBA to add it one by one but was wondering if there was an easier way.

EX.Range("A1").Select
ActiveCell.FormulaR1C1 = "78"
Range("A2").Select
ActiveCell.FormulaR1C1 = "275"
Range("A3").Select
ActiveCell.FormulaR1C1 = "280"
Range("A4").Select
ActiveCell.FormulaR1C1 = "765"

View 1 Replies View Related

VBA Userform For Entering Data?

Mar 22, 2014

I am a beginner in VBA programming and I have to make a Userform for entering data in the specific places(in a table) in the worksheet. But when I enter a number, it changes all the cells to that number. I can't find my error.

View 7 Replies View Related

Entering Data Automatically

May 19, 2009

I have two files which are attached.

One is the main report file "ops report.xls" and other is the raw file (Air.xlsx) from which data is to be added to this file. i manually take the data and enter it into the ops report everyday. This i want to automate as there are many such sheets to be completed (i have mentioned just "Air" sheet here in ops report).

Now what exactly i want to do is?

take data from Air.xlsx workbook as per the columns in the Air sheet in Ops report and paste it on that particular date row. this i will have to do everyday so the nest day the data will be pasted on next row against the date. The yellow columns which i have marked have formula so you need not touch that columns.

I nee to paste the average of Air sales and Air service. so we have to take average of row 43 and row 89 for first two columns in ops report. and then average of row 44 and row 90 for column L,N,O,P,Q in the ops report.

Afterwards the average of column J must be pasted in "Interval" sheet in ops report.

This is a bit tough but i know there are many genius people out there who can easily solve this.

View 10 Replies View Related

Entering Data In Next Row On Same Column

Sep 24, 2007

I have the bellow code, I'd like enter the input on the next available row on column "A" instead than on "A2"



Dim strResponse1 As String
strResponse1 = InputBox("First Name", "Hey you !")
If strResponse1 = "" Then
MsgBox "You have chosen not to participate!", vbInformation, "What happened?"
Exit Sub
End If
Range("A2").Value = strResponse1

View 9 Replies View Related

Entering Data On Websites

Jul 14, 2006

I have a basic script in VBA set up to enter standard information (street address in one block and city in another) on a website that has no fees or password requirements. If I step through the code using F8, this works great and the website returns the data for the address that was input from my excel sheet. However, when I assign this same macro to a control button on the excel sheet to get the code to run automatically, the website comes up to the default screen with nothing entered in either of the blanks. Again, when I just step through this, I get all the way to the output page on the website with the resulting data from my input data. For some reason, this does not happen using the same code connected to a button for automation purposes.

View 9 Replies View Related

Entering Data In Calendar

Aug 29, 2006

I have data pertaining to our fleet of trucks in 8 (1 for each plant)worksheets, sorted by truck number. I would like to enter a date (usually a monday) next to a truck number and then have the corresponding date plus 4 colored and/or have the truck # inserted on a calendar I have formatted in another worksheet with 31 columns and 12 rows.

View 2 Replies View Related

Data Protection And Grouping?

Feb 12, 2013

grouping the protected/locked data.I am using excel 2010.I have data in sheet and have inserted group. I have protected this sheet and hence not able to use data group in this sheet.Is there a way i can operate data group option even if the sheet is protected.

View 1 Replies View Related

Sum Data By Entering Date Range

Feb 2, 2014

I have a spreadsheet that records water consumption in L/s at 5 minute intervals. I've attached an example of the data collected during January 2012.

Is there any formula that will calculate the total amount of water consumed between a user-entered date range? For example:

From: 01/01/12 00:00 (User enters 'from date and time' in an allocated cell)
To: 20/01/12 23:55 (User enters 'to date and time' in an allocated cell)
Consumption: ______ (Formula generated result in Litres)

View 3 Replies View Related

Shade Line While Entering Data

Jan 12, 2013

As I input data down a column in a wide Excel spreadsheet I would like to have highlighted the line I am working on as a check that I am in the correct place. I know that I can hit 'shift', 'space' for a single line, but is there a way to do it without having to hit those keystrokes each time?

View 2 Replies View Related

Entering Data To Two Files Same Time

Jan 25, 2013

I have two excel file name as A.xlsx and B.xlsx. Avoiding double work if I entering the production data in A.xlsx , need to automatically display the same data in B.xlsx. Let me know how the entered data in A.xlsx automatically display in another excel file B.xlsx.

View 1 Replies View Related

How To Protect Formulas When Others Are Entering Data

Feb 27, 2014

I have a spreadsheet with multiple formulas in several columns - my staff will be using this spreadsheet to enter data throughout the year so it will be constantly touched by several users. Some of the columns are hidden, but I worry about someone sorting something funky or deleting or adding a row. Any way to protect the columns I have formulas in while still allowing them to enter data in the rest of the spreadsheet?

View 2 Replies View Related

Preventing Duplicates When Entering Data

Jan 1, 1970

THis looks close to what I have been trying to find for months but what if I want to delete duplicates after pasting instead of making an error code? For instance, I have a list of names and addresses and I want to delete any entire row with a duplicate address.

View 9 Replies View Related

Entering Data From Top / Beginning Of List

Feb 10, 2012

I am trying to create a list of customer credits for my store. I have the person's name, the date of their credit, and the amount of the credit. This list will eventually be substantial and I would like to know how I can set it up so that when I open the worksheet I can enter new names from the top of the list and have the rest of the list shift downwards. This would stop me from having to scroll to the very bottom to add new info every time.

I would like to have it set up this way so that eventually I could put a search query at the top of the page (i'm thinking of rigging something up using vlookup) so that when my employees want to access the data base they can easily search a name and have the relevant info brought up, or can easily type in new store credits.

View 2 Replies View Related

Mark Cells For Entering Data

Oct 4, 2007

Can I add something to a cell and have it so it does not print?

I need to mark certian cells to have data filled in, in those cells. However if data is not put in those cells I need them to be blank when printed.

Example:
I can put text in B7:
Enter Name Here

Then the user knows to put the name in that spot. If there is no name to be entered then I want to be sure that is not printed when I print the list.

Is any of this a possibility without putting 33 different labels on the page, which is one way. Or 33 different comments on the page, another way.

View 9 Replies View Related

Prevent Entering In Wrong Data

Aug 6, 2008

[code]...

Above is what I hav already, I was thinking it would help if each card had an additional field added that told you if the contents were valid. This could also say empty if all fields were blank. This field could for example use an if statement to check that you have entered a VS, a start date a project name. It could also check that if you have entered a completion date you also enter review loops. This could be in large red text so it is obvious to someone completing a card that they have not yet filled in all necessary data.

View 9 Replies View Related

Re-entering Cell Value

Dec 7, 2009

In some of my formulas, I need to re-enter the contents of the cell in order for a formula to compute.

For example, I am doing some math on a cell whose original contents are "10:21:00 AM" The formula returns a #NUM!. If I retype 10:21 in the cell and hit enter, the formula will now calculate properly. I have reformatted the entire column several times so that it is a custom hh:mm format. The original content also shows as time so I don't think that it is a formatting issue.

My worksheet has about 20,000 rows and this only happens for about 100 of the rows. It is pretty time consuming to manually go fix each one. Any ideas what is going on here?

View 6 Replies View Related

Cell Protection

Nov 5, 2008

is there a way that i can stop people being able to edit certain cell in a sheet but still allow them to type in other cells as when i have tried diffrent ways it locks the whole sheet

View 5 Replies View Related

Skip Column When Entering Data Via Userform

Aug 3, 2014

I have a spread sheet that is populated via a Userform. I have arrived at a problem where I don't know how to write the Code so as to Skip Column B i.e.

Column A Column B Column C Column D Column E Column F
Serial
ID
List of Activities
Owner
Environment
Planned
Start
Planned End

1
HQ DLC0001
Campaign Plan
HQ DLC
28-Feb-14
18-Jul-14

From the text Box I fill Serial, List of Activity, Owner Environment, Planned Start, Planned End.

Column B - ID - Is a unique ID that is created via a formula.

How can I add a line to the code below so that the User form skips Column B and only places the in putted data into Columns A, C, D, E and F.

VB:
Option Explicit
Dim id As Integer, i As Integer, j As Integer, flag As Boolean

Sub GetData()

[Code] ......

View 1 Replies View Related

Copying Data From Website And Entering Onto Spreadsheet

May 30, 2014

Working in Windows 8 excel. I am copying data from a website and entering that data onto a spread sheet. There are certain websites where the data does not transfer on the first try. It sometimes takes up to trying 3 times before the data will download onto the spread sheet. Why is that? And is there anything I can do to get it to transfer on the first try?

View 1 Replies View Related

Excel Freezing When Entering Data In Some Columns?

Mar 12, 2013

resolving a "not responding" problem that occurs when I try to enter data into a cell in one of two columns in my spreadsheet. These columns don't seem to be linked and I can't see a way of getting at where the problem might be coming from.

Is there a tried and tested method for trouble shooting something like this?

View 2 Replies View Related







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