Joining Two Spreadsheets

Nov 13, 2009

I have two spreadsheets, A & B. A can be thought of the master spreadsheet and has one record for every employee giving personal information, including a personel number. B has 0, 1, or 1+ records for every employee in A. Each of these records has a personel number. I want to copy the value of a specific field from B to A.

For example:

A:
personel number1
personel number2
personel number3

B:
personel number1, 'sally'
personel number1, 'john'
personel number3, 'pete'

merge A & B:
personel number1, 'sally', 'john'
personel number2
personel number3, 'pete'

View 5 Replies


ADVERTISEMENT

Joining Columns One Below The Other

Apr 11, 2013

Imagine I have some columns of data. How can I stack multiple columns on below the other in column A?

For example, A column is blank now. B,C,D have some data.

A
B
C
D
1

[Code]...

Can all the columns be stacked in the empty column A?

A
1
ab
2
cd

[Code]...

This is just an example. I have 8000 columns in reality.

View 2 Replies View Related

Joining Columns

Mar 28, 2008

I have 2 columns of Data that contain address fields.

SHEET1
Address1 Address2
%MW4003 %MW4004
%MW5643
%MW9878 %MW9879
%MW13002
%MW5643

etc

The address2 Column is based on a formula.

What i need to do is combine the 2 columns together in another sheet in a column. I do require duplicates to come through, and ideally i need it sorted.

SHEET2
Address
%MW4003
%MW5643
%MW5643
%MW9878
%MW9879
%MW13002

View 9 Replies View Related

Joining Two Datasets Together (VBA Needed?)

Jun 19, 2014

So I have two sets of data, I've attached a worksheet which has them both. The datasets have different intervals, but I need to drag "Colour" from Data2 into Data1 and associate it with the correct interval. Sometimes the intervals match up and sometimes they don't - which could be a problem, but as long as its within a small spread it's fine. The "Colour" column in Data1 is filled with my desired result, the source being Data2.

ManyToMany_Example.xlsx

View 3 Replies View Related

Joining List Of Numbers

Sep 27, 2012

I have a list of numbers from cells A1 to A150 (they are five digits long), I need to join them together preferably with a the following format '12345', I have tried concatenate but it would take too long to type it all out.

View 2 Replies View Related

Joining Tables From Different Workbooks?

Jul 3, 2013

I have same tables(same name of columns in all tables) with different data in 30 different workbooks...can I somehow merge data from all tables in one table?

View 2 Replies View Related

Joining Value If Condition Is True?

Feb 19, 2014

Below is the data layout. I want to join values in value column if Condition is true. SO, for below situation answer should come ACE.

TRUE
A

FALSE
B

TRUE
C

FALSE
D

True
E

View 2 Replies View Related

Joining Text Strings

Jul 28, 2006

I have to cell values that are strings and I want to add the two string values together to form a sentance, when I do this using a + sign or a & sign there is no space between the 2 strings, how do I get a space?

View 3 Replies View Related

Salary Calculation By Joining Date?

Feb 10, 2014

I am prepare budget salary base on actual joining date and budgeted joining date. I can only manage to get the formula by joining month not by joining date

View 10 Replies View Related

Joining Two Cells Data With A X Mark In Between Them

Jan 28, 2013

i have two entries in my excel sheet which i want to get noted in the other cell as follow

A B
1 ORDER NO. 480
2 GOODS 5
3 P.M 480X5

as my table have data in B1 AND B2 so i want B3 automatically becomes 480X5 so how can i do it

View 2 Replies View Related

Joining Modules With User Forms

Jun 6, 2009

I have the following three codes repeated in five different User Forms,

Is there a way to put them all in one independent module?

View 14 Replies View Related

Joining A Range Of Cells Into A String

Dec 16, 2008

I feel like I should be be able to do something like Join(Range(XX)," ") to create a space-separated string of values...

Have I missed an easy one-liner, versus one by one concatenating the value from each cell?

In this case, I am doing exactly that - taking 4 columns of more or less unimportant data and cramming them into a single column just in case they are needed someday.

Sub Test()
Dim strTemp As String

strTemp = _
Range("C2").Value & " " & _
Range("D2").Value & " " & _
Range("E2").Value & " " & _
Range("F2").Value
'//Result: strTemp = "a b c d"

'//This fails - is it possible to do something like this
strTemp = Join(Range("C2:F2"), " ")

End Sub

View 9 Replies View Related

Joining And Inserting Rows From Two Sheets

Feb 27, 2007

