have one value selected from formulas in cell range F3:F7 and when I click on one of those cells, place that value in another cell "C4" named "Amount". The formulas in cells F3:F7 are: ...
View 9 RepliesWhen I use the mouse pointer to select a cell I can't use the arrow keys to move to another cell while the pointer is over the cell and I can't edit the cell while the pointer is over the cell. If I move the pointer away from the cell then I can move around and edit as normal therefore I don't think this is a scroll lock issue.
This issue also happens when I select a tab. If I select a tab and then leave the pointer over the tab I selected then I can't use the arrow keys to move around the worksheet or edit a cell; if I move the pointer away from the cell then I can move around and edit as normal.
I am using MS Excel 2010.
I want to enter the word 'Closed' in cell B1 when the due date in cell A1 is exceeded by 272 days. I have tried using conditional formatting and excel accepts the formula but nothing seems to happen. Here is what I have tried;
B1=IF(A1<=NOW()-272,"Closed")
I'm inputting data in E3 and after I hit enter I want B2 to be
selected. But only for E3 and only in one worksheet. And possibly a
further step... Sometimes the formula in B2 has picked up data from
another place depending on what value was entered in E3. If it's done
this then I won't need to go to B2, I'd want to go to A8 after E3
instead of B2.
I have 6 Headings in excel named...
"A" in cell A1, B in B1, "C" in C1, "D" in D1, "E" in E1 and "F" in F1.
There are two projects.
Project 1 has phase A, D & F and Project 2 has phase A, B, C, D & E.
My Specification follows...
1). Take Prject 1 - Which starts from A...in cell A2 I will keyin "A". When the phase comes to an end I will key in the end date of the phase. As soon as I key in the end date in cell A2 Letter D should automatically appear in the cell D2 and when Phase D comes to an end I will key in the end date in Cell D2 which should automatically keyin F in the cell F2. and is the same case for Project 2.
Basically it is a if statement saying that if the selected cell falls between 1/01/06 and 31/01/06 then Jan would be selected. The end part is not a problem; I’m just not sure how to write the one line of code that would test if the cell falls between the two dates. I attemped to create it as shown in the code attached below but wasn't successful. I used an else if statement to test the other 11 months.
Sub test()
Dim SelectDate As Range
Set SelectDate = Range("SelectedDate")
If selectedDate >= 1 / 1 / 2006 And selectedDate <= 31 / 1 / 2006 Then
ActiveSheet. PivotTables("PivotTable1").PivotFields("PnLDate").CurrentPage = _
"Jan"
ElseIf selectedDate >= 1 / 2 / 2006 And selectedDate <= 28 / 2 / 2006 Then
ActiveSheet.PivotTables("PivotTable1").PivotFields("PnLDate").CurrentPage = _
"Feb"........................
Automatically copy formula to next cell when i enter something in perticular cell ....
View 11 Replies View RelatedI have Excel 2000, recently when I format a cell to display mm/dd/yyyy and enter mm/dd/yy, it is displaying dd/mm/yyyy. Or it starts out correctly and during a future opening of file it displays incorrectly.
View 2 Replies View RelatedI am trying to enter a value in a cell which is dependent on a corresponding value in a table. I have a table A which has a cab type and a corresponding cab number.
What I want to achieve is that when I enter the cab number in another table say in cell (D3), the cab type is automatically entered in cell (C3).
Table A
Cab Type
Cab No
Indigo
100
Indigo
758
Innova
1544
Indica
1675
I want to copy formula from previous row to next cell when i enter something in perticular cell.
i.e
--Colomn A --- Colomn B -- --------Colomn C
1 01-09-07 ----- John ----------=vlookup(b2,$s$1:$t$10,2,false)
2 01-09-07 ----- Smith -------- =vlookup(b3,$s$1:$t$10,2,false)
3
4
5
Now if i enter date in cell A3 then cell C3 should be automatically filled/copy formula as celll C2. and so on......
then if i enter data to A4 then cell C4 should be automatically filled/copy formula from cell C3.
I have also attached example file.
I have a problem regarding highlighting a specific cell, when i entered a specific date in another cell
Let me explain
If there is a Name, joining date, termination date/resignation date in cell A1 A2 & A3 respectively.
If the name is John, Joining date = 01/01/2012, Resignation Date 06/06/13
I need a formula which highlights the cell A2 plus all those cells which have the same date when i entered a date (i.e 01/01/2012) in another cell.
I am trying to enter a value in a cell which is dependent on a corresponding value in a table. I have a table A which has a cab type and a corresponding cab number. What I want to achieve is that when I enter the cab number in another table say in cell (D3), the cab type is automatically entered in cell (C3).
Table A
Cab Type
Cab No
[Code].....
I'm trying to create a supply order form. Is it possible to enter a product name in one cell and have the price for that product automatically appear in another cell? Is there a formula that I can use to make this happen?
View 2 Replies View RelatedIf any text or number is added to a specific cell then a letter "P" is entered into another predefined cell.
Example:
Cell A1 is normally empty but if a number or text is added to cell B1 then a letter "P" is automatically placed into cell A1.
I am working in excel and for some reason when I hit the enter key it stays in the same cell. I never had this problem before, what did I do and how do I fix it?
View 2 Replies View RelatedI am trying to do is to make it so that users can enter data into my form (I have managed to create the form and am working on trying to figure out how to get the info entered into the form to appear in my worksheet) and then the data will cause the information to, basically, compile sentences that I want to appear in one of three cells at the bottom of the worksheet.
Essentially, at this point in time, the end goal is to make 3 cells that contain text. Eventually, this text will be indexed elsewhere, but that is for the next person to deal with. I am creating a prototype that I want to present as a process improvement.
So, when the user selects 3 in cell D7 I want the text "Customer purchased 3 Widgets at $20 each." to print in cell 82B.
I also want the user to be able to copy and paste some customer records from another program directly into a cell in the form that will just print (unchanged) into one of these boxes, too.
Lastly, I want the user to be able to select checkboxes that will, when selected, print a comment that will print in two of these boxes. For example, if the user selects yes for cell D26 then I want the text "Customer not eligible for free shipping" to appear in both cells C82 and D82.
I have big library books database file. now i want to re check all the book with physical stock and mark in excel file.
i have one more file with books barcode no.
now i want to mark multiple cell in sheet..
i am currently using the macro below to import text files into a spreadsheet. Currently, it begins the import in cell A1 which is what I recorded it to do. how do I change the code to begin the import on the active cell?
View 2 Replies View RelatedMacros question - The user enters a word, e.g. Malaysia in a particular cell (always the same location) and I want the macro to be able to find the next cell with that word in it, but it appears that when using macros you can't paste anything into the find function, so was just wondering what to do!
View 1 Replies View RelatedMONDAY
xxxxxxxxxxxxxTeam1 | Team2 | Team3 | Team4 etc.
Hours State1
-
Hours State2
-
Hours State3
-
etc.
TUESDAY
xxxxxxxxxxxxxTeam1 | Team2 | Team3 | Team4 etc.
Hours State1
-
Hours State2
-
Hours State3
-
etc.
WEDNESDAY
xxxxxxxxxxxxxTeam1 | Team2 | Team3 | Team4 etc.
Hours State1
-
Hours State2
-
Hours State3
-
etc.
Each team leader would then input hours in each state each day on their column. Make sense? Easy Peasy...
My question........... is it posible to have a userform where a TL would select their name (Column) and Day (Monday=Row 3, Tuesday=Row23 etc) from a dropdown and then input figures in txt boxes to submit them in the correct location?
I am in the last stages of setting up a spreadsheet which will help calculate scores in a game we play and need help with the following:
If, within a column of random numbers (calculated elsewhere) there is a 0, what is the value of the number in the cell immediately above the 0, and if more than one 0 in the column, the greatest of these.
Basically I have a filtered list in colunms A to D. The user selects a cell in column A and I want to then be able to run a macro which copies that cell and the adjacent one in column B, into columns A and B on sheet2.
The complications are
Column B on the second sheet is merged with columns D to E so a straight forward cut and paste of A and B on sheet 1 into A and B on sheet 2 will not work in one cut and paste as it complains about merged cells. It would need to copy and paste A and then copy and paste B to avoid the error.
The row on sheet 2 where it is being pasted needs to be the first row between row 10 and row 30 where col A is blank (so it doesnt overwrite a previous copy and paste as they are basically creating a list on sheet 2 in those rows by runing this macro repeatedly). if there is no blank row then it should insert a new row at row 10 and paste into that
Sheet 1 is a table with the first column and first row as text (table headings). The first column is names and first row is from report names.Namereport 1report 2Jane Doe114John Doe52
Sheet 2 is the report1, for example purposes
NameJane DoeJane DoeJane DoeJane DoeJane DoeJane DoeJane DoeJane DoeJane DoeJane DoeJane DoeJohn DoeJohn DoeJohn DoeJohn DoeJohn Doe
I am trying to have it to so that when you double click on cell B2 of sheet1, it will go to sheet2 and autofilter on the value to the left of B2 on sheet1 "Jane Doe"
This is what I have so far but when I double click on B2 it just moves the cursor to the cell to the left instead of filtering on the value of the cell to the left on sheet2.
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Dim id As String
If IsEmpty(ActiveCell) = False Then
ActiveCell.Offset(0, -1).Select
Else
id = CStr(Selection)
Sheet2.Activate
Sheet2.Range("A1:A500").AutoFilter Field:=1, Criteria1:=IsEmpty(ActiveCell) = False And ActiveCell.Offset(0, -1).Value.id
End If
End Sub
How would I get a particular cell to display the contents of any cell that might be selected.
ie, if I click on A1 I want A2 to display the info thats in A1, and if after that, I click on E12, I want A2 to then show E12's info, etc etc.
to find event that is triggered when cell is selected.
Or maybe there is a better way to do this?
This is what i want:
When user clicks given cell form will pop up letting user choose cell value from Combo box.
I wanted to use Cell Selected event and just pop up Form but maybe i can do it withought VB.
Is there a way to limit possible cell values to few predefined values?
So user cant put there whatever he/she wants?
Is there a way of a message being displayed if a cell has a specific value.
e.g. if cell A1 = 2 then a message is displayed to say 1 more and action will be taken.
How do I after entering data into say cell A1 and jumping it to say cell F3 and enter data and then another and so on
View 2 Replies View RelatedI have to enter a ton of dates in cells that don't need to include the day. And so was hoping if there was a way to enter a date into a cell without having to enter the day.
In essence, it seems like I have to type in the date as month/day/year and excel will figure it out from there. I would like to be able to just type month/year without bothering with the day, such as 9/14. And then excel recognizes this as a date.
Excel has to be able to recognize it as a date because these dates are expiration dates. And I would like to conditional format these dates so that when the expiration date has past the cell turns yellow.
When I click on a cell to enter text, a new little text window pops up inside the cell and doesn't allow me to enter text. No matter where I click in the cell another little text window appears. I also can't delete the text in the cell because the little text window pops up again and again.
Here's a pic of it: [URL]....
I need to take a figure that appears in a cell, take off 20% vat from it and then calculate 16% off what is left, that is the figure I need in the new cell ? Show me exactly how to write that formular into the new cell?
View 3 Replies View Related