Populating A Cell With Data From Another Cell In A Different Workbook?
Dec 13, 2013
I am entering data into one workbook 1 (WB1) that contains a worksheet for every month. I manually extract some of the data from WB1 and put it into workbook 2 (WB2), which also contains a worksheet for every month. Is there a way to populate WB2 from WB1? For example, I want cell B5 from WB1 to automatically populate B5 in WB2, and so on. I have to update this every day and would like to way to automate it to cut down on data entry errors since they need to match. And both of these files are stored in SharePoint for others to access if need be.
I have attached a sample of the workbooks (yet only have one month in each of these wb).
View 2 Replies
ADVERTISEMENT
Jul 8, 2012
I am trying to populate a text box in a user form when initializing the form. I have reviewed many posts in this forum regarding this problem, but have been unable to resolve. My code looks like this:
VB:
Private Sub frmFeed_Initialize()
ActiveWorkbook.Sheets("Log").Activate
Range("A1").Select
[Code]....
View 6 Replies
View Related
Apr 26, 2013
I want to create a sort of complex logging system for my work.
As of right now i use a simple temple. Column A has the job number, column B has drawing numbers. Each cell in column B has multiple drawings. So for example cell B2 might contain 101, 102, 103, 104 and so on or something like 101...104. Depending on the situation. The ... means drawings 101 thru 104. What i want to do is have a second sheet that has Column A be the job number but column B has just one drawing #, so an example would be . A1 = 10939 and B1 = 105, 107, 109..111. Sheet 2 would then have A1 = 10939, B1 = 105, A2 = 10939, B2 = 107, A3 = 10939, B3 = 109, A4 = 10939, B4 = 110, and so on. Is something like this possible.
View 4 Replies
View Related
Jan 27, 2014
I have a big database of customers, each one has a unique reference number. They are spread accross a bunch of different tabs (21 in total to be exact)
One issue I have had is staff entering a customer whos already in the database, causing a duplicate entry. I dont need excel to tell us where the entry is, just to give some kind of indicator it already exists. I thought I may be able to use data validation/conditionality to turn the cell fill Red when it already exists in the data base.
The reason I think that method would be best, is that the sheets that data is entered on are seperate that the master sheet then pulls the data through from. Its the master sheet that would need to indicate a duplicate has been entered, as thats the only sheet where the entire database can be viewed.
View 2 Replies
View Related
Jun 1, 2007
I need to have totals from individual worksheets automatically enter into cells in a master spreadsheet.
What I am doing is keeping track of donations collected from individual departments - each on their own worksheet. I would like to have the totals of each page automatically enter & update onto a master worksheet that would show the totals from each dept and then give me a total of all those.
I am not that well versed in Excel. I have been able to set up the individual worksheets and the master.....but can not figure out how to accomplish what I want with the Master tally sheet.
On the individual worksheets I also want to set it up to give me the average donation per person. So if I total the # of donors and the total $$$ amount...what formula do I use to get the average?
View 15 Replies
View Related
Aug 6, 2014
For my project , I am using Excel as a frontend and Access as a backend. Now, I want to write the code in workbook_Open event that will copy data in Column L,M,N,O from Access table. The query should select data from Access table where Date=Todays Date. All the Queue Names and corresponding Queue Numbers are stored in Sheet2 of the attached workbook. In Access table , there are three fields named as Type,Type1,Type2 which make up Queue numbers.
In Sheet1 , There are Queue Names and we have to store Total Batches,Totl Envelopes,total Documents and total Pages for the corresponding Queue Names in Sheet1. SO for this we need to check the Queue Numbers of the Queue names in SHeet2 but in table Queue Numbers are equal to Type & Type1 & Type2.
See attached workbook : WBExcel.xls
View 2 Replies
View Related
Jan 9, 2010
Trying to word this right. I have one cell with a date of 01/01/2010. I have other cells that I want to be equal to this cell plus 1 or more months.
For example A1=01/01/2010
I want A2 to = 02/01/2010 based on one calendar month entered into A1. So if A1 changes 03/01/2010, A2 will = 04/01/2010.
View 3 Replies
View Related
Mar 14, 2013
On one workbook I have "column A" that lists serial #'s, one serial number per cell. What I need is to be able to take all the non blank data from that column and copy it to another workbook with all those serial #'s in 1 cell numerically sorted and separated by commas.
View 1 Replies
View Related
Sep 28, 2012
I have two workbooks open. I need to "Save As" and close workbook 2 with a file name from a cell in Workbook 1. The macro is running from workbook 1.
I'm guessing a change in the last line. I don't know what Dim means either.
Dim FName As String
Dim FPath As String
FPath = "G:"
FName = Sheets("sheet 1").Range("A1").Text
ThisWorkbook.SaveAs Filename:=FPath & "" & FName
View 1 Replies
View Related
Apr 15, 2009
I have a colum with 350 cells in use, each of these cells contain a 3 digit number. Without having to go into each cell and type is there a way i can put the Letter
"R" infront of each of the 3 digit numbers?
View 4 Replies
View Related
May 5, 2007
I am trying to make sheet that will give me averages from different groups within a worksheet. In E64 I would like to have the total that is in I4 unless there is a total in I24 or I44. When I made the worksheet, it figures everything great but when I remove the data on following weeks it messes up the averages.
View 10 Replies
View Related
Oct 10, 2008
I need column B to self populate cells with "1" if a specific range of room numbers are entered in column A. Is this possible?
Column A, room numbers from all over hospital.
Column B auto populate "1" if rooms ranging from M570 to M590 in Column A
View 9 Replies
View Related
Oct 10, 2008
I have a list of names and a seperate list of names with emails.
In column A there is a last name, column B a first name, and then for the second list in column D there is an email.
I need to tell Excel that if column A and Column B both have a replication on the list, then in Column D populate it with the email address on the list.
I know this is confusing so I have attached a sample of my spreadsheet. The email address is in yellow and I need to have it copied to the cells in white. The list is almost 14,500 lines long and it would take forever manually.
View 3 Replies
View Related
May 13, 2013
I have a spreadsheet with a number of columns from a database export, where values in the column are either "TRUE" or "FALSE," Depending on whether or not the box was checked in the database. I am wondering if there is a way to populate a new cell with the text from the column if the value is "TRUE."
For example:
BOY
GIRL
John Doe
TRUE
FALSE
Is there a way that I could have another cell populated (I guess via function or macro) with "BOY," since the option for boy is true?
View 8 Replies
View Related
Jun 27, 2013
Code:
With wshfma
lr1 = 0
.Range("K2:N15").ClearContents 'early late staff rowsource
.Range("C2") = Format(hwmin1, "h:mmA/P") 'text!
With .Range("D2")
.Value = (.Range("C2"))
.NumberFormat = "general"
End With
Cell C2 of worksheet 'fma' is populated by a value linked from a textbox in a userform. It is a time value in text format (eg "8:30P").
This snippit of code is to populate cell D2 of worksheet 'FMA' with the value in C2 (8:30P), and apply the general number format to it. (I know redundant ... but this is just testing).
What is happening though, is cell D2 is actually being populated with the contents of another cell ... F3 to be exact.
View 3 Replies
View Related
Aug 23, 2008
I am creating a form where the user chooses a Region from a drop down list and a Level from another drop down list. I have a cell I want to populate with the amount pertaining to the Region and Level from a seperate spreadsheet within the workbook.
The levels for each region go from 1 to 12 and there are 4 regions from A to D. I have separated each region and named them GradeA, GradeB, etc.
View 9 Replies
View Related
Apr 11, 2007
I have a text box on a form and wish to update the next empty cell in the column when a add button is clicked the code I'm using is as follows:-
Private Sub AddButton1_Click()
TextBox3.Value = Sheets("Data").Range("A65536").End(xlUp).Select
End Sub
View 3 Replies
View Related
Mar 28, 2014
I am using the form control data validation drop down list with 9 entries in the list. How can I get the entry that is selected in the drop down list to populate exactly into another cell on a separte worksheet? I have linked the drop down list to the cell, but the value is populating as a number rather than the text entry that is in the drop down.
View 7 Replies
View Related
May 1, 2014
I have a userform which requires the user to enter the date a training course was completed. Initially I used DatePicker as I was running Excel 2010 and had that working, however the workbook I am creating will be used on about a dozen machines, all of which have different versions of Excel. To avoid needing calendar Add-ins to be downloaded and installed for this feature I decided to go the vba created calendar route. I am using one I found on this forum: [URL] .....
It works well for me using the example spreadsheet provided in the post but I am having some difficulty incorporating it into my code. I believe I have imported the appropriate forms and modules because I can get the date populate to the Label Box on my userform but when I try to put the Date into the spreadsheet along with other data such as name and course duration, the name and course duration populate but the date cell remains blank and execution completes without error.
I have tried playing around with the data type thinking I had some issue using the .Value attribute with a String but .Text gives me an error as does converting from String to Number format.
I will attach the workbook but for a quick look, the portion of the code I believe that is not working is in here:
[Code] .....
Training Classes Example Workbook.xlsm
View 3 Replies
View Related
Mar 31, 2008
I have two worksheets. The first contains a list of software (some having duplicate listings) in column A and a list of comments in column B. None of the software titles that have duplicates will have comments.
The second worksheet contains a condensed list of software (the previous list without the duplicates) and a column for the comments.
I need to have a formula that populates the second worksheet comments cells with the corresponding comments from worksheet one only if:
(1) The software title in worksheet two matches the software title in worksheet one
(2) The comment cell in worksheet one contains a comment (or text)
I have had only partial success; my obstacle being the duplicate software titles in worksheet one.
View 10 Replies
View Related
Aug 22, 2008
If I type a VLookup formula in Cell A1, the resultset goes into cell A1, as expected.
Is there any way to have a formula in Cell "A1" that populates a different cell, like Cell A6 that contains no formula ?
The reason I need this is that the user sometimes needs to type in manual data into Cell A6 and would overwrite the formulas. I was thinking that if I could have them actually type something into A1, it would populate other cells, such as A6, that did not have any formulas.
View 9 Replies
View Related
Jul 29, 2009
I would like to do is have 2 listboxes. In the first listbox I would like the name of all the worksheets which contain the words "elective class: " in cell C7.
In the second listbox I would like the name of all the worksheets which do not contain the words "elective class: " in C7. I need this only to source from worksheet 7 onwards however.
The listboxes are called ListBox1 and ListBox2 respectively.
Also I am using this to print and I have a button which currently selects all the data in the first listbox and another button which prints all the selected data. The code being used for this is:
View 2 Replies
View Related
May 9, 2013
I have two coworkers who input a list of times spent throughout the week into a basic 5x5 grid (daysof the week x 5 employees) into their own seperate workbooks. I then take those workbooks and copy and paste them on to my own master work book. Is there any way to get their data to auto populate on to my spreadsheet?
View 3 Replies
View Related
Apr 2, 2008
I have one excel workbook which has 10 rows of data. I need to access another excel wb which has 10 rows of data and get the variance. The key here is wb 1 has the data as I manual gather it and it changes very often. WB 2 also changes to equal the number of rows in Wb 1.
A> I would like to call Wb 2 from Wb 1 and copy those 10
B> It should be able to handle change in the number of rows in WB 2
C> It should be able to call workbook 2 irrespective i name it differently.
Is there a way i can achieve all the 3 above?
View 9 Replies
View Related
Feb 18, 2014
I am working on two worksheets, in different workbooks. They are both lists of customers and Worksheet 1 is 2500 rows & contains up to date data & Worksheet 2 is 20000+ & includes some that is outdated. Worksheet A data is all contained within worksheet B but I need to be able to update/compare them.
Each customer in worksheet A has two unique identifiers but in B there is only one. I want to be able to add in the missing unique identifier (numeric) from A to B, which will identify which customers are still active from worksheet B.
I have been trying to do a VLOOKUP so I can insert the relevant data from the cell from A to B but I'm getting a N/A error. My formula looks like this:
=VLOOKUP('[Netsuite customer details 17feb14.xlsx]Customers'!$B$2,'[Netsuite customer details 17feb14.xlsx]Customers'!$A$2:$BE$2549,2,FALSE)
View 2 Replies
View Related
Jan 27, 2009
I have a workbook 'logsheet' were i enter data like 'coil, supplier, thickness, width' and 'lot'. This happens 7 times on one logsheet. When the logsheet is filled, a new copy is created (from a hidden empty logsheet).
I want this data to copied to a seperate sheet - eg called data - in same workbook so that it can be used in other workbooks as external data.
I want to enter a formula on the logsheet worksheets and not on the data logsheet because the amount of logsheets (and coils) is unkown and can vary each lot.
Is this possible with formulas eg copyto? (if that formula exists ><)
Is it possible to add data from worksheets that still have to be created from the empty logsheet
View 11 Replies
View Related
Sep 17, 2008
I'm trying to link a range of cells in one workbook to a range in another workbook, both in a network drive. Everything is working out well except for the cells that have a data validation list on them. the formula linking one cell is ='G:Destination To[Workbook2.xls]SheetX!B13 so I'm just trying to get the value in the cell. I don't need the validation list to transfer just the value of what was selected. If I go to that cell and type something in then it transfers over just fine. If the validation list was used in Workbook2 then I get a #N/A in Workbook1 that is linking to the Workbook2 cell.
How can I link the cell with a data validation list in it to a cell in another workbook so that I can get the data in the cell (whatever was selected from the validation list)?......
View 4 Replies
View Related
Aug 24, 2006
I have a cell that is pulling data from a separate file, no problem there. However, I want the name of one of the folders within that path to change monthly (eg. by monthly name). How can I make a file path incorporate a cell link within a filepath (eg. instead of it saying 'Aug 06' I want it to refer to cell A1 which reads 'Aug 06').
View 2 Replies
View Related
Oct 24, 2006
If I have a two files called test1.xls and test2.xls for example. Is it possible to link test1.xls to test2.xls by putting the filename in a cell?
i.e. In test2 put the filename in say A1 and in the link put the path and instead of naming the file you want to link to put in A1 instead.
I know it doesn't work if you do it that way I was just wondering if there was a way to do it.
View 5 Replies
View Related
Mar 16, 2008
I have a VBA-coded macro in an Excel workbook that is to open another existing workbook -- a .xls file, not .csv -- copy data from it, paste that into the original workbook where the macro resides, then close the source workbook.
If I use the debugger to step through the macro -- putting a breakpoint at its first executable line, run the macro, then F8 step through it, it works fine. (With delays at the open, close statements.) Free running, it doesn't. I suspect it's a timing issue, that the macro runs full tilt even though the new workbook isn't yet open -- but I don't know how to remedy that.
Here is the situation and the simplified code (the actual macro does a lot more, of course):
Main workbook: Two sheets, "Parameters" that has the fully-qualified filename for the desired source .xls in A1; and "Data", into which I want to paste data from that source.
Source workbook: Single sheet, "Sheet1"
Macro code. For simplicity, it is trying to copy/paste all of the source worksheet's content:
Sub Go()
'
' Go Macro
' Test of getting data from another spreadsheet
'
' Keyboard Shortcut: Ctrl+Shift+G
'
Dim SourceFile As String
Dim HomeBook As String
Dim OtherBook As String
Sheets("Parameters").Select
SourceFile = Range("A1").Value
HomeBook = ActiveWorkbook.Name
right after the open, hoping that might cause a dwell for the open to complete.
When I step through it, the Locals view has all the parameters, getting set properly. If I try to simply run it, it stalls at the opened source workbook, the Locals view is empty, no data has been transferred into the initiating workbook.
If I place the breakpoint after the open, it is not reached. (I have the VBA open.) Hitting F8 then yields a VB error window, "Compile Error" "Expected: To"
View 3 Replies
View Related
