I need help

Diabase

New Member
Joined
Oct 2, 2020
Messages
1
Office Version
  1. 2013
Platform
  1. Windows
Hello, here's my project:

I want to use excel to do a mail merge in order to create a custom pricing sheet. I have already done this. I have created a database with say, 7 worksheets or so. Data is grouped and separated among the 7 worksheets. Example: customer info (name, title, phone, cell) is on worksheet 1. Company data is on worksheet 2. Items ordered on worksheet 3. (This is a simplified explanation.) The reason I divide the info up is because there are so many fields that to have them all on one worksheet would be inconvenient.

I then have a master worksheet which is linked to all 7 of the data gathering worksheets. All the data from the 7 worksheets end up in a single master worksheet by using the formula =worksheet1(a1) kinda thing.

I use the master worksheet to do a mail merge to create my pricing sheets.

My question is, how can I do this better? I have zero knowledge of Macros, although I am not afraid to learn something about them. I just learned about Power Query today. Could Power Query help me do this better? The problem with the database as it is now is that it is really cumbersome and slow.

If anyone can point me in the right direction by sharing an article or something, I think that would really help me.

Thanks.
 

Some videos you may like

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

Watch MrExcel Video

Forum statistics

Threads
1,118,775
Messages
5,574,159
Members
412,574
Latest member
shadowfighter666
Top