I read several forum questions for data join and merge but not found a solution for the following scenario. Is possible do it ALL in one macro? I have two different xls files.

file1: sheet has the following structure
refcode price count
XXBK443 200.0 3
KKKN339 333.0 2
etc..

file2:sheet1 has the structure
refcode prod_name color height
XXBK443 prodname1 green 10
ZZZZ000 prodname2 yellow 22
KKKN339 prodname3 white 15
AAAA111 prodname4 white 30
etc..................................

View 3 Replies View Related

Joining Data Across A Range Of Cells/columns

Jun 30, 2009

Can someone pls. assist me with obtaining an Excel or VBA solution for joining data from across a range of cells/columns into one cell? The single cell containing the intended output has to include the name of the source(s) that are noted on the header column and the price corresponding to each source but would exclude the sources which did not have pricing data. Example of logic is noted below:

Cells B1 - D1 contains names of pricing sources.
Cells B2 - D2 contain prices from these pricing sources.
Intended output: Cell E2 would have the names of all the pricing sources that had prices as well as their corresponding prices; but would exclude those that didn't.

Lastly, pls. see attached Excel file for format of data and intended output in Column E.

View 8 Replies View Related

Joining Two Formulas - Cell Right Text And Sum Column

Apr 10, 2012

Here is my data:

Column A: Entries
Column B: New Entry
Column C: Total New Entries

Version:1.0 StartHTML:0000000105 EndHTML:0000004087
StartFragment:0000001523 EndFragment:0000004041
****** http-equiv="Content-Type" content="text/html; charset=utf-8">
****** name="ProgId" content="Excel.Sheet"> ******

[Code] .......

Formula in B2: B17
=IF(RIGHT(A2,10)="_New Entry",1,"")

Formula in C1
=SUM(B2:B17)

I would like to remove Column B, and add the formula in C1 itself. Column B is not of any use, it is just showing which is a new entry and C1 is totaling all the New entries, which is in this case is 4.

I need a formula something like this:

=SUMIF(B2:B17,IF(RIGHT(B2:B17,10)="_New Entry",1,"")))

View 3 Replies View Related

Date Of Birth And Joining Date, In The Format "mm/dd/yyyyy"

May 24, 2007

I have database of my entire staff with thr date of birth and joining date, in the format "mm/dd/yyyyy".

I want if the date of birth is equal to today()+1, that means if someone is having his b'day on 25may ,and today is 24 may so its cell colour should turn into red.

I know conditional formatting is to be used here. but bit confused with the formula.

I am trying with this
=IF(TEXT(C3,"dd-mmmm")=TODAY()+1,true,FALSE), but not working.

means I want if someones b'day is coming , I want to ge t informed earlier.

View 9 Replies View Related

Turn The F1 Key Off In Spreadsheets

Dec 5, 2008

I'm going to turn the F1 key off in my spreadsheets so that I do not hit it by accident so manytimes, but how do I bring up help without it?

View 5 Replies View Related

Combine Several Spreadsheets Into One

Jun 24, 2009

I am so frustrated to combine several spreadsheets into all in one, and seperate all in one spreadsheet into several with the same header frenquently. Pls check the attached example excel spreadsheet., could anyone teach me how to program in vba to achieve the result as above?

View 6 Replies View Related

Merge 2 Spreadsheets?

Nov 23, 2009

I want to do....is...a macro or something....to be like "Hey...were going to match up column information based on the first column, there exists both the same data in both sheets....as you can see in A3 and A2, now, I want to be able to add the information that is in book1, into the "DBL approved", so like...the 2nd row, I want columns B-G to be filled via book 2 because its saying,

"okay, A3 in DBL has the data 00-120-01, but there exists no data next columns over...but oh look, A2 in Book1 does, let's fill in that missing information!" so now it'll fill in the bullet points, brand, segment, etc."

View 4 Replies View Related

Linking Two Spreadsheets

Aug 5, 2008

I am working with excel2003. I have to different workbooks in which on is a Bill of lading that is used to show the items being shipped. The other workbook has a list of the items that we ship.

On the BOL I want to be able to type in the "L" number (or I.D. number) in D14, D19, D24, D29. By typing in the L-number I want it to automatically bring up the product name into cells E14, E19, E24 and E29. With the exact name of the item it will help prevent employee error. I want it to also bring over the exact weight over from the flavor list in cell range C5:C28.

I have the FlavorCodes range with all the L-numbers on the BOL in cell range U9:U48. I thought I had it set up correctly but when I select the L-number in the drop down list in cells E14, E19, E24 and E29 I get error code #NA. I thought I defined the cell range but it is still not working.

