Text Data With Assigned IDs-Need Two Spreadsheets To "Talk"
Aug 28, 2009
In workbook A, I have 2,000 records, cleaned/de-duped
I have columns A, B, and C:
Blank|Truman school, San Diego |1234
Blank|Truman school, San francisco|1235
Blank|Truman school, Atlanta|1236
Blank|Nice school, Georgia|1237
Blank|Nice school, Raleigh|1238
I used =MAX($B$1:B1)+IF(COUNTIF($A$2:A2,A2)=1,1,0) copied down and deduped in order to get my results in Workbook1.
In Workbook B, I have about 6,000 records and they look like this in columns A,B,C
Laura|Truman school, San Diego | need id to match from workbook 1 for column C
Trevor|Truman school, San Diego|need id to match from workbook 1 for column C
Sandy|Truman school, San Diego|need id to match from workbook 1 for column C
Kate|Truman school, San francisco|need id to match from workbook 1 for column C
Rudy|Truman school, San francisco|need id to match from workbook 1 for column C
Sean|Truman school, Atlanta|need id to match from workbook 1 for column C
Mark|Nice school, Raleigh|need id to match from workbook 1 for column C
Tom|Nice school, Georgia|need id to match from workbook 1 for column C
I have a little trouble with my macros. I wrote several different macros, each for a special purpose. Then I created some Buttons, which would make it easy for others to work with them.
But I have now experienced several times, that my buttons don't keep their assigned macro.
I am creating a series of charts that all include a text box containing "(N=[value])", with different values in each instance, but with each N value listed as a total frequency in each table. I am creating hundreds of these, so if there is a way to automatically pull the correct N value from a cell into the text box, it would make this faster. I have written simple functions in excel tables but have no experience with VBA/macros.
I know I posted this same topic about a week ago but I went through the first 20 pages on the forum and couldt find it, i tried the search option and nothing came up. I have several worksheets in the same workbook. When I enter a number in one cell in work sheet A, I want the same number to show up in a given cell on work sheet B. How do I do this? I can make words move from one shet to the next but numbers dont seem to be the same.
I am writing a UserForm and only one of my comboboxes is correctly outputting to the assigned worksheet. All of the textboxes, radio buttons, and checkboxes are working properly. It is my first time designing a UserForm. Attached is the code - maybe someone can see the error that is allowing only cboq4d to be transferred to the worksheet (named DataBase).
Private Sub cmdClear_Click() Call UserForm_Initialize End Sub
Private Sub cmdOK_Click() Call UserForm_Initialize ActiveWorkbook.Sheets("DataBase").Activate Range("A1").Select Do If IsEmpty(ActiveCell) = False Then ActiveCell.Offset(1, 0).Select................
I am using the following code to create several spreadsheets and send via email. This all works perfectly, but I would like to add text to the body of the email. What would I need to add to enable me to add text to the body of the email?
From Bottom of Code:
' Copy the Report sheet to a new book and e-mail Sheets("Report").Copy Application.Dialogs(xlDialogSendMail).Show _
how do i access data from different spreadsheet tabs in a same excel file..e.g: if tab 1(student) and tab2(teacher), how do i access tab2 let say cell C4
I have got a few spreadsheets which save information for each departments, about 8. They contain information on bookings & I am being asked to get information on certain date ranges, mainly monthly reports. (They are being filled in automatically from another excel file.)
Can I have a file which I could call "Master file" which has a macro in that looks up and copies all the relevant rows from each departments spreadsheet into the new master file. I dont think this would be too difficult (still beyond my capabilities though) My intial thoughts were something like (in half code half english).
Create a form where you specify your date range and a submit button e.g. txtstartdate txtenddate
Lookup 'G:FolderGeneral[General.xls] IF in between txtstartdate and txtenddate then paste
ActiveWorkbook.Sheets("master sheet").Activate Range("B2").Select Do
I'm doing an audit where I need to compare data between two spreadsheets that are housed on the same worksheet. The data I'm trying to compare is the ssn#. I'm expecting duplicates, I'm trying to find ssn#'s that do not match up with another. In other words, if one spreadsheet has 92ssn#s, the other has 79, I want to be able to identify those that do not have a matching ssn# from one spreadsheet to the other.
Both spreadsheets have the following columns:
Column A Column B Column C SSN Last Name First Name
The tab on the bottom of sheet 1 is titled "CX Data", the tab on the bottom of sheet two is titled, "BCBS of AL Data"
in creating a VLOOKUP formula that will meet my needs?
I have some data that looks like this: 5差し上げる 5机の上 5申し上げる 5上手な 5上着 6テーブルの下 6下げる 6下宿する 6下手な 6下着
and in another sheet, corresponding data like this. 上5 下6 中7 ... 後53 手54 新55
I want to be able to filter out the rows from the first sheet when a symbol (kanji) from the right hand side is included at a number higher than that of the second sheet.
For example, 手 appears as a number 6 in the first sheet but doesn't appear until 54 in the second sheet. Therefore I would like to delete the row with 手 in the first sheet.
Is there a simple way to do this? If not, can anyone suggest a way to program this? I was thinking of writing a little VBA code that reads the the characters and then compares them to every number above and if it doesn't find it, deleting that row but I have 2 problems. 1. How can I tell VBA to actually delete a row (not just the contents preferably) 2. These are asian characters which I'm not sure are well supported in strings which I would need for comparison?
I have two spreadsheets with data. Sheet one has about 2,000 employee IDs on it and sheet two has about 300 employee IDs on it. I need to write a formula in sheet one to find which employee IDs from sheet one are also listed in sheet two.
Is there a filter I should use to do this or is there a formula? I tried using the formula
I am trying to import data from different spreadsheets "about 100" to a principal spreadsheet which will have all the centralized data. I included the principal spreadsheet layout and a sample of two detail spreadsheets. The information that I want to import is from column B 1 to 5 from the detail spreadsheets and put into the principal spreadsheet from row D to G.
Is there any way to import this information automatically, like creating a macro or something similar.
I have two spreadsheets, and wish to compare some of the objects. I have my vba code set up in Sheet1, and my functions in Module1 in one spreadsheet. I successfully open up the second one, then get this error message:
Microsoft Visual Basic for Applications Run-time error '1004': Application-defined or object-defined error.
If I comment out the SwitchExcel line, the script works.
Here is my code:
Dim theRow As Integer Dim theCol As Integer Dim strVal As String Dim LastCellRow As Long Dim LastCellColumn As Long Dim YesNo As Boolean
[Code] ..........
Module1 code consists of:
Code: Function LastCellColumnNumber() As Long '''''''''''''''''''''''''''''''''''''' ' Last cell in column '''''''''''''''''''''''''''''''''''''' Dim RowNumber As Long Set WS = Worksheets("Sheet1") With WS RowNumber = 2 If .Cells(RowNumber, .Columns.Count) vbNullString Then Set LastCell = .Cells(RowNumber, .Columns.Count)
I have spreadsheet A (below) which has various fields including a row headed: Postcode. Then I have spreadsheet B which has columns Name (A1), Postcode(B1), Practice Code(C1), Telephone (D1). (I can't figure out how to move on to another line here, for some reason the enter key does not work, might be a browser issue.) I have more postcodes on spreadsheet B than on spreadsheet A.
I want to compare the spreadsheets and where there is a matching postcode, insert the Practice code(s) from spreadsheet B (column C) into spreadsheet A (column A). At the moment the Practice Code column in spreadsheet A is empty.
Practice Code (A1) Name(B1) Name2(C1) Street(D1) Locality(E1) Town(F1) County (G1) Country (H1) Numbers (I1) Postcode (J1)ｻｿｻｿ
I want to compare two spreadsheets with the same data. One spreadsheet is for a certain type of beneficiary and the other spreadsheet is another type. We will call them Spreadsheet A and Spreadsheet B. They both contain Zip Codes and a count of zip codes. (Some of the zip codes is not a 5 digit code, but some letters or letters and numbers.) I want to compare the two spreadsheets and see if the same zip code appears in both spreadsheets and if they do, show them in a separate tab and total the two counts from the two spreadsheets.
I created a form that takes information from textboxes and places them onto a new worksheet. This is done about 20 times until I have 20 different worksheets.
What I'm looking for is a way to Copy only certain information from all the spreadsheets and paste it onto one spreadsheet. For example if column C has a cell with the word "Not Accepted" in it, that information needs to transfer to a new worksheet.
I'm looking to do this so that it will run through all spreadsheets and grab that specific information and dump it into a new sheet...
I have two spreadsheets. One with 1,000 names and addresses, the other with 5,000, names addresses and birthdays.
Within that spreadsheet of 5,000 contain the same 1,000 contacts as the other spreadsheet. How do I import the birthdays of the 1,000 contacts without doing it by hand. Is there a macro or forumla that could do this?
I am creating a MIS for my team. But I am now struck while creating dashboard. I have a workbook with 12 raw data spreadsheets for specific months. Now what I want is that in 13th sheet if I select January then 1st cell in 13 sheet will show the value January cell 1 value. However if I select February then 1st cell in 13th sheet will show the value of February cell 1 value.
I have several excel spreadsheets by which I would like to add together certain values in the column with the same columns of all the other excel spreadsheets. So basically, If one of the values are "SELF" , I would like to calculate how many times that value occurs in all the spreadsheets. Any easier way to organize the data to be able to do this also.
One is just email addresses a@a.com b@b.com c@c.com etc.
The other contains data and also these email addresses I need to compare the 2 and when a match is found change the email address in the data table to something else, say "tony".
i am currently working on a file that counts things during the day and then sums them up. i have a different sheets for each day witch are named 28.07,27.07,26.07 etc'
i want the current sheet to pull data from the last sheet, lets say from cell I10. so if i'm working on the 28.07 - i use the formula " ='27.07'!I10' " and it works just fine. but i want to automate it. lets say make a cell in every sheet with the name of the previous one (i figured out how to automatically generate it) and make the formula pull from there. so lets say if i use the cell B2 for the value of the previous sheet (27.07) - it should look like " =B2!I10 "
Hello, I have a task that would take me hours to complete and I'm sure there's got to be a way to do it in Excel 2007. I need to get part numbers from one master cross reference spreadsheet to individual spreadsheets. The master cross reference spreadsheet has our company 7-digit number AND the manufacturer part number, while the individual spreadsheets only have the manufacturer part number. I need to have the individual spreadsheets match manufacturer part numbers and then insert our company's 7-digit number line-by-line.
I have about 10 open spreadsheets (the name of these changes each time but has a certain format). What I need to do is write some code to cycle through all the open spreadsheets and copy and paste the data into a single master spreadsheet. All these spreadsheets have a single worksheet.
I have a number of reports in excel (all in the same format) which I need to take certain data out of and store it into one main spreadsheet. Searching through the forums I found some code which I think will do this:
Sub test() Dim myDir As String, fn As String, ws As Worksheet myDir = "C: est" fn = Dir(myDir & "*.xls") If fn = "" Then Exit Sub Do While fn "" Set ws = Workbooks.Open(myDir & fn).Sheets(1) ws.Range("a7", ws.Range("a" & Rows.Count).End(xlUp)).EntireRow.Copy ThisWorkbook.Sheets(1).Range("a" & Rows.Count).End(xlUp).Offset(1) Workbooks(fn).Close False fn = Dir Loop End Sub I have tried using this code, altering the Dir String to the folder the documents are in.
However, when I run the code, nothing happens. I don't get any errors, and nothing appears in the spread sheet.
To be honest, I am not totally familiar with macros in Excel. I can get the gist of what the code is doing having using VB before, but am not totally familiar with some of the functions being used here.
How to import data from excel spreadsheets to a pdf form? I have a PDF form and was wondering if you could have the data from an excel speadsheet automatically go into my PDF form.
every month I import (from SAP) Local Authority staffing data for 200 schools into an Excel template. After a bit of tweaking I end up with a single spreadsheet showing formatted and adjusted data for all schools, with relevant headings separated by page breaks.
This is fine if for distributing a hard copy to schools, but I want to email it. I've seen macros that would allow data to be split onto separate tabs, but is there a way to break it down into 200 separate spreadsheets? I confess to not knowing any VBA, so be gentle with me
