BLACK FRIDAY SALE 20% OFF ALL COURSES

Catalin Bombea
Iasi, Romania
Member
Dashboards
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service

Forum Posts: 1864
Member Since:
November 8, 2013
November 8, 2013

Hi Lea,
How do you want to merge them into 1 file? In a single table or in 2 separate sheets?
JE-after.xlsx does not have Employee code, so you don't have keys to merge them in a single table, you will have to use 2 separate queries that will be loaded into 2 separate sheets in the same file.

lea cohen
Member
Members

Forum Posts: 241
Member Since:
March 10, 2016
March 10, 2016

I combined the 2 tables from 2 sheets - the consolidated file in sheet 2 sheet
- Now I have another problem.
I need the data from the column JE GL code-
Will be below the data of the GL CODE page.
So that under the columns E F G
I need the data from the columns H I J
Thanks!!!!!!!! Leah
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Andrew Scott, El Riz, Adam Cheetham, Tracy Lippiatt, Mostafa Younes
Guest(s) 11
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1864
SunnyKow: 1432
Anders Sehlstedt: 886
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 241
Hans Hallebeek: 222
Jessica Stewart: 219
A.Maurizio: 213
Newest Members:
Karen Childress
Ben Penney
Karen Quagliano
Natsuko Kojima
George Girhiny
Jack Ennis
Andrew Griffin
Mostafa Younes
Alan Lim
ken lee
Forum Stats:
Groups: 3
Forums: 24
Topics: 6637
Posts: 29114
Member Stats:
Guest Posters: 49
Members: 33046
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —
