I'm looking to set up a table in Excel (or possibly Access that is then referenced through Excel). But end goal would be to be able to type in an Item Number and then Excel automatically fills in the Description, weight, price and other information about that item number. That way, I don't have to type in "11108.1" and "Computer Mouse" and "$15.98". I want to only type in "11108.1" and it knows to fill in the other information. Is this possible in Excel? I've searched through many functions and haven't found it so I'm thinking it may require a combination of formulas.
Is there anyway to automatically fill the empty added cell after inserting a row without using the fill handle? For example, for a series of numbers: [URL]
2. Drag the fill handle Selected cell with fill handle across the range that you want to fill.
Or running balance: [URL]
2. Extend the running balance formula into the new rows by selecting the last cell in the balance column and then double-clicking the fill handle.
I have a excel based timesheet that looks at an external table named "Station Master" to populate columns from a vlookup. I have recently linked the Station Master to a database to populate it. From the database we may change status so that the project does not show up in the station master anymore to make sure complete projects are not getting hours charged anymore. Now if a project that was on the master goes away previous timesheets lose the correct description because it is not on the station master anymore.
My question is there anyway to make the previous data lock so the data that is in the cells won't change when the station master changes.
A little more info... the time sheets are by quarter so 12 weeks are in the same workbook as individual worksheets. All of those worksheets vlookup to a worksheet called "projects" inside the workbook. Then that worksheet references the external Station Master workbook.
I need it to autofill just as if you selected range A1 and A2 and double clicked that little square on the bottom right hand side of the cell (so it stopps auto-filling at the last active cell in B)
I currently have this code ( which works perfect ) that was written by someone else. It performs an auto-fill in column "A".
I need to learn how to adjust this code to do it for other columns, but do not know currently.
Maybe someone could highlight of BOLD the adjustments to direct the code to the column.
Sub fill_rows_A_4() Dim arrTmp As Variant Dim lngRow As Long With Worksheets("sheet1") 'adapt arrTmp = .Range(.Cells(1, 1), .Cells(.Rows.Count, 1).End(xlUp)) For lngRow = 1 To UBound(arrTmp) If arrTmp(lngRow, 1) = "" Then arrTmp(lngRow, 1) = arrTmp(lngRow - 1, 1) Next .Range(.Cells(1, 1), .Cells(UBound(arrTmp), 1)) = arrTmp End With End Sub
If you have a data in two dimensional table. and you need to fill each cell with the value returned from another table.
Example : this the my table
Company A Compay B Company C Product 1 Product 2 Product 3 Product 4
and this my data :
Products Companies Price Product 1 Company 8 Product 1 Company A 7 Product 1 Company B 5 Product 1 Company C 6 Product 2 Company B 6 Product 2 Company C 9 Product 3 Company A 10 Product 3 Company B 8.8
I currently have a table with a range of headings (row & column), and the necessary data for it. On a new worksheet, I have a table with only a few of the headings, and I was wondering if there was a macro that would automaticlly match the headings of the new sheet with the other table, and fill in the ncessary dat, as on the other sheet.
Working with 2 worksheets in the same spreadsheet. In worksheet A cell F6 is a solution (hex2dec) these solutions are staggered consistently in column F (F6, F9, F12, F15 etc) In worksheet B cell A2 displays workshop A cell F6 details (=ATR!F6) Worksheet B cell A3 Autofil uses (=ATR!F7) I want (=ATR!F9) Worksheet B cell A4 I want (=ATR!F12) How do I condition autofil to follow my chosen sequence ie F6,F9,F12,F15 etc...
when I fill the information into column B on pages 1-31 I would like it to refer to the location names from the loc-mileage sheet and fill in the suggested name as i'm typing.
I thought about doing a drop down but the list is too long and I dont want it to be set to only use the list names, only suggest names from the list.
I need to auto fill quarters but Excel fills years instead. For example I write Q1-11 in cell A1 and when dragging down it fills with Q1-12 rather than Q2-11.
I am trying to figure out how to auto-fill a range. I am summing a range from one tab to another, like A1:A5. I want to autofill the subsequent cells to begin with the cell that follows the last of the previous range, so it would autofill as A1:A5, A6:10, A11:15, etc. how to do this?
I have a macro set up to automatically fill all of the cells in certain columns with the top cell's formula in that column. This is so I don't have to go through and manually "fill down" the formulas into the blank cells after I insert a row into my database. The problems is, though, that the macro sometimes takes a long a** time to run (and uses up a TON of memory...the doc. was 29,000 kb at one point!) because of the amount of rows & columns I have (approx. 5000 row & 34 columns) just one one sheet.
Anyway, is there a way to set up something in VBA to have it auto fill in the formulas in the columns I choose, after I insert a row, with the information that preceeds it?
So, for example, if I insert a row anywhere in my database, excel will know right away that I want that row filled w/ the formulas from the row above it.
I created a database and made one small mistake doing it. The database is infinite amount of rows down and my formula needs to be corrected as such. In the current cells: (C1:C1000) i have the formulas referencing cells $B1, but i need it to reference $B$1. In C2 I need it to reference $B$2, C3 $B$3 and so on. If I autofill, it obviously just keeps the following cells at $B$1 and i can't keep the dollar bill sign.
I need to be able to click on a box and have it fil that box with a check, X, or other fill and have that fill go away if I click on that box again. Can I do that?
I use this code to start at the the top of the column going down, but the way my data is setup, I need it to start at the bottom and work up.
Sub fillBlanksI() 'Declare variables Dim FR As Long, LR As Long, i As Long, FillVal As Variant 'Stop screen flicker and speed up code Application.ScreenUpdating = False 'Find the last row of any column in the sheet LR = ActiveSheet.UsedRange.Rows.Count 'Loop from row i downwards until we find a value - this is the first filled row and assign its value to FillVal
my macro simply activates a cell and all i want it to do is to auto fill downwards! its intended to autofill down for about 100 rows but just cant figure it out!
but keep in mind the cell is always going to change so it cant be fixed
i have just finished filling out a 2000 line spreadsheet, on this spread sheet i had a customer number i then had to look up the customer number on our old database to retrieve the address for the customer. Is there any way that for future spreadsheet's i can input the customer number and it will auto fill the address of that customer ?
the columns on my sheet are: customer A/C number Customer Name Customer Address line 1 Customer Address line 2 Customer Address line 3 Postcode
it would save me hours and hours of time digging through the database again.
I have a spread sheet which tracks work we do on certain items. These items (about 200 of them) consist of a 3 or 4 number tracking code (they are all 4 numbers, but some have leading 0's.) This tracking code is entered into Column B and when we cross reference the number to a chart we have we can determine if item is either, "model A," or, "model B."
I want to get rid of that cross reference chart, or rather, I want excel to cross reference for me and automatically fill A or B into Column C, right next to the tracking code.
Is this possible without VBA? It seems like it may be something simple, but i've poked around and have done nothing but make a mess.
I'm trying to set up a multi page report where some of the same information is repeated into a several forms. Is there a way I can set this up to where I type it into the one section and it will auto fill into the other pages I need the same information?
I have created a table in Excel 2010 (pls see attached table named post.xlsx).
Then copied the above table into PowerPoint 2010, using "paste link" (I tried to attach the PowerPoint file but the system says "invalid file type" and I cannot attach it).
Question:
I have received income data for another month - the new month is 13 and the corresponding new income is 100. I typed 13 and 100 into the Excel table post.xlsx and thus extended the table by another column.
Then I went back to PowerPoint slide, then right clicked on the table there, then clicked "update link".
Specific Question:
The newly-typed column in Excel table is not get updated in PowerPoint table.
