Hello,
I scrolled passed this forum for some time, looking for tips and tricks. Unfortunately, I could not find exactly what I was looking for, so I decided to open this thread.
I am looking for a more straightforward solution in Excel to fill a spreadsheet, automated preferably.
I can't post links as I am a new member. I can easily explain.
Spot 1 Spot 5
Spot 2 Spot 6
Spot 3 Spot 7
Spot 4 Spot 8
Its 8 spots, and all need to be filled. The data I want to fill it with comes in as "Bill DPS 1500" or "BILL SUPP 1500".
The only thing that actually matters is the DPS and SUPP. There is only room for 2 SUPPS and the rest of the DPS goes into the other 6 available spots.
I can provide the data in anyway that's needed to make it automated. Are there any addons or ways to do this? this would save me 10-15 hours every week. It would quite literally be life changing.
Thank you before hand.
Is it common to hire someone to set up a functioning excel for this type of work? Cause it seems to be quite a lot of work
Bookmarks