Can't Enter Any Data

Feb 23, 2007

I've been using Excel for years and had very few issues. However, I recently went into a spreadsheet to update it and was unable to select and enter data into an individual cell. When I click on a cell and try to enter #s nothing happens (my num lock is on). Then when I try to click into another cell it just highlights that cell, along with any other that I move my cursor over. Once I click on one cell I can't stop the highlighting from happening. I can't even click on anything in the toolbar.

View 14 Replies


Enter 4 Columns Of Data In Row Then Shift After Hitting Enter?

Jun 1, 2014

I really know nothing about vba so here goes. I would like to enter data in a row with 4 cells of info. then hit enter and return to the first cell and move the row down. all four cells must have data entered. and all four must move down. i tried some code as below i found and i modified but it did not work as expected. this moved the row down when returning the cursor to A2. It also should not copy the data style of the top row.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column <> 1 Then Exit Sub
Application.EnableEvents = False


View 4 Replies View Related

Formula Must Be Confirmed With CTRL+SHIFT+ENTER Not Just ENTER

Aug 15, 2008

This formula must be confirmed with CTRL+SHIFT+ENTER not just ENTER. You will see { } brackets appear.

View 3 Replies View Related

Enter Autosum Data Directly Below The Last Row Of Data In Columns

Feb 25, 2009

I have a spreadsheet that runs a macro resulting in a different number of rows everytime the macro is run. Columns H, I & J are the only columns with currency in them. I would like a macro to find the bottom-most row of currency data in these columns and insert the Auto-sum formula in the row directly below each of these 3 columns. Then bold this row and increase the font by 2 points (or 12).

View 13 Replies View Related

VBA - Prompt To Enter Data

Jan 15, 2007

After recording a macro that goes to last figure in data, how do I edit this to prompt for a new data value and enter it into 1st empty cell at end of data?

View 8 Replies View Related

Enter Date If Data Changes

May 2, 2007

I have 13 columns - 12 representing each month of the year and then a total. I start in F15 with Jan and end in R15 with the total - this is the heading row.

Below that I have my numbers for each month. Here's what I need to do: Anytime the total changes (by updating the monthly numbers), I need the day's date to be automatically entered into F14. This way I know the last time the data was changed.

View 9 Replies View Related

VBA - Prompt To Enter Data

Jan 15, 2007

After recording a macro that goes to last figure in data, how do I edit this to prompt for a new data value and enter it into 1st empty cell at end of data?

View 6 Replies View Related

Userform To Enter Data

Mar 15, 2007

I have a developed a UserForm to enter data into Excel. I can get the UserForm to enter data in row2 under the headings I have created. I have a Next button on the UserForm, which I want to go to the next row when pressed to enter dta in row3, then row4 etc. Is there anywhere I can find examples of how to do this?

View 9 Replies View Related

Enter Data In One Sheet Shows Up In All

Mar 15, 2013

I have copied my first sheet into multiple sheets. Now when I enter data in one it shows up in all of them. How do I stop this from happening? I have cleared out any content in them and the formula bar is blank in every line.

View 3 Replies View Related

Macro - Enter Data In Next Clear Row After Every Run

Jun 27, 2014

I have a macro that

- copies rows from one sheet into another sheet based on a set of criteria
- the very very very first time the macro is run, the first row of data should be put into row 7 (formatting reasons)
- however, every other time it's run it should paste into the next clear row.

But, what is happening is that, each time its run, it puts the data into row 7 => overwriting data.

I've used the offset and counter function but perhaps I need to put it in the header of the code to get it working?

My code pasted below:

[Code] .....

View 4 Replies View Related

VBA To Enter Data From One Sheet As Date Changes

Aug 18, 2014

Please find attached.I have two sheets. In sheet 3 I will enter data. It must record on corresponding date & column in sheet 4.


View 1 Replies View Related

Macro To Record And Enter Data In A New Row

Mar 16, 2009

I am trying to have a macro send the data from sheet 2 to sheet 3, record the data then next time shift down a row and enter the new data below and below every time new data is entered.

