I am trying to make a really simple database. Basically, in the first column the user will input the manufacturer, then the rest of the information on that row. I want to setup a formula I guess that would read that name in the first column, then copy all that information in that row to a specific sheet.
2007-02-01 05:14:25 · 7 answers · asked by crutchduck 3 in Computers & Internet ➔ Software
go to the specific sheet and have it equal the first column, and example would be row a column d =A1
2007-02-01 05:20:37 · answer #1 · answered by martin 4 · 0⤊ 1⤋
1
2017-01-21 17:52:06 · answer #2 · answered by Christian 4 · 0⤊ 0⤋
use a VLOOKUP formula. Excel will walk you through setting it up.
Set your first field to the cell you want to reference.
Set the next field to your data table. (In your case, the sheet containing the information about manufacturers. Be sure to set the range as the entire area your data is in. I usually highlight the whole sheet.
Set the 3rd field as the number column you want to pull from. (column a=1, column b=2, c=3, ect)
Set the last field as "false" This will pull the value from the sheet you are referencing. If you don't have data for that character, it will pull an errror message.
I'm not good at explaining but that's a simple one to do. Play around with it and you'll figure it out.
2007-02-01 05:24:13 · answer #3 · answered by chikkenbone 3 · 0⤊ 0⤋
Use Excel formulas to copy rows while copying across columns ...This ensures that Range A1 on each sheet has a different name. ... Over 100! All with full money back guarantee and free copy of Excel 33 Workbook Downloads ...
www.ozgrid.com/News/excel-copy-rows.htm - 43k - Cached - Similar pages
Excel Lookup functions, Vlookup, Match, Index. VBA Find Method ...Delete Column "A" and with Row 1 selected go to Edit>Replace and Replace # with = ... To do this, first select the sheet, then right click on the sheet name ...
www.ozgrid.com/News/LookUpPart2.htm - 47k - Cached - Similar pages
2007-02-01 05:18:29 · answer #4 · answered by god knows and sees else Yahoo 6 · 0⤊ 1⤋
I know this does not answer your question. But you are not making a database, you are still making a spreadsheet. Try using access or a different database system.
If you really want to use a spreadsheet like you are now there are several programs that streamline this for you. One of the guys suggested on.
2007-02-01 05:24:25 · answer #5 · answered by w2pc.com 3 · 0⤊ 0⤋
I haven't used Excel in a while, but cant you simply just select your range, then copy, paste? If you have problems with the format, there is a little on screen thing, you can restore all the original text formating. yeah.
2016-03-15 03:26:19 · answer #6 · answered by ? 4 · 0⤊ 0⤋
kind of vague...try googling some pertanent descriptive phrases related to your dilema in quotes - there is alot of specific help on the web
google "excel forum"
2007-02-01 05:18:44 · answer #7 · answered by (_)iiiiD 4 · 0⤊ 1⤋