I'm using Vista with Excel 2007. I have a master spreadhseet populated with a number of columns, but the important ones are column a (item code) and column q (foreign pricing).
I have received the new pricing from our Danish supplier and now need to update my master spreadhseet. The spreadsheet has only column a (item code) and column b (new pricing).
I need to get the pricimng in the new spreadhseet from column b to column q in the master spreadsheet whilst making sure that the item codes match. Note that there are more item codes in the new price list than in the master spreadsheet.
I've bought an Excel book with 1022 pages but still can't figure this out - it must be so simple but I'm missing something.
I have created a pivot table that is connected to an input sheet with data. The input sheet retrieves data automatically from a external source through an add-in to Excel. When updating data the fields expands, but only for the items which have been changed. I want the table to be updated automatically, but not the fields expand automatically. Is there any pivot options to prevent this problem?
It should be mentioned that the pivot table is not directly connected to the input sheet (which is updated from the external source), but from a "help-sheet" reflecting the input sheet with some additional columns. I use conditional formatting and name range in the pivot.
I have a workbook. I want to write a macro that takes cells A16:G16 on sheet "Calc" and to update the list on the sheet "POSITIONS". This is done by using the cell A16 (on "Calc") and looking up the "A" column on sheet "POSITIONS" for a match, then replacing the new values from the "Calc" on the "POSITIONS" sheet. If no match is found I would like to add the new data at the bottom of the sheet. The maxium number of entries (rows) on sheet "POSITIONS" will be 300.
I am working with Microsoft Excel 2003. I am trying to import(or something like it) from worksheet (A) to worksheet (B). Worksheet A is a spreadsheet that I have saved to keep the same row names, etc. but the information within the named cells is forever changing. I also save the information from worksheet A, but have another copy that when I open, it always opens without any changed data in it. MY question/problem is that I need to import the data from A to B, and every time that A changes, I need B to automatically update the data and continuously add to the spreadsheet I have made up for B. I can NOT have A overwrite any data that I have already put into B.
I need a formula that let me change the value in column B with the value from column D. But to do the change I have to check that the value in column C is equal to the value in column A. If a value from column A is not present in column C (like 1002 in the example), the value in column B wont change. The values in columns A and C are alphanumeric, the values in columns B and D are numeric.
For example:
Column A Column B Column C Column D
1001 2 1001 4 1002 1 1003 5 1003 0 1004 1 1004 2
The columns A and B should end like this (Changed):
I have some simple code that filters my source data, what i would like is a way that the user could confirm that the data is correct by clicking a button for each line of data based on the ref number which would then input todays date in coloumn N.... is this possible?
I am trying to update a combo box when a user inputs new data. So I have a form that uses a list in a combo box. What I need is if that combo box receives new data then the combo box will show that new data the next time the form is opened.
I keep track of returns for my company and I am pulling a CSV file with all of the information on it.
I want to be able to format the info and create new columns for info I enter in to the sheet, and be able to import the updated CSV file into my already formatted sheet.
The part that I am wondering about is, after I import my first CSV file(sheet1) do I need to create another sheet(sheet2) and format sheet2 and have it pull the info from sheet1, then when I update workbook1 the data will update in sheet2?
Or, is there a way to just import the new data a single formatted sheet that I created from the old data and have it just add the new data without messing up any of my formatting?
It's something like updating data by merging 2 tables. New names adding in end of table but peoples who has new mails need to be changed. Clear explanation in attached image.
People 1 and People 2 are same persons in both tables.
I have created a userform with textboxes. I want to update cells on a spreadsheet with the values in the textboxes. I have set the code into a command button to update the values, but they only get updated when I close the userform, not when I click the command button.
I have two workbook.In 'Entry'Workbook where data is filled up daily in different blank cells.In 'Report' workbook,exactly, I want to pull and update the data .The format is same.Then those changes if possible must be shown in a separate sheet.Since the data is very large,I cannot track where the changes has been made in 'Entry' Workbook'.In order to know the changes in cells,I require this on daily basis.Hence I require two things-
1.VBA Code/Macro for pulling & updating changes to 'Report' workbook from 'Entry'Workbook .And only those changes that should be ignored that has been made by me in 'Report'Workbook
2.Changes made in 'Entry'Workbook must be summarised in a separate sheet in 'Report'Workbook.
I need a method of updating a set of data held on tab1 from tab2 where details of one record is shown using VLOOKUP, possibly via a macro? For example:
Sheet 1 holds info on various companies - (Column headers: Name, address1, address2, postcode, " DATE LETTER SENT")
Sheet 2 Uses a drop down menu to select the desired company and some VLOOKUP formulas show the info from sheet1 on that one particular company. Sheet 3 There is a printable standard template letter which draws info from the record selected on sheet 2 (using standard =Sheet1!A1 formula) formated so the letter is addressed to the specific company selected. Back to: Sheet 2 - At the bottom there is a button which says 'Print' This runs a macro which selects sheet3, prints it then returns to sheet2. I need this macro to also go back to sheet1 and update the relevant record with ideally todays date (the date the letter was printed) in the "DATE LETTER SENT" column mentioned before but can just be an 'X' to show a letter has been printed for this company/record at some point. So in the future, by looking at sheet1 you can easil determine which companys have had letters printed against, and which havn't.
I'm coming up with a dynamic graph using VBA. The one originally proposed to me using "offset" and insert chart doesn't work well with an an animation that happens concurrently with the dynamic chart.
So i've come up with a VBA version of it. It works extremely well on Excel 2007 but when i open it with Excel 2003, it just doesn't work in the line highlighted in yellow (below)
Sub create_graph() Dim start_row, Start_col, range, number_of_tries, m, n Dim graph As Chart Dim wks As Worksheet Dim myArray As Variant
For some reason, the charts in my excel workbook do not update automatically when the data are changed. I have set Calculation to Automatic, but it still doesn't work. They update only if I close and reopen the workbook. Is it due to a problem with setting? How can I get the charts to automatically update?
I am looking to have the data ranges in tab 'Type' update automatically in 'Output' for a particular start date. So for example if I enter LBO into cell E3 in the 'Output' tab it will input the data range for LBO from tab 'Type' but from a specific start date.
I know I can achieve part of this via LookUp functions but it is the start date that has me stumped.
What I am trying to do would appear to be very simple. I am trying to build a quotation form for our sales guys to use. I would like to use a drop down list with the list of products in, which I have created using a list in a second sheet and then using a data validation drop down list.
What I would like to achieve is the sales person selects the product (of a list of only 14) from the list and excel to automatically fill in the two columns to the right with the model no. and also the price.
Would it be possible to use an IF statement as there are only 14 products to choose from? Is there a better way of doing this? I have created the lists of model numbers and prices in the second sheet alongside the product name which the drop down list sources from.
I've created a spreadsheet which, on running a macro, imports data from a text file, formats it and then sums various parts of it giving me a subset of the large file as a range of data for a chart (a pie chart) on Sheet 2.
The problem begins when I delete the data in the worksheet in preparation for another import - the Pie chart just loses all the data and I have to manually reselect it in the chart each time.
Once deleted the chart is blank, but as soon as the data is imported, I get reference errors when I click on Sheet 2
I must be doing something wrong. You can delete data and repopulate it and the chart should pick up with the new data. If the cells it is referencing are empty, it is blank. Not so here.
Is it to do with importing the data? Or the formula for my chart data?
I have multiple data sheets with tables and I want to create a master sheet table that automaticly will update when now rows/data is added in to the sheets in any of the data sheets.
Master sheet will look like this (the first 3 letters is the data sheet name), this is just the first column there a a lot more columns to be added
AAB08 AAB09 AAB10 AAB11 AAB12
[Code] .......
So when let's say in sheet AAB I add another row AAD13 I want the master sheet to update automaticly so it looks like this
How I could generate a report using a Command Button. I have a spreadsheet that contains data in columns, some of which I want showing up in the summary report. Any new data entered should be updated in the summary report when I hit the command button. Existing data in the original spreadsheet does not get erased or written over.
So basically, I have data in column range A:R in Sheet 1. Columns A, D. E, F, G, I, J, P, and R need to show up in the report on Sheet 2. I already have 150 rows of data in sheet 1, so i don't want to start over. So I need to copy the relevant columns, and update the report with any new data that gets entered in the columns in Sheet1, in the next empy row.
I have some vba code that copies individual cells, but I don't know how to do it for columns and for new data.
I have attached 2 files. One of them is called Macca.xls. This is the file that was created for me by shg on an excelforum. The other isOreDep_updated.xls - this file is the updated list that I want to convert into the Macca file or make it look like the Macca file.
I awas trying to make a couple of plots, but they were not llooking like some examples I have.
In the OreDep-updated file attachment is my data I needed to use. I needed to make 2 plots:
Plot 1: Resource Grade (log scale) against the proportion of deposits (linear scale)
Plot 2:Tonnage (log scale) against proportion of deposits (linear scale)
This was done with my old data that is shown in the Macca.xls attachment.
They are meant to cumulative proportion plots. As a line or scattergram. An example of what they are meant to look like is at: http://www.nbmg.unr.edu/dox/ofr962/c11.pdf on Page 4 and 5.
shg managed to make them look like I wanted with the log normal smooth line too.
My problem now is that I want to change the data under Name, Resource Tonnes and Resource Grade (basically replace the old data in Macca.xls with the new OreDep_update.xls, to come up with same type of plots). But whenever I try to copy and paste the data into the Macca file it messes up everything. I looked at the formula that was created and I really havent a clue how to change it, without affecting everything else like the plots.
I also need to add 2 new columns for date and for reference, and it wont let me do that.
I copy a table from a data dump dbf file into worksheet 1. I enter a separate column titled "Comments" and use this for status purposes. My problem is that when I refresh the worksheet, my comments don't stay attached to the rows/ records that they were originally entered for.
I'm using Excel 2007. I would like to seek some advise on how i may update cells after selecting a month from a drop down list.
i have created a simplified version of what i intend to have. One the 1st tab 'Cash Budget 2009', i have filled up a table with numbers, sorted by months. On the 2nd tab 'Dec09', i would like to create an expense table, to be able to be selected by month. So i have created a drop down list based on the months that are created in the 1st tab.
Upon selection of the month from the drop down list, i would like the cells to display (fetch) the data from the 1st worksheet. It would also be helpful if the name of the 2nd tab can be updated to read as the month that is being selected.
I have a workbook that has worksheeets for every day of the month. The data in the worksheet consists of columns (employee #, name, clock in/out times, and break penalty).
What I am trying to do is create another worksheet that searches all the other worksheets for a "yes" in the "break penalty" column and then create a list of all the employees that received a break penalty for the entire month. I would like this to be able to auto populate throughout the month as data is entered and not have to use a filter every time I want to compile this list.
I have been researching this for 3 days and I cannot find a solution. I have City, State information in A1. I also have City, State information in B1. I need to put them into City (D1) and State (E1).