I have recorded a macro, but I am stuck with the recording the data and then returning to a new row.

View 9 Replies View Related

Enter Data In A Formula Cell

Mar 12, 2007

Is there a way to add data into a cell that already had a formula? Lets say in cell A1 we have a formula like "=A1*A2". Would I be able to some how enter a value into cell A1 without changing the formula?

Example: enter value "5" into A2 and value "10" into A1 which would result in A1 value being "50" after value is entered.

I know that this creates a circular error but is there any other way to accomplish this?

View 10 Replies View Related

Macro To Enter Data Without Using Input Box

Aug 25, 2012

I need a simple macro to enter data for hours worked, but don't like the inputbox.

I need to enter the Emp Nbr in B1.
AM in Time in B3
AM out Time in B4
PM in Time in B7
PM out Time in B8

I then write down the hours worked and

Return to B1

When I enter an new number, I want it to put 0 in B3,B4,B7 and B8

(see attached) Oops can't post. There is probably a better way to calculate the sub-totals, but this works except on an enter of 1200

View 5 Replies View Related

Enter Data Into One Cell From Formula In Another?

May 14, 2013

I know I can put an IF formular into B1 =if(A1="sat",D/O,0) but obviously if people enter data to this cell i.e time they worked the formula goes is there anyway I can put a formular into C1 but have the result entered into B1?

A1 sat
B1 D/O

View 7 Replies View Related

Force To Enter Data Upon Selection Of Other

Oct 23, 2007

Have a drop down list in B2 but if what they want is not in the list the can select "other",
If this happens i want to force them to enter something into the next cell B3.

View 9 Replies View Related

Enter Data In Cell, But Keep Formula As Well

Mar 27, 2009

Is it possible to have a formula in a cell which can be overwritten by manually entering in a number, but if the manually entered number is deleted, the formula remains in the cell.

View 9 Replies View Related

If A Cell Is Empty Then Enter Data From Another?

Jul 26, 2006

I have an excel sheet with a few columns, Column (1) has data entered for ever row (with a name.) Column (2) has a few random cells with data (names) about 30% and the rest are left blank. What I need, is to have a formula in a new column (3) that will put in the the data (names) of column (2) and then if there isnt data in column (2) then it will put the Data (names) from column (1). (ps, If i cant get this figured out, we have to buy a custom interface and it will cost around $7000,)

View 2 Replies View Related

Userform To Enter Data On Worksheet

Sep 14, 2006

I have sheet (say Sheet3) that is in essence a Database. I need to create a Userform to insert a row above the highlighted cell and insert the data on the Userform in that row.

Userform would have 3 textboxes to enter data, a submit button and a cancel button. (the 3 boxes titled Part, Price,Vendor)

In the Worksheet the 3 Columns are
Part Price Vendor

View 6 Replies View Related

Macro Record The Enter The Data

Apr 26, 2007

