Moving items to a new page automatically

snoh8r

New Member
Joined
Jan 30, 2018
Messages
22
Office Version
  1. 365
Platform
  1. Windows
I'm trying to find a way to automatically populate the Category/Rank per site as unique rows on the Vendor – Upload Template Tab by us filling in the Vendor – Account Template Tab. Site information on the Vendor – Account Template Tab would be populated manually along with the Categories (upon learning what they are). I included some sample data on the Vendor – Account Template to simulate how things would be entered. I also manually populated the Vendor – Upload Template with what I would want the result to look like. I've tried to do this in formulas that just got way to convoluted. I was trying to do it without VBA. but I'm not sure it's possible. I'm not overly sure this can be done at all.
 

Attachments

  • Vendor - Account Template.JPG
    Vendor - Account Template.JPG
    157.6 KB · Views: 13
  • Vendor - Upload Template.JPG
    Vendor - Upload Template.JPG
    248.4 KB · Views: 14

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
To begin with, most of your sample data on the Upload Template does not match what is on the Account Template.

???
 
Upvote 0
To begin with, most of your sample data on the Upload Template does not match what is on the Account Template.

???
Actually, most of it does. The only goof I made was that I listed the one as Other Mechanical Services on the vendor upload template and Other mechanical on the vendor account template.
 
Upvote 0

Forum statistics

Threads
1,223,893
Messages
6,175,240
Members
452,621
Latest member
Laura_PinksBTHFT

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top