Using information in certain cells to create text that can be exported to another system.

GlasgowF

New Member
Joined
Apr 6, 2021
Messages
3
Office Version
  1. 365
Platform
  1. Windows
I've seen this done before and cannot for the life of me remember how to get it up and running, so what better place to ask after being a lurker for the last 10 years or so.

Problem

I am looking to create a solution that allows me to pull specific data from cells that allows me to create reporting in text format, ideally with the cell headers corresponding
1617711115914.png


I-e -
Customer - John
Project Scope - New install
Date requested - 1st May 2021

Customer - Alice
Scope of Work - Repair

The above example is just an example I created to give an idea of what I am looking for in theory.

Also an added issue that not all information in the workbook is relevant. For each row of around 100 cells, there are maybe 20 cells that would be relevant to the scheduling ticket this is looking to create.

I know there is a few ways of doing this, so any suggestions would be much appreciated.
 

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

GlasgowF

New Member
Joined
Apr 6, 2021
Messages
3
Office Version
  1. 365
Platform
  1. Windows
A bump for anyone who is able to give some guidance
 

GlasgowF

New Member
Joined
Apr 6, 2021
Messages
3
Office Version
  1. 365
Platform
  1. Windows
nobody?

I've worked out a way of doing it with an unpivot but not really staff friendly. Must be an easier way?
 

Watch MrExcel Video

Forum statistics

Threads
1,130,143
Messages
5,640,384
Members
417,140
Latest member
whiteprose

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
Top