I have designed a project sheet that shows Project,tasts,start & end dates, with cells being highlighted via conditional formatting using the between format, What i would like is for the macro that i recorded to enter the data(which is c/f to a new row, At present when i run macro it reruns on the same row,the filldwn method dosn't work either, For design layout i have based it on microsoft project

View 9 Replies View Related

Enter Data On Multiple Worksheets

Jul 3, 2007

I have multiple sheets in a workbook. The sheets are protected as this workbook is used by other users also. I need to enter same data in column E of around 15 sheets. I select multiple sheets with ctrl+ or shft+click method and enter the data in the required cells. The problem is after selecting multiple worksheets, I'm not able to enter any text but I can enter numbers. When I remove the protection from all the sheets it is possible to enter either text or numbers.

View 4 Replies View Related

Automatic Way To Enter Data Into COUNTIF Formula?

May 21, 2014

I have a huge (for a newbie ) spreadsheet where every item is associated with several key words. There about 500 key words, all in the same column, and I have to build a table identifying the total frequency of each key word. Basically, the first column of the table I've created lists all the possible key words, and the second one is all the COUNTIF formulae, each one being associated with its corresponding key word. The formula I need to use is this one :

=COUNTIF($D$2:$D$8486;"corresponding key word from column 1")

The formula works well and my table looks fine, but the task of copying and pasting 500 key words into each occurrence of the formula is pretty daunting! is there an automatic way to enter each key word into the corresponding formula without having to do it manually? Otherwise, is there a more direct way or another formula that would give me the information I need? Surely there's a more efficient way to do this, but I just don't know how!

View 1 Replies View Related

Enter / Lift Data From Spreadsheet Into UserForm?

May 27, 2014

I have created a spreadsheet which uses a User Form to input data and then give it a reference number (this bit works fine).

I am now trying to use a User Form to enter a reference number which will then be searched across my spreadsheet, I then want all the entered data relevant to that reference number to appear in a User Form along with additional fields for entry of additional info.

In this User Form, the original data could be modified but more importantly, the remaining data added before then being placed into the main spreadsheet.

This is a booking in system where the person presents to a receptionist and the initial data is entered. Once that person has been dealt with, the remaining details regarding their visit will need to be inputted, hence this request.

View 2 Replies View Related

Display Value Of Intersection If Enter Row And Column Data?

Dec 19, 2013

Basically, I have a simple - but large (48Mb) sheet with UK mileage distances between towns. As the are 1,000 towns and therefore 1,000,000 cells of data it is a little tedious to scroll to the desired town. see sample attached (this is not the real file obviously!)

What I would like to do is type in a start and end point, and have Excel look for the intersection and display the value of this.

View 1 Replies View Related

Enter Data To Correct Column Using Userform?

Jun 29, 2014

I have started a user form called submit stock. What i am trying to work out is if i can use this form to enter the data to the worksheet using the form to specific columns depending on the first choice.

View 8 Replies View Related

Macro To Enter Date And Paste Data

Feb 15, 2014

On Sheet1 I want a macro that looks for the last used cell in Column D and then put tomorrow's date into column A, 2 cells below where the last used data was found in col D.

I then want to copy the entire contents of sheet2 and paste it into the cell below where we enter tomorrow's date.

View 5 Replies View Related

Copy The Data From Other Column And Paste With ALT Enter

Mar 10, 2009

i face a problem with this, refer to the Book1.xls. i don't know how to explain it. it is very simple but i don know how to do it.

View 2 Replies View Related

Enter Form Details And Check For Data

Sep 19, 2009

On the attached workbook i have a simple form with text boxes and a enter button and cancel button.

So far, i have only got as far as the cancel button closing the form. I want to know what i have to do to enter each of the fields in to the cells written on the form. Also when i do press the enter button, if any of the fields are not entered then a message box must appear notifying the user all the fields are not entered and then finish by taking them back to the form.

View 8 Replies View Related

Enter Data From Form Into Searched Cells

Jan 7, 2010

I have a userform with 5 text boxes and a command button.

I also have a sheet with a large amount of data on it, arranged into sections with headings (sheet1).

The user will enter the section heading he desires into textbox1, then other data into all of the other text boxes. Then click the command button.

I need a code that will search sheet1 for the heading they entered into textbox one, then find the next empty cell BELOW the heading (in the same row). It will then put whatever the user entered in textbox2 into that cell, textbox3 in the cell directly to the right of it and textbox4 to the right of that one, and so on.

View 14 Replies View Related

Enter Data In Textbox And Go To Cell Containing That Text

Oct 19, 2011

I have a very long spreadsheet with about 3000 rows. lets say for simplicity that column A contains a list of product ID numbers. I am looking for some macro code where I can just type in the product ID into a textbox, then hit enter (or a 'go' button) and then the cursor will move to the cell containing the part number.

I know Ctrl+F will do the job for me, but because of the frequency that I do these searches, a text input box would be easier still.

The nearest solution I could find was the one here Find text but its a bit 'overkill' for my needs.

View 1 Replies View Related

Copyrights 2005-15, All rights reserved