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
ADVERTISEMENT
Jan 28, 2013
i have two entries in my excel sheet which i want to get noted in the other cell as follow
A B
1 ORDER NO. 480
2 GOODS 5
3 P.M 480X5
as my table have data in B1 AND B2 so i want B3 automatically becomes 480X5 so how can i do it
View 2 Replies
View Related
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
Mar 1, 2014
I am caught in an areas where I have learned how to find the next available empty row by going far down my worksheet, counting up until I reach a filled row and then offsetting that value by 1 as seen here below:
NextRow = Sheet1.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row
My difficulty lies in assigning the cells in this empty row the data a user can input in my text boxes; let's say there are 4 text boxes which need to be put into the following cells:
Text box 1 (Text value) needs to be assigned next empy cell in column: AText box 2 (Text value) needs to be assigned next empy cell in column: B (1 offset away from A)Text box 3 (Numeric value) needs to be assigned next empy cell in column: F (5 offsets away from A)Text box 4 (Numeric value) needs to be assigned next empy cell in column: H (7 offsets away from A).
How would I go about using my identified "NextRow" and then plug in these text box values into their appropriate cells down that row?
View 6 Replies
View Related
Oct 12, 2012
Margo
12/12/86
188478007
7/19/12
801
Anthem BC/BS
Margo
12/12/86
188478007
7/31/12
806
Anthem BC/BS
[Code] .......
I have this info on my excel spreadsheet plus 500 more lines. What I am looking for is if a name repeats then the info in column 2, 3, 5 and 6 for that name needs to be brought to new row. Example would be if I used the name karen on the next row then I would like her info from the desired cells to auto populate so I don't have to keep entering them and so on with new and old names. I have been trying to get this done for months know and have had no luck. My sheet already has over 500 lines of names and it would be nice if I could use the data from the past as well as the future to populate these cells.
View 5 Replies
View Related
Jan 23, 2014
In earlier versions if I used the double clicked the autofill handle it would only fill down to the next adjacent cell containing data. Now it fills down to the bottom of all the data regardless of whether there is a blank cell or not e.g
X X X Z
X X X Z
X X X Z
X X
X X X
Now this happens
X X X Z
X X X Z
X X X Z
X X ...Z
X X X Z
How can I stop this as I need to enter different data in the next section?
View 1 Replies
View Related
Aug 14, 2009
I have a problem - I wanna to mark (to colour) just cells which I use in formula is there any option for thise
If I have some table and I have formula =A1+B5+C7 I wana to colour just mentioned cells
View 9 Replies
View Related
Sep 4, 2007
I have a macro that's supposed to update the value in column 1 when two conditions are met. Unfortunately it doesn't update the column at all:
Sheets("All_Records").Select
Dim item, rownum, maxrownum As Integer
Application. ScreenUpdating = False
maxrownum = Range("A2000").End(xlUp).Row
For rownum = 2 To maxrownum
If (Cells(rownum, 1).Value = "=") & (Cells(rownum, 29).Value = "OPEN") Then
With Cells(rownum, 1)
.Value = "APPROVED TRIAL"
End With
End If
Next rownum
End Sub
I took the code from another spreadsheet I have where it works fine. But there only one condition has to be met before the field is updated.
View 4 Replies
View Related
Dec 16, 2007
I have 2 lists in column A and column B. For each cell in column B, I want to put a "YES" in the corresponding cell in column C if the contents (of the cell in column B) are somewhere in the entire list under column A (I think the list in both columns is about 5000+).
I have logged in after quite a gap and found that all my subscribed threads (gathered over a year) have vanished
View 3 Replies
View Related
Feb 22, 2008
Column-A starts out empty.A user changes cell B5 and navigates to another cell (whether by clicking, tabbing, or enter-key, it doesn't matter).An "X" is placed in Column-A for that row.Preferably the user would then be taken to the cell they were navigating to (whether by mouse-click, tabbing, or the enter-key).This happens every time a change is made to a cell.I have no idea how to code for this.
I'm not sure what constraints I might have for exceptions. For instance, can it handle multiple row being pasted into or cleared at once, etc. ( Deleting columns will not be allowed in this instance.)
------------------------------------
ADDENDUM:
I continued my search and found the instructions at [url]
My ultimate goal in putting an "X" in Column-A is to identify rows with changes, so they can then be copied into an "archive" worksheet. I'm thinking this VBA version of track changes would be much better than what I was earlier thinking.
I have a workbook with two worksheets, Data and Archives. I want to let a user make changes to data in the "Data" worksheet. Then when they save or press a button all rows with edits will be copied into the "Archives" worksheet.
Appending date/time and username stamps in the trailing columns would be very handy too.
View 9 Replies
View Related
Feb 15, 2010
look at the attached file. This might be the perfect job for a macro. I am trying to find the SKU's from sheet 1 in sheet 2 and subsequently mark the matching SKUs in sheet 2. Ideally, I would like the SKU's that could not be found to be set to Quantity "0"
View 2 Replies
View Related
Mar 12, 2014
I have a column of values, and I want a column next to it that shows the value in every second cell in the first column, but right underneath. See below for an example of what I am trying to achieve. The actual column is 17000 cells so I cant do it manually.
12
24
36
48
510
612
7
8
9
10
View 5 Replies
View Related
Sep 3, 2013
I want the user of my excel sheet to define a certain area For example range 1:
In cell A1 he enters = 5
In cell B1 he enters 10
Beginning with C1 excel should colour the cells C1, D1,...,H1, because the area has the lenght of 6. Colour could be yellow.
For range 2:
The same in the cells A2, B2, ...
View 9 Replies
View Related
Jan 29, 2010
I am adding a sheet with a graph I made. There are two sheets, the first with the graph, the second with tables. What I would like to do is populate the graph based off what is entered into the tables. My main goal is to get the cells in the cells in the graph for each day to fill in color between the given time frame entered in on the table. Obviously I would be rounding up or down to make the time end in ":00."
The color I would like to fill the graph with is shown on the graph sheet. Also, if anyone can actually get this to work (I honestly wouldn't know where to start) Is there a way to have multiple colors and a possible overlay of colors?
Lets say on tuesday I have 10:00-15:00, and 12:00-18:00. Can I have two colors populate the cells and a thirs color populate the cells in the overlay which would be 12:00-15:00?
View 4 Replies
View Related
Nov 19, 2007
the code of how do stop saving a report if the spefic cells are not filled.
For ex: In a excel sheet in we have A1,A2,A3 there should be some values else its should not save and should show an alert stating that this cell is empty....
View 9 Replies
View Related
Apr 23, 2008
I have an excel sheet which has a macro which captures the current time in a cell with the formula =now(). What I am looking for is that once a user runs a macro and the time is inserted into that cell then that cell should be locked and cannot be changed then. If this can be done by any formula / function or VBA.
View 2 Replies
View Related
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
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
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
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
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
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
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
Aug 29, 2008
I'm trying to find a macro that will copy data from the areas of B120:E179 and I120:K179 for example (linked to another worksheet within the workbook) and special paste (Values Only and skipping blank cells) it to the next available open cell up top where basic data entry will be taking place B10:E29 and I10:K29. I need it to only copy/paste the rows with data (skipping all cells/rows with no data) and once it is finished coping I will need it to place an "X" in column M next to the row that it copied data from. I would also need it to reference the data in each row from B to E and if there is an entry say on B14 to E14 that matches it but if I10 to E29 are blank then paste that information on row 14. If it does not match or if those columns are full then paste on next available line.
I hope I'm making sense here. This is for a vehicle tracking log between checkpoints. Each driver and info will be listed on each row. Columns B through E will contain information for each driver: name, badge, #passengers, and vehicle #. The log lists location, time, and destination for outgoing travelers in columns F to H. Incoming info is listed on Columns I to K............
View 4 Replies
View Related
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
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
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
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
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
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
