ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Formula Assistance (https://www.excelbanter.com/excel-worksheet-functions/177211-formula-assistance.html)

tglstar

Formula Assistance
 
We have two large spreadsheets and both contain a common SS field. I need to
combine both sheets by the ss field. They don't have uniform formatting or
columns throughout. I have tried a Pivot Table and vlookup to no avail. HELP!

Otto Moehrbach

Formula Assistance
 
Be more specific. Say you have one row in one sheet and one row in the
other sheet, both rows have the same SS.
In what columns in which sheets are the SS numbers?
What columns from which sheet do you want put into what columns of the other
sheet? Otto
"tglstar" wrote in message
...
We have two large spreadsheets and both contain a common SS field. I need
to
combine both sheets by the ss field. They don't have uniform formatting
or
columns throughout. I have tried a Pivot Table and vlookup to no avail.
HELP!





All times are GMT +1. The time now is 01:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com