How To Enter Name On 1 Sheet, Have It Disappear On Another
I think I asked this in a much more complicated & confusing way before; hoping this makes more sense. I'd like to set something up so that when a name is entered in ColA of sheet1, it disappears from a list of names in ColA of sheet 2.
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Sheet Tabs Disappear When I Open Excel
my sheet tabs sometimes disappears when I open excel. I know you can go through the start button and the advanced option to display the sheet tabs. Is there code I can incorporate so that on the opening of the excel file after the splash screen runs its course, the sheet tabs are displayed.
View Replies!
View Related
Macro That Deletes Sheet With Control & Shows UserForm Causes UserForm To Disappear
This is weird - if you delete a sheet that contained a control then a. showing a modeless userform resluts in a userofrm that goes invisible at subroutine End b. public variables lose their value These things do not happen if the sheet did not contain a control. Attached is an example file - put the inputfile.xls in your default file location (or add a path in the code) then open the ProblemDemo.xls and run the main macro to see it fal - isthis another Excelbug I've found?
View Replies!
View Related
Get Value From All Worksheets Enter On Summary Sheet
I have a workbook that has various number of worksheets at any time. Each worksheet has data about current employees. We can have anywhere between 20 and 50 employees at a time. When we get a new employee, we take the "template" worksheet, copy it, and rename it with the employee name. We also have a summary sheet. On the summary sheet we have the employee name in column "A" and the hire date in column "B" Each employee sheet is set up the same since we use the template. So the employee name is in cell "A6" and the date is in "I6". Is there a macro I can use that will update the summary page every time a worksheet is added or removed? I don't want the macro to run on its own - I want to make sure we can manually run it (after we are done entering data into the new sheet). So, basically, what I want to do is to search for all worksheets except "template" and "summary" and take the value in cells "A6" and "I6" and paste it in the "summary" sheet in cells "A3" and "B3" respectively, and then the next values from the next sheet into "A4" and "B4" and so on and so on. I have been experimenting with code all day, and started just trying to get the employee names copied over (cell A6) and can't do it so I haven't even tried the hire date yet (cell I6). I have tried probably 15 different codes but I guess I do not know what I am doing. The latest code I tried is.... Worksheets("Summary").Activate FirstCell = Worksheets("Summary").Range("A3") For Each Worksheet In Sheets If Worksheet.Name "Summary" Then ActiveSheet.Range("A6").Copy Destination:=Worksheets("Summary").Range(FirstCell + 1, 0) End If Next Worksheet End Sub It would be cool too if after all the values have been pasted into the "summary" sheet if I could sort alphabetically, but I don't want to push my luck.
View Replies!
View Related
To Enter Players Into Sheet 2 As They Are Picked
I am starting a new Fantasy Football League. I am wanting to be able to enter players into Sheet 2 as they are picked. And I am wanting those picks to be simultaneously placed on Sheets 3-14 according to their position. Sheet 1 is a list of names according to positions. A more detailed explanantion is entered below.....
View Replies!
View Related
Formula Disappear The Value
I have a formula in C5 = IF(C$1=$A$2,($J$3-B$4)/COUNTA(C$1:$J$1),"") the problem is, when I will copy the formula in C5 and paste it to D5, E5, F5, G5, H5, I5 & J5 respectively, the value will disappear. What should be my formula in order not to disappear the value? ABCDEFGHIJ108-Mar-0915-Mar-0922-Mar-0929-Mar-0905-Apr-0912-Apr-0919-Apr-0926-Apr-0903-May-09208-Mar-0914-Mar-0921-Mar-0928-Mar-0904-Apr-0911-Apr-0918-Apr-0925-Apr-0902-May-0909-May-093Planned Cumulative1204Actual Cumulative15Remaining Qty. per Wk14.88
View Replies!
View Related
{} Brackets Disappear
I have a formula {=IF(OR(D9=M4:S99),"m")} For instance This formula works But when i click in the cell to edit the formula the {} (at the beginning and end) disapear and the formula no longer works. If i add them back manually the formula still does not work. How can i edit these formulas without stopping them working.
View Replies!
View Related
Enter On One Sheet & Add Entry To All Sheets
I use the same number as a lookup value in several sheets(say 1-10). The number can only be changed in sheet 1, the others referring to it. So if you want to use a different value in say sheet 9 you have to return to sheet 1 and change it, then back to sheet 9. Is there any way that a number can be inputted into ANY of the sheets and change ALL of them, without using macros? I've searched long and hard for the solution to this, I'm sure it's either a trivial answer or a trivial question that doesn't deserve an answer.
View Replies!
View Related
Enter Current Date Into Last Used Row Of Column Of Another Sheet
From sheet1 on a checkbox click I am attempting to post the system date into sheet3 cell c3. If c3 already contains data then I want the cell selection to go down to the next row and post the date there. I if cell c3 has no data then it posts fine but if I need to goto the next row then I get a runtime error "object doesn't support this property or method". If Me.GCN = True Then If Not IsEmpty(Worksheets("GCN_Paid").Range("c3")) Then Sheets(3).ActiveCell.Offset(1, 0).Select Sheets(3).Range("c3") = Date Else Sheets(3).Range("c3") = Date End If End If
View Replies!
View Related
Make These Lines Disappear!!
I have an excel document that looks all nice and pretty except for the little white grids all over it with unused cells. Is there anyway to hide the lines? i dont care that the cells are there just the lines make the form look kinda crappy.
View Replies!
View Related
What Can Cause A Variable Type To Disappear
One of my workbooks won't allow me to use the VBE variable types (VBProject, VBComponent, etc.) They aren't on the popup list that appears when I type " as ". If I just type in "VBProject", I get a compile error "User-defined type not defined". I have to define the variable as object, and the macro still works. I do not have this problem in any other workbook.
View Replies!
View Related
Buttons Disappear On Some Machines
In recent weeks, when I've been asked to demonstrate excel applications which make use of buttons, I've found that on some machines the buttons will variably display as flat grey rectangles with no label, or boxes with red 'x's, or alternatively not appear at all. There seems to be no pattern since the variations have all happened on single machines, then not at all on similar machines. So far it has only been company laptops (not my own machine), hooked up to overhead projectors which end up with this problem. I can't think of anything I would have done manually to disable the buttons from appearing. Is this a known issue, or is this simply down to the user preferences and/or security settings?
View Replies!
View Related
Make The Message Box Disappear
before i run my macro, i would like a msg box that appears that says "please wait, this may take a while". I've tried using the msgbox function but unless the user presses the "OK" button on it, the macro won't run.... any suggestions on how i can have a userform/msgbox appear while the macro is working in the background (without the user having to press "ok")
View Replies!
View Related
The Value In The Field Should Not Disappear After Refreshing A File
I have got this in a pivot table Customer Total sales(USD) 30010 500.00 30041 2000.00 In another column I enter a comment for customer 30010(and leave the comment column for customer 30041 blank) as below Data 1.xls Customer Total sales(USD) Comment 30010 500.00 Test 1 30041 2000.00 Later on the content of the file changes as below: Customer Total sales(USD) 30025 1500.00 30010 500.00 30041 2000.00 When the file is refreshed I would like to have comment as per the former file i.e the comment “Test 1” should appear against customer 30010 and similarly for any other customer that I enter the comment.It should be as below: Customer Total sales(USD) Comment 30025 1500.00 30010 500.00 Test 1 Customer Total sales(USD) Comment 30041 2000.00
View Replies!
View Related
Grid Lines Disappear When Importing Data
I sometimes import data in the copy-paste way from completely different sources, eg. a program on the web or whatever, which has arranged the data in a table. It is often succesful with the data neatly arranged in the spreadsheet in columns and rows and all, but sometimes the gridlines disappear even though 'cell format' is set to 'none' in 'grid lines' and the settings have a mark for 'visible grid lines' and their color is 'automatic'. Only the imported area misses the gridlines. It is of course possible to set some grey gridlines manually in cell format, but then I get them on the print also and I don't want that.
View Replies!
View Related
MouseOver Cell That Makes Apear And Disappear An Image
I would like to do a routine in VBA on excel 2007 that makes the following: 1- When the mouse is over a cell it pops-up a window that shows a picture; 2- When the pointer is removed from the cell the window that contains the picture closes; It is very important that the picture that is shown be adressed by a relative path from the folder in which is the excel file. The pictures can change; this is the reason that the picture should be addressed by a path.
View Replies!
View Related
"Move After Enter" In Protected Sheet
I have a spreadsheet where only certain cells are to be edited by he user. After editing a cell I don't want the cursor to move. option/edit/move selection after enter is unchecked. All works as expected. I protect the sheet using options "select unprotected cells" is true, "Selected protected cells" is false. This seems to override the "move selection" turned off property. The option box does not work when unchecked. I have searched the general forum and programming forum and see no cure for this. I tried a one line macro "Application.MoveAfterReturn = False" thinking if I set it programmatically, it will work. It does not. Is there a few lines of code that I could add to a ThisWorkbook macro that would reocord the current cursor location and set location to it after hitting enter? Or possibly an even simpler solution that I'm overlooking?
View Replies!
View Related
ENTER = Activate?
In the following code, I have a find sub... when the user enters a date and hits the "Enter" key, is there a way to bypass the "Ok" key? Private Sub cmdFind_Click() Dim ws As Worksheet, myDate Dim rFoundDate As Range 'check for valid distribution date (between October 1, 2006 thru December 31, 2014) myDate = txtFindMyDate With myDate If DateValue(txtFindMyDate) < DateValue("10/1/2006") Or DateValue(txtFindMyDate) > DateValue("12/11/2014") Then MsgBox "Please enter a date between October 2006 and December 2014" .SetFocus Exit Sub End If End With Cells.Find(What:=txtFindMyDate, After:=ActiveCell, LookIn:=xlFormulas, _ LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False).Activate ActiveCell.Select Unload Me End Sub
View Replies!
View Related
How Do I Enter 005
I am writing a macro and using the filepath, it will change from 001 to 002 etc. I would use a ' but when it gets to 010 it goes wrong! is there a formula I can put in a cell that when typing 5 it results in 005?
View Replies!
View Related
Enter Vs Return
Im using an old IBM tb3270 mainframe as described in this historic post: [url] ive tried {ENTER}, ~, char(13), etc etc but every one of them is just going onto a new line! Anyone any ideas how to get it to send the enter fuction, from the keypad?
View Replies!
View Related
Creating New Sheet From Template Sheet & Filling In Summary Sheet - Userform
I have some experience with excel, but until now have not ventured into VBA and macros. I have a workbook which will have the following sheets: 1.Absence Summary sheet - Summarises data from each employee's individual sheet. 2. Template Sheet - A sheet formatted as an absence record sheet, but without data. 3. Individual employee Absence record sheets - Based on the Template sheet. I have read with interest the various posts and help files on User Forms & Macros, but have got a bit stuck. My Aim: ....
View Replies!
View Related
Textbox To Enter Value In Either Format
On the attached example i have a user form (click Add New Hedge button) and on this form is a textbox for 'Avg. Price'. The value of entered from this box will go into the next available row in column on 'Unsettled Hedges' worksheet. My problem is sometimes i would to enter the price as a fraction, e.g. 1/2 and other i would like to enter the price as a decimal, e.g. 1.5. At the moment if i enter the price as a decimal figure this will convert it to a fraction in column D of the 'unsettled hedges' worksheet. What do i need to change in my code to make it enter the price in either format?
View Replies!
View Related
Userform To Enter Data
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 Replies!
View Related
Enter System For The DF Part
In MS Query: Like '%ST%DF%' Works fine.and returns: DOCIDREVISION 31ST-9DF02007 40ST-9DF01006 73ST-9DF01016 74ST-9DF01011 74ST-9DF02004 I want to use the [Enter system] for the DF part. When I try to use the following in MS Query: Like '%ST' & [Enter Sys] & '%' the pop up window appears but after entering DF I receive an error: Missing Right parenthisis or illeagal variable?
View Replies!
View Related
Enter Formula Using A Macro
I am trying to write a macro which will get values from column B and C and print the result on column D using a simple function like the one before: D2 = "text" & B2 & "text2" & C2 & "text3" I need this to be done in the macro, so that when I click the button, it will automatically create column D. Column B is formula and column C is constants. I tried something like the one below:
View Replies!
View Related
Blink THE Cells WHEN ENTER THE VALUE
I have a doc which requires users to enter their info/request, BUT for whatever reason the users always seem to leave a cell/box empty and leaving me guessing Is there a way to make cells/boxes BLINK and once info/value is entered the cells/boxes will stop BLINKing
View Replies!
View Related
Disable Enter Button
When you push the enter button while in a cell it takes you to the next cell down. is there anyway to disable that.. or make it so when someone pushes the enter button it tabs to the right?
View Replies!
View Related
Enter A Valid Time
I have a textbox (on a userform) that populates into a spreadsheet. the way I have it set up the user enters a time, but omits the semicolon, and a macro adjusts the time to show the semi colon in the spreadsheet, that is working great. But what I would like to do is to use a textbox change event to force the user to enter a valid time using a 24 hour clock. I have the textbox set to accept numbers from 0 to 2400, using the textbox change event but this allows the user to enter an invalid time such as "1575" basically anthing above 59 for the last 2 digits would be invalid.
View Replies!
View Related
F2 + ENTER To Format Cells
I have some imported data that Excel does not recognize as date or time so I have to edit each cell pressing F2 and the enter to "convert" the value. I have about 120.000 records and the macro takes long time to do the job.
View Replies!
View Related
Handle The Enter Event
The code handles keydown, keypress events with no problem. Also similar change events, and probably more. This code is at UF initialize event: Option Explicit Dim TextBoxes() As New Class1 Dim ComboBoxes() As New Class1 Private Sub UserForm_Initialize() Dim TCount As Long, CCount As Long, c As Control TCount = 0 CCount = 0 'Set TabIndexCollection = New Collection For Each c In Me.Controls ' TabIndexCollection.Add c, CStr(c.TabIndex) If TypeOf c Is MSForms.TextBox Then................
View Replies!
View Related
About Array Formulas And How To Enter Them
I typed in the word array into Excel Help and found this item "About array formulas and how to enter them" I am trying to duplicate the first example and cannot Ex: =Average(if(C5:C14="Europe",D5:D14)) I tried something similar to this (diff cell ref) and I get #VALUE Do I need to check off an addin or something?
View Replies!
View Related
Enter Date Without Separators
I'd like to be able to enter a date in excel as just the characters without the dashes and have it correctly recognized -- such as 05142006 changes to 5/14/2006. I have a great deal of data to enter and it would go much faster if I could do it in this format. Is there a VBA script or function of excel that I could use for this? I've tried looking around on here a bit and in the program settings,
View Replies!
View Related
Open And Enter Commands
Is there any way that i could open and enter commands in ms dos controlling from excel vba code?, like, say i wanted to change the current directory in msdos from d: to c:, is there anyway that i could do it from excel vba?
View Replies!
View Related
Enter Date If Data Changes
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 Replies!
View Related
Way To Enter A Second Shell Command After The First One
I have written a Shell command. It is very simple and designed to open another software. Here it is: Dim X As StringX = Shell("C:Program FilesMicrosoft OfficeOFFICE11xlview.exe", vbNormal) Is there a command that will close the open program? Something along the lines of .....Ofice11xlview.CloseProgram", ... But more importantly, is there a way to enter a second shell command after the first one that will have XLViewer to open a particular workbook after the viewer is open?
View Replies!
View Related
Enter A Number From A Table
I am working on a spreadsheet and I want to enter a number from a table and have the associated values from the table transfer with the number into my spreadsheet. What functions and formulas should I use? (Below is the Table, the PTM# is the one I would query for.) X L/R Y PTM# 0.54R0.5820 0.82R0.5021 0.66R0.7322 0.06L0.2723 0.03R0.1324 0.55R0.2925
View Replies!
View Related
Auto Enter The Date
I would like to make a list of vehicles with auto servicing dates appearing in the next column. How can I do this, example would be say 30/11/2008 was the last service, next column would be next service due 30/02/ 2009 and then a column next to that to say when service was done. Pretty simple but I can't seem to get it to auto bring up the next service date which would be in 3 months time or 90 days.
View Replies!
View Related
Can't Enter Any Data
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 Replies!
View Related
Macro To F2 On A Cell And Enter
I am in need of an excel macro that will be able to let me F2 (edit cell) and then with whatever is in the cell (variable)-- press enter, repeat for a whole column of data.. I'm new to code-writing, so probably not complex..just not sure and any suggestions would be helpful. I will be receiving a data set and need to compare it to another data set, and they are not appearing identical because in one dataset the data has an enter afterwards, and not in the other.
View Replies!
View Related
Auto Enter Alphabet
Does anybody have a formula to use to auto enter an alphabet? With this formula I would like the last letter in the alphabet Z to be followed by AA, AB, etc. If I delete row 5 (letter E) I would need the letters to auto generate in order.
View Replies!
View Related
Enter Ending Date
In my sample workbook, (attached), all I want to do is up a formula in column E that compares values in columns A, B and C. If they are the same, I want to put the last year model in Column E. I have filled in the first 12 rows to whow the desired result. Ultimately, for each part number and model combination, I want to put the final year for that combination in column E. The sample workbook constains just a few rows, but my master has about 30,000 rows.
View Replies!
View Related
|
TRACKER
