Forum Discussion
Using Indexing solution with formula to merge two sheets of data into a single sheet help
Hi, I'm trying to find a way to merge two sheets. Sheet1 has all the variables to which I've tried to assign an index number. Sheet 2 has the definitions of all the variables from sheet 1. M...
The source file was sent over with lots of bugs in the VBA, so the best way to get the data was to import it with PQ. I'm trying to use the cable sheet and match the raceway sheet together—the cable sheet acts as the definitions of the 'cable numbers' column for the raceway sheet. If you sort the 'TrayRaceway' sheet 'Line No' Column smallest to greatest this may show a better idea of what I'm trying to do...
al_baum Sorry! You've lost me. Both sheets have 2089 rows and, at a glance they seem to be identical.
al_baum Okay, I believe I managed to replicate your merge query of the two tables. Can sort the list as suggested but now what? Attached my working file with queries connecting to static tables within the workbook. What would the end result have to look like?
- Ah yes, all the times I've scratched my head by doing that 🙂 Again, thanks for helping me with this!
al_baum Ah, I must screwed up copying and pasting. Sorry. Will get back to you if not someone else does. Diner time for me now.
Riny_van_Eekelen, hmm...that weird; I've uploaded a new one. Try this one...