Geekzone: technology news, blogs, forums
Guest
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.


KillerHulk

348 posts

Ultimate Geek
+1 received by user: 24


#262133 7-Jan-2020 09:54
Send private message

Hi All,

 

I would like to see if there is a simple / easy process to populate data from 2 workbooks, so that i can Upload a CSV file into our ERP system.

 

First Workbook : contains 600 products with (contract Prices)

 

Second Workbook : contains 70+ customer account numbers

 

Now, i Need a simple way to create a 3rd Workbook where i have all the Products from 1st Workbook towards each customers from 2nd workbook.

 

3rd Workbook will have columns : Customer Account No. | Product | Price

 

On Windows 10 - Office 365

 

Thanks in advance...





I Eat Dumbbells for Breakfast


Create new topic

This is a filtered page: currently showing replies marked as answers. Click here to see full discussion.

Deamo
144 posts

Master Geek
+1 received by user: 63
Inactive user


Create new topic








Geekzone Live »

Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.



Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly to your computer or smartphone by using a feed reader.