Updating Data In 1 Column From Another
Jun 27, 2008
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):
1001 4
1002 1
1003 5
1004 1
View 9 Replies
ADVERTISEMENT
Apr 14, 2006
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.
View 9 Replies
View Related
Mar 6, 2012
In an excel sheet, I have 5 columns namely, name, address, source, subtype,code. In subtype column we enter the the type for example: name,SBI bank then subtype will be bank, and if it is SBI atm then subtype will be ATM etc. Similarly all the subtype will be given a code like 4 for ATM and 10 for Bank respectively. My query is that , is it possible to update the CODE column by comparing the subtype column using macros in excel.
View 6 Replies
View Related
May 5, 2009
I have two sheets. One called "Roster" and one called "final". On the final sheet i have cols for each question on the final exam. I also have a total col which sums up the pts for each question.
On the "roster" sheet. This is kinda like a summary sheet. On this sheet i use a vlookup (shown below) in the cells which are supposed to reference the cells on the "final" sheet for the total pts.
View 10 Replies
View Related
Jan 11, 2013
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.
View 1 Replies
View Related
May 30, 2014
Check the attached sample file
a. actual data in columns is approx 150 items (that is why i need to hide/unhide columns)
b. there are about 120 persons whom above items are issued depending on expiry of life of item i.e. issue date plus number of months mentioned in row 3. for example if coat was issued to John on 5th Jan then it's life expires on 5th May and so on.
Now what i want
1. by clicking hide checkbox only that specific column should hide or if i click Hide All check box all column in range should hide.
2. as i enter issue date expiry of that item should automatically update on corresponding month sheet i.e for above example 5th May should automatically get entered in sheet May.
I have entered sample data manually in months sheet.
aJITCBP.xlsm
View 2 Replies
View Related
May 22, 2014
I am trying to read a value in cell A1 and make say cell B1 read the same. The data in cell A1 is a real time percentage value that gets updated every lets say 10 secs. Every time the data is updated the new value goes into the next cell A2, A3, A4..... and so on. Every time it gets updated (i.e into A1,A2,A3,A4.....and so on), I want to read the new value each time in B1.
View 9 Replies
View Related
Jul 6, 2006
I have a list of two columns. Here’s an example. The left most column provides the row number.
_ A B
1 1 0
2 2 1
3 2 1
4 3 2
5 4 2.5
6 5 4
7 1 0
8 1 0
9 2 2
Whenever there are two repeating numbers in column one, I want to reduce certain numbers in column 2 by a certain amount. The amount is determined by half the difference between the number in column B corresponding to the second repeated number and the number in column B corresponding to the row after the second repeating number. The range of numbers that are to be reduced begins with the row after the second repeating number and ends with the last row before number one appears in column A. The values in column A are integers, always starting with one. For example, 1, 2, 3, 4, 1, 2, 3, 1, 2, 3, 4, 5.
For the above example, after finding the repeating number two’s at A2 and A3, it would reduce B4 through B6 by half the difference between B3 and B4 (1/2). The values for B4 through B6 would be updated in column B. The same for the next repeated numbers, which is one at A7 and A8. Half the difference between B8 and B9 is 1.
Here’s what the updated list would look like:
1 1 0
2 2 1
3 2 1
4 3 1.5
5 4 2
6 5 3.5
7 1 0
8 1 0
9 2 1
View 9 Replies
View Related
Feb 7, 2014
can't get the data to update right. It updates the cells but also overwrites the first person's name.
View 5 Replies
View Related
Jan 9, 2009
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.
View 5 Replies
View Related
Jan 9, 2006
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.
View 13 Replies
View Related
Jan 20, 2009
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.
View 9 Replies
View Related
Jul 2, 2012
Clicking the Add to DB button will add new items but not existing one.
now, what I want to do is to first, populate the existing TIN and then do the necessary update.
my basis for update is txtTIN.value
Here are the codes anyway:
VB:
'This adds the data on the WorkSheet named DBPIT"
Private Sub cmdAdd_Click()
Dim iRow As Long
[Code].....
View 5 Replies
View Related
Feb 14, 2014
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?
View 1 Replies
View Related
Jan 12, 2009
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.
View 6 Replies
View Related
Dec 14, 2011
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?
View 2 Replies
View Related
May 8, 2013
Here is what i want:
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.
View 1 Replies
View Related
Nov 18, 2007
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.
View 9 Replies
View Related
Apr 7, 2014
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.
[URL] ....
View 1 Replies
View Related
Apr 27, 2007
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.
View 2 Replies
View Related
Mar 31, 2008
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
View 3 Replies
View Related
Apr 30, 2008
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?
View 4 Replies
View Related
Mar 6, 2014
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.
View 8 Replies
View Related
May 14, 2009
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.
View 10 Replies
View Related
Oct 4, 2013
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?
View 1 Replies
View Related
Oct 10, 2013
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
AAB08
AAB09
AAB10
AAB11
AAB12
[Code] ......
Is this possible?
View 1 Replies
View Related
Dec 20, 2013
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.
View 4 Replies
View Related
Oct 11, 2009
I have a worksheet with 300 rows and I have a separate worksheet that contains graphs based on the data in the 300 rows.
The data is continually updated but stays at 300 rows. I add a new row at 301 and then I delete row 1.
I set the graphs up with a Chart Data Range of =GData!$B$1:$AB$300
As I add and delete rows the Chart Data Range reduces so after adding and deleting 3 rows the Chart Data Range is now =GData!$B$1:$AB$297
How can I get the Chart Data Range to stay at =GData!$B$1:$AB$300?
View 9 Replies
View Related
Oct 24, 2008
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.
View 9 Replies
View Related
Dec 13, 2009
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.
View 4 Replies
View Related
