Linking Columns In Excel Together
Jul 18, 2014
I have a list of countries in excel and a list of partner countries, the countries all have individual country codes.
Example:
country partner country exporter country code importer country code year value
Australia..........Belgium........................AUS.........................BEL..1999..1000
Canada............Belgium........................CAN.........................BEL..1999..2000
This for a long list of countries, I have filled in the country codes for the first year manually but the list goes on to 2008 and is a lot of work to do manually, (thousands of cells). is there a way to complete the list of exporter and importer codes linked to the country and partner country column and then complete the whole list?
View 1 Replies
ADVERTISEMENT
Jul 17, 2014
I have a table in sheet1 in excel containing 10 rows. I want to copy the first column of this table into sheet2 in the same workbook but what I want is that in case I inserted a row or more in Sheet1, I wanted to be copied to sheet2 automatically. How can I do this?
View 1 Replies
View Related
Mar 3, 2014
It's quite easy, I am trying to do a droplist (that's easy) but I want that drop list to take infos on 2 different columns and fill the 2 columns I want in the main sheet (see attachment)
On tab 'dealers' I have dealers name and account numbers. On tab 'Mileage' I have a cell call "NAME' and a cell call 'Accnt #/NB'. Here is what I want to do:
On sheet 'Mileage' I want to choose from a drop list a dealer name and I want Excel to populate the cell "Accnt#/NB" automatically by chosing the account number that is appropriate to the dealer choosen which is column 'B' in the dealers tab.
View 2 Replies
View Related
Jun 28, 2014
I am working with two spread sheets; one is my take-off/summary sheet which is where I populate all the data for the project I am working on, the second sheet is also a summary sheet but it has also other functions; hence, I need to have two spread sheets.
I need to link/reference the data I have on my take-off sheet row 119, column K through ACL (lots of columns) to my other sheet but it now needs to be referenced in a column direction. At first, I enter = (sign) in T9 (the sheet I need to bring the data in) and then I go to the take-off sheet select N119 and hit enter, this first data is good, but then I try to drag it down to populate all the data from the other sheet but even though I lock the row (N$119) and let N free the formula doesn't populate this: =!N$119, =!O$119, ='!P$119 and so on so for...all what it gives me is =!N$119 all the way down...
View 13 Replies
View Related
May 6, 2014
I have an excel that gets updated monthly for reporting. The goal is to get the graphs to update automatically by linking them from excel into power point. This is relatively easy but what when I go to update the report for the next month the data for the old power point changes as well. Is there a way to prevent this?
View 1 Replies
View Related
Dec 29, 2006
I have two issues with an excel graph to automate it.
My first problem is that I have to manually select the source data when the data changes inside my spreadsheet. I have 35 slots that represent a 5 week period. Because the first day of the month does not always start on the first day of the week, I have to allow the extra 5 slots in my template. I have the cells set to show blank when there is no data entered in certain cells. Therefore, only days that the machine is up gets put into the 35 cell table. When I do this, the blank cells show up as 0 on the graph and it skews the line. I need some solution that will allow me to tell the graph to ignore zeros.
The second issue is the title in my graph. I have a set title, but need it to pull "Month Year" and "c81" from the worksheet it is on. I cannot seem to get it to populate automatically in the label. I would like it to look like the following:
614 Machine Uptime Percentage
%Month Year%
MTD PCT (%c81%)
where the %name% is the automatically populated item. I don't necessarily have a problem with hiding a cell and linking the label to that cell inside the graph, but I need it to change those two items automatically.
Im certain that a resolution to both of these items exist and I am certain it is an easy thing that I will be kicking myself in the rear over once I find out the resolution, but I need to get this done and im tired of wasting time. I hope this makes sense. If you need me to post an excel file as an example, I will be more than happy to.
View 14 Replies
View Related
May 18, 2013
How do i do the automatic linking on the excel sheet like the one done on the following example
Book1.xlsx
View 1 Replies
View Related
Dec 1, 2011
I know that I can import data from access into excel. What I am looking for is a way to have the data linked so that any time that a change is made in access, that change will be reflected on my Excel worksheet.
View 1 Replies
View Related
Mar 27, 2012
I am creating a Payroll Database. It is nearly complete except for the federal and state withholding tax data. I want my db to look up the data which I have saved in an excel workbook. I need the lookup to be for marital status and # of exemptions. There are a total of two variables for each table. 1. How much the gross pay is (ex. between $175-185) and # of exemptions (ex. 3 exemptions).
View 2 Replies
View Related
Oct 14, 2012
I am making a spreadsheet which would have the record of the audit that i am doing on my patients. Along with other details i want to give link of the routine followups of their disease picture in their specific spreadsheet cell. I have searched the internet about it where i have come to know about hyperlinking. However, my concern about hyperlinking is that i want the spreadsheet with pictures to be portable to other PCs which wouldn't be possible with hyperlinking. Also including the pictures in the spreadsheet would be very troublesome as the size would enormously increase once the data continues to grow.I want to include photos in column L, R, V, Z & AD.
View 3 Replies
View Related
Sep 13, 2012
I have a name list on sheet2, column A that will have names added to and removed from. Everytime this list is modified it sorts in ascending order and creates a new sheet named after the name added. These items are added to an ActiveX combo box on sheet1. I need to know how to link the item in the combo box to the corresponding sheet(ex: item: "Jim", sheet name: "Jim").
View 2 Replies
View Related
Feb 18, 2013
I am using an excel spread sheet as a larger display on a huge projected screen with numbers at a large charity event. It is a reverse raffle, so as your name is called you are out of the raffle. I would like to link the cell to a specific powerpoint slide which has the name and town of the specific ticket buyer. When double clicking on the cell listing their number the ticket buyers name and town would appear as a powerpoint a window in the middlle of the excel screen for all to see and then disappear after a few seconds or disappear when the next cell is double clicked. putting excel data into powerpoint slldes but not the other way around!
View 7 Replies
View Related
Jan 6, 2014
I want to link a table to a form. Only, I noticed that when setting the input range in the form I'm unable to use OFFSET OR a table name. How can I link the form to a list which is going to expand?
Attached is an example. Two sheets. One for the list. One for the form. The list will keep getting added to.
Unrelated-but perhaps useful - Is it possible to link one cell to a list in another sheet so a user can type in a word and it will offer autocomplete options in excel 2007 ?
linklistoform.xlsx
View 1 Replies
View Related
Jul 27, 2014
I have a number of separate worksheets in one spreadsheet all based on the same list (eg customers); the customer's name is the first column and hence the 'key' in each worksheet; when I insert or delete a line in the main worksheet the formulae in the first (customer name) column are amended in the other worksheets BUT I ideally need more than that; when I insert a new customer in the first (main worksheet) I need a new line with that customer name inserting into the corresponding place in the other worksheets; and when I move a line (eg delete a customer and move them to the bottom of the main worksheet list) I need the corresponding lines in the other worksheets moving as well. I guess what I really need is a drill-down function; a main customer list and sub-lists all linking back to the main lists like you would get in database tables.
View 5 Replies
View Related
Dec 20, 2012
I have two excel sheets, one has partial information (displayName, title, company, streetAddress, city, state, postalCode, Pager, homephone, fax) the other has the missing information that I need on the first sheet.
Sheet 1 (DB1, has partial info) and Sheet 2 (DB2, has the missing info). I need to somehow link these two, and what they both have in common is name. DB1 has "displayName" which is just First Name Last Name (e.g. John Smith). DB2 has First Name and Last Name, but i'll concatenate that to a new column named "displayName" ( which I assume will be needed to link? ).
The missing information in DB1 is title / streetAddress / city / postal code. DB2 has "Location" (which is a company code, and I want to replace the code with the address, city, postal code) and "Group" (which is title).
To make it easier, I could just do a find and replace on DB2 (e.g. A01-DFW-HWY67) and do it that way right? Or is there any easier way to do that?
Other than that though, how would I link DB1 and DB2, using displayName and fill out DB1 with the information from DB2?
View 2 Replies
View Related
Jan 14, 2013
I have an excel sheet (version 2010) that has a few sections that you can add in names (via drop down box). I also have a spot where i want these names to populate - on a second sheet.
Ex
Truck #1:
1. _____
2. _____
3. _____
4. _____
5.______
Truck #2:
1. _____
2. _____
3. _____
4. _____
5.______
Truck #3
1. _____
2. _____
3. _____
4. _____
5.______
Truck #4
1. _____
2. _____
3. _____
4. _____
5.______
6.______
7.______
8.______
My problem is when I refer to the first worksheet from the second worksheet it shows blanks where there are no names. For example i want the second sheet [ LOC ] to show the names that appear under Truck #1, #2, #3, #4 - but truck #1 may not always have names under it?
Sample Excel file attached - Help.xlsx
View 6 Replies
View Related
May 26, 2014
I am trying to link data from a pivot table we have in excel to a separate excel sheet.
The pivot table contains an up to date list of our inventory, however, we want to take that data and put it in a cleaner looking excel that we can e-mail to customers and publish on our website. Going individually, through every product takes too much time to have an up to date stock every day. Its even difficult to manage if we want to update just once a week.
When I link the cells of the pivot table to the new excel sheet they are constantly changing values as people are constantly editing the filters of the pivot table to look up various things.
View 6 Replies
View Related
Apr 13, 2007
I want the contents of the text box (which will be input by the user) to update a cell in another worksheet. I have found numerous examples of how to display the contents of a cell in the text box but I want to know how to display the text box contents in a cell.
View 9 Replies
View Related
Dec 21, 2013
Why the heck every time I enter in to the "edit text" area of the chart title box in a chart in Excel 2010 and type "=B27" (without the quotation marks, and understanding the contents of "B27" has the text I wish to display) does this idiot thing simply display "=B27" (again, without the quotation marks)???
View 4 Replies
View Related
Jul 15, 2013
Let's say I have 2 files: Source file and working file. In source file there are some text names in a column that are updated once in a while.
1. I need to create a column in "working file" such that is taking values from column in "source file" even when "source file" is closed.
2. It should take only non empty values, because I need to create a cell with validation list that consists of text names from the column.
Solving attempt: By searching some solutions in forum I found that the first part I can do in the following way: copy column from "source file", select in "working file" a "paste special" option and choose "paste link". It works, but the problem is that it imports all the column: if in "source file" the column consists of words "a" (cell A1), "b" (cell A2) and all other cells in A column are empty - in "working file", after linking, it appears as "a" (cell A1), "b" (cell A2) and all other cells in A column are "0" (zeros) till cell A65536. And I need that in "working file" column after linking will appear as "a" (cell A1), "b" (cell A2) and all other cells will be empty, so by setting one of cells in B column to be a list (by "Data" - "Data validation" - "List" ) - it will consist only from "a" and "b", and not from "a", "b", "0", "0", "0", .... (65534 zeros).
View 2 Replies
View Related
Jul 3, 2014
I have a standard mail format which was saved in my hard drive(mail includes attachments and few contents in body) via excel. I've several vendor (#)numbers in my excel sheet, everyday I've to send a mailer to different vendors with necessary documents.
1. Vendor number EX: 12345 was hyperlinked, when I click on that 12345 standard mail format should be opened in outlook and the Vendor number 12345 to copied as TO:12345 CC: defined names in the outlook mail.
View 5 Replies
View Related
Jun 18, 2013
I have the folloing Sheets("Monday").Select.
I would like to link this to a cell in my excel sheet.
On Sheet 1 i have a folmular which gives me yesterdays day I would like to like this to the cell so i tryed this
Tabname = sheet1.cells(12, 9)
And I have change the above to Sheets(" & Tabname & ").select.
Its giving me a Subscript out of range error.
View 1 Replies
View Related
Apr 26, 2014
I am using Excel 2007. A few years ago I managed to link a spreadsheet to a particular part of a website. To be specific, I linked a cell to a portion of a table on a website showing the current average price of petrol in the U.K. I also linked a cell to a website which showed the current exchange rate for pounds and dollars. I haven't been able to replicate the procedure.
View 3 Replies
View Related
Jan 7, 2009
Sheet 1 contains a column titled "name" and 6 columns to the right of name titled "sat", "sun", "mon"........ the col titled name is not the first col in the work sheet.
In each row I enter the guest name under the name col and I enter a room number (example: 1A, 1B, 2A, etc...) in the column to the right that coresponds with the day the guest will be staying.
Name Sat Sun Mon Tue Wed Thu Fri
Mr. Smith 1A 1A 1A 1A
Mr. Jones 3B 3B 3B
Ms. Tiller 4A 4A 4A 4A 4A 4A 4A
Sheet 2 is in the same workbook and looks something like this:
Room # Sat Sun Mon Tue Wed Thu Fri
1A
1B
2A
2B
3A
3B
I want it to look at sheet 1 and populate the date columns with the guest name from sheet 1
I tried this formula =IF('Sheet1'!G:G="1A",'Sheet1!$F:$F,"Available")
It seems to work on the first row but I have problems with any rows below that. Basically it acts like there is no data in the rows below.... I think the fact that the names on sheet 1 are not alphabetical is creating part of my problem? I tried a lookup formula but it seems like it has to be the first column in the worksheet and it has to be alphabetical to work like that.
View 4 Replies
View Related
Aug 31, 2012
I have a range of cells that change colors with conditional formats based on the cell value from high to low. I would like to link the cell color to an object such as a circle or rectangle. When the cell value changes along with the conditional format, the color of the object will also change.
View 3 Replies
View Related
Dec 27, 2012
I have a simple reporting sheet where the data for orders place is in one sheet and on the other sheet is an imput box for 'date' and it filters through and presents a table of data and two graphs for the date chosen.
I give a daily report (contents of this sheet) but I also need to leave this sheet available for anyone to open and change to another date.
I want to copy the repor sheet into a new one and email but I want the graphs to remain, not go blank when anyone changes the original sheet.
Excel 2007 / Windows 7.
View 3 Replies
View Related
May 4, 2013
I would like to take the data from worksheet1 and put into worksheet2 but limit the length of a list (the real spread sheet has over 100 rows and i would like them in 4 sets of 25 versus the example I provided). Is there an array or macro that would make this work (keeping the formatting)..
Excel 2007
B
C
3
Name
Company
[Code].....
View 9 Replies
View Related
Apr 9, 2014
how to set one entire columns text to two different colors based on another columns values. So for example I have column A and B. Column A has two values called Internal and External. Column B is a title table so the entire column is just titles. We'll say it goes for 20 rows if you need a row count. What I am looking to do change the text in Column B to Red for External and Blue for Internal. I tried the conditional formatting and I just can't seem to find the right option.
I'm using Win 8.1, Office 2013.
View 4 Replies
View Related
Apr 26, 2014
i am trying to complete a spreadsheet which most of it is done but one column i have i have to average everyother square in each column which i did but when i total those columns at the end i get the dreaded #div/01 which means any value that i dont have in a particular column it will not add is there anyway to fix this. i am attaching a sample of the spreadsheet so you can see exactly what i am trying to do .
View 6 Replies
View Related
Sep 7, 2012
I have data in the following format-----
Name : XYZ
City : ABC
Place : sdfg
Error :
price : [X]
cost : [ ]
time : [ ]
[code]....
I want only name, place,desc and under error, i want that type which is marked cross in the brackets(In the above example it is price ) .
name, place,desc,error should be pasted to separate columns in second excel sheet.
View 1 Replies
View Related
