Inputting Information To Appear In Another Cell?
Feb 4, 2012How to input information into one cell and it appears in another cell based on specific information inputted.
View 3 RepliesHow to input information into one cell and it appears in another cell based on specific information inputted.
View 3 Replieson sheet1 which is called working sheet and cell d25 is asking what type of goods been sold
i have several different sorts"
ie
s25
s28
s50
s69
s70
s82
abd
t70
t140
i want the spreadsheet to look up somewhere on a sheet called delivery all the components that could be used for that type
so i guess i need to name define?
ie if s25 is selected
on delivery sheet in a20 it would then list all the components underneath each other.
I am trying to make excel list in a column like 1,2,3,4,5. this is dependant on a value i place in one cell eg 5
i want excel to then place 1,2,3,4,5 in seperate cells down a column. does this make sense.
then the calculations will only appear the the numbered cells.
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.
cell a1 has yes cell b1 has yes and i want to type yes in c1 that will change a1 and b1 automatically to a blank cell
View 3 Replies View RelatedI want to create a macro or formula for changing the colour of the cell after half an hour of inputting.
View 3 Replies View RelatedI have a worksheet in which i am asking a user to enter manually a number in cell E3. Suppose the user starts with 100, then the next time he is entering in E3 he shoudnt be able to enter 100 nor any number less than 100. I dont have a range for the numbers that the user is going to enter.Therefore countif function does not work. Is there any way that i an store the number taht the user enters first in cell E3 and then use that database to avoid the user from entering the same or a number lesser than that number.????
View 2 Replies View RelatedI have a question to ask, and not sure what you would call it. I am looking to input a 'Check Box' into a cell so you could have for example... two (2) choices - Yes - No - you would have an empty circle in front of each, and you select the one (1) you wish which would make it filled.
Is there a way to do this in excel? If there is, could someone possibly turn me in the right direction (or assistance) with inputting this?
I've just been asked to do a new Quality Control project for my boss. What I'm looking to do is be able to input the thickness values of our product in one worksheet, and have it recorded in another, as well as have the data separated by the model number
The main problem I'm having is figuring out how to enter data in the 1 worksheet as a template, and have the data consecutively stored, one after the other
Are there any functions that will allow me to do this?
way to 'insert' a formula into a specific range of cells using VBA only when the Value of $A$7 is changed to a value that does NOT equal "Custom".
Heres what I have so far using Worksheet change event....
I discovered this sample database sheet (attached) on the forum I wanted to ask if a picture can be linked included? i.e. when entering a new record a picture (stored in a directory) can be added and linked to that record. Then when reviewing the records the picture is then displayed.
View 6 Replies View Relatedfor example.
I type "20 Feb 07", and excel formatting auto changes that to "Tuesday 20 Feb 07"
I actualy need this for a more complex formula...
if A1= any date from monday to sunday of one week, then A2= mondays date+21
the only way i can comprehend this is to make a formula that says if A1= a monday A2=date+21, A1= a tuesday A2=date+20, etc.
I have some code that works fine below. It deletes an entire row based on the value in column J.
Ideally I would like to give the user the option to choose which column to base the deletion on. i.e. some kind of drop down box or input parameter where they could choose a different column "A", "B", "C" etc...
Private Sub CommandButton1_Click()
'Removes values less than 0
Dim rng As Range, cell As Range, del As Range
Set rng = Intersect(Range("J1:J1000"), ActiveSheet.UsedRange)
For Each cell In rng
If (cell.Value)
I have a sheet with a number of different columns, is there a way that when data is input into a cell in the first column that it time stamps the last column on the same row, and this time stamp is fixed. Then when data is input into the cell below the same thing happens, so i can have a time stamp for each entry.
View 9 Replies View RelatedI have a worksheet with 500 rows. Coulmn A is all the dates of the items. Is it possible to somehow havea userform or something that I input a start date and a finish date and it only shows me that info.?
View 2 Replies View Relatedi m making a very small calculator. It's a little hard to describe, but I need to look like the following
Let's say the individual got here on 1 Jan
Phase 1 is for days 1-14 last for 14 days
Phase 2 is for Day 15-35 last for 21 days
Phase 3 is day 36+
This is what I need it to look like: All the phase information will compute automatically after inputting the date arrived. In addition I would also like to be able to change one of the phase dates and the remainder of the phases compensate according to the newly entered date.
Date Arrived = 01 Jan 09
Phase 1 = 01jan09
Phase 2 = 04Feb09
Phase 3 = 05 Feb09
Any existing UDF that will take two ranges of Prices (for stocks) but get their respective returns to then get the correlation of that?
View 4 Replies View Relatedi have 1 - 9 number buttons, the +, - , * , / , and a C for clear, as well as an exit button. the display is a label. i have to click add after inputting the digits just to have it added to he variable, which i just add up at the end... terrible.
Option Compare Database
Option Explicit
Dim var1 As String
Dim var2 As String
Dim first As String
Dim second As String
Dim sign As String
' on load
Private Sub form_load()
Form.Caption = "this calculator lab sucks."
Me.lbDisplay.Caption = ""
End Sub
' on clear
Private Sub cmdClear_Click()
Me.lbDisplay.Caption = ""
var1 = ""
var2 = ""
End Sub.............
I am looking for Macro code preferably to get list of dates with Saturday / Sunday in a separate columns which falls Saturday and Sunday on imputing the year.
View 5 Replies View RelatedExcel 2007. At the bottom of a column of data I'm trying to reference the cell $AG4. There are 340 total columns. Each additional column to the right needs to reference the next cell in column AG. So I'm trying to drag and copy horizontally from $AG4 to $AG340. When I try just the single column it just copies $AG4 into everything to the right. When I have to columns ($AG4 and $AG5) and grab both to try to copy horizontally the numbers increasing it just does $AG4, $AG5, $AG4, $AG5, etc.
View 2 Replies View RelatedIs it possible to create a drop down menu where additional information can be added then tallied up in a separate table?
I would like to create a menu representing "tasks" where an amount of "time" can be designated per menu for my employees to select and fill. I would like this information to then be tallied elsewhere so I can keep track of our efficiency.
I've attached the excel file to give a better idea of what I'm trying to accomplish.
I have created a userform that allows input of information and then deposits the information on a specific sheet. I am looking for a way to have that information not only deposited on the specific sheet it is already set to but also to another sheet based on a selection made from a combo box.
here is my current
Basically I am trying to create a worksheet in which everytime I input information into Sheet 1, it is copied into Sheet 2. I want to have each entry in succession on Sheet 2 such that my first entry would be on Row 2, second on Row 3, third on Row 4, etc. However, everytime I put something new in Sheet 1, it just overrides the information in Sheet 2.
Basically I type in ticket sales in sheet 1, it calculates the prices and keeps a transaction log in sheet 2. But everytime I do a new ticket sale, it just overwrites the previous transaction witht he new transaction information. I've pasted my VBA below:
Sheet 1 VBA:
Code:
Option Explicit
'Form level variables - used in more than one event
Dim intAdult As Integer
Dim intStudentSenior As Integer
Dim intBalcony As Integer
Dim intChild As Integer
Dim sngAmountDue As Single
[Code] .......
Sheet 2 code:
Private Sub cmdSummary_Click()
'Declare Variables
Dim intCount As Integer
Dim i As Integer
Dim intAdult As Integer
Dim intStudentSenior As Integer
[Code] ......
I have a Formula question which I can't seem to figure out. I want to set a cell so that when two other cells are above 80 then the cell is green.
If one of the two cells is bellow 80, the cell turns to yellow and if both are bellow 80 then the cell is yellow.
I have a cell that has data like the following: ab 4111 / nw 2652 / ev 8741 up to 5 or 6 entries in the cell. If I just want 1 of these entries say the ev 8741 how can I have that be the only data that remains in the cell?
View 9 Replies View RelatedI'm trying to build a macro that copies the information from cell D2 and then special pastes it into the next free cell on that specific row (as the information is from a vlookup so don't want to paste the formula) - ideally I'd like it to paste from H2 onwards but can move the spreadsheet around if that's not possible! I'd then like to do this for every row until there is no data in a row.
I've been using the below which I've found on the internet but this only pastes into column H and then just goes down the column rather than across the row, and I can't figure out how to do this.
Sub Summarize()
Range("D2:D25").Select
Selection.Copy
Sheets("Pot 2").Select
lMaxRows = Cells(Rows.Count, "H").End(xlUp).Row
Range("H" & lMaxRows + 1).Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Range("D25").Select
End Sub
I have spread sheet with 2 tabs (MASTER LIST & CYCLE COUNTS), on each tab I have 2 columns(LOCATION1 & DATE1 and LOCATION2 & DATE2) I need to verify if I any cell from LOCATION1 is repetead on LOCATION2 and copy the informacion from DATE2 to DATE1. then if I update the CYCLE COUNTS sheet I want the MASTER LIST update by it self.
This is the formula that Im using but Im having problems with the range..... =if('Master list'!$A2$:$A$15000='Cycle counts'!$A2:$A$15000, 'Cycle counts'$B&2:&B&15000,0)
I have this information available.
test.png
And what I want to do is use this information further down in my excel-sheet. So whenever I plot in "Location 1" I want "Security" and "John Johnson" to magically come automatically.
Like this : test.png
how do i separate information like this:-
01/08/2007,09:54:27,27.05,27.06,27.05,361300
let say its in cell A1 & i want first information before the First , to appear in B1 which is 01/08/2007
then the information before the second , to appear in C1 which is 09:54:27
and so on
I have several thousand cells where I need to pull out some information at the end of each cell. So for the examples listed below, all the information resides in the "A" column. For example:
M55116/14-5 CONN,RECEPT,6 PIN,U-228 TYPE B EA A AS 17 85.00 1,445.00
M39029/30-222 CONTACT,#0,RED-RED-RED B EA A AS 96-0327 46 6.75 310.50
M39029/44-288 CONTACT B EA A AS 93-0852 400 2.18 872.00
I am trying to pull off (starting from the end) all of the information to the first space. So I would like the following results returned: 1,445.00, 310.50, and 872.00. Can anyone recommend if there is a Function or equation that I could use that would pull everything from the end of the cell until the first space?