The workbooks are attached below.

View 12 Replies View Related

Data In Different Spreadsheets

May 21, 2007

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

View 14 Replies View Related

Comparison Of Two Spreadsheets

Mar 6, 2009

I have two spreadsheets, The spreadsheet #1 has the information of two years and the Spreadsheet #2 is a montly report. The Spreadsheet # 1 hasta on the column A a number of transaction, and at the column Q the invoice number. The Spreadsheet # 2, only has in the column A the Invoice number. I need to find in the Spreadsheet # 1 the Invoice numbers that match the Invoices that I have in the Spreadsheet # 2 by bringin the "Number of Transaction".

For example:
Spreadsheet 1:
Has on column A3 the Number of Transaction # 0123, and at the column Q3 the Invoice number 555. At the Spreadsheet number # 2 I have the INvoice # 555 located on A10. I need to know what is the transaction # by adding a formula in a new column (G) so I want to have the Transaction # 0123 in the new column added G.

If I do this manually it will take me hours since these report and the Master is so big, and right now I am doin it using Ctrl-F

View 15 Replies View Related

VLOOKUP Across 2 Spreadsheets?

Nov 1, 2011

I have two spreadsheets (lets call them Spreadsheet A and Spreadsheet B). Spreadsheet A is a list of all my customers and Spreadsheet B is a list of potential leads which may or may not include some which are already customers. Is there a formula I could include in an extra column to highlight which ones are customers already so that I can ensure I don't call them.

If it makes a difference the two spreadsheets are stored on seperate locations on my computer.

View 7 Replies View Related

Changing 503 Spreadsheets At Once

Jul 10, 2008

I have been handed 503 spreadsheets containing system data for multiple business units in my company. Each spreadsheet is identical in structure (same column headings) but just varies in the number of rows of data

I’ve now been asked to add (4) additional columns to each of the 503 spreadsheets. The (4) new columns are to be called:

“Class”
“OpCat Template ID”
“Agent”
“Last Occurrence”

And added in columns L, M, N, and O.

Is there a way to do this automatically instead of having to manually enter this data 503x?

View 9 Replies View Related

Get Data From Several Spreadsheets

Feb 5, 2009

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

View 9 Replies View Related

Linking To Other Spreadsheets

Jan 4, 2010

Is it possible for me to link to other spreasheet data, and have the links update (retrieve the data) without those files being opened?

View 9 Replies View Related

Shared Spreadsheets

May 20, 2006

I have a spreadsheet which needs to be shared by 10 people. The spreadsheet is fairly simple but I don't know the best way to do this. I have heard of public folders or to share the .xls.

View 4 Replies View Related

Countif With 2 Spreadsheets

Jun 28, 2006

Im using this code. My data is in column A from Cell A2-A65000, and the data I want to compare against is in a different sheet col K cells k2-k65000. I need it to compare column A on "Sales Reps" against Col K "Data Sheets" and count how many times whats in cell A2-A65000 occurs on in Cells k2-k65000. So if 689 was in cell A2 and was listed in cell k3, k4, k5, it should return the value 3 in Cell B2. My formula is not working. Getting an error.

For Each ce In Range("a2:a" & Cells(Rows.Count, 1).End(xlUp).Row)
ce.Offset(0, 1) = WorksheetFunction.CountIf(Sheets("Data Sheet")(Range("k:k"), ce.Value))
Next ce

View 8 Replies View Related

Comparing Two Different Spreadsheets

Jul 29, 2006

I have three different spreadsheet, Spreadsheet A with the name of all the clients of the company. Spreadsheet B with the name of all the clients in Toronto and Spreadsheet C with the name of all the clients in Montreal. Now i have to create a fourth spreadsheet to lookup the clients who are not in the Spreadsheet A (basically trying to find new clients). How do i search for the new clients in all the three spreadsheet?

View 2 Replies View Related

Linking Spreadsheets

Jan 14, 2007

I have sucessfully created a spreadsheet which links to another using a vlookup and an array. I now need to reverse the process. My requirements are this:

I have individual spreadsheets which represent individual projects/quotes for our customers. I'd like each of our sales staff to have a summary spreadsheet which summarises all their ongoing projects in one spreadsheet, dynamically.

when a new project is created on a new (projects/quote) spreadsheet, it looks to the summary spreadsheet and looks to see if that project exists in the summary, if not, it creates a new line and writes the summary details to it. then as the project spreadsheet evolves, it updates its details on the summary sheet dynamically.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved