Forum Discussion
Text Recognize and Column select
Good day
I want to set up my columns with names.
When I insert text to excel in the workbook I need Excel to recognize new key words and know which column to select.
wicos280 really not sure what you mean. maybe explain more and give an example. But you can't name a column on a sheet but you CAN define a TABLE and the table WILL have named columns. For example you can type:
Date Acct Name Product Amt 1/2/2023 Georgio Clipper $40.50 1/3/2023 Michaela Skipper $156.75
1/3/2023 Michaela Clipper $81.00 Then highlight that whole range and on the Home tab select Format as Table and make sure the use first row as headers checkbox is clicked
Now your column headers for the table are Date, Acct Name, Product, and Amt
mtarler Thank you for your response.
I am using scan it to office to scan Qr codes in Excel.
like the date, acct names in header there will be names.
the names also has a QR code.
When I scan something it all adds underneath each other.
butt I want to scan the name like Jake or Chris and Excel must jump to the Column with that name as header.
so every time I scan a different name Excel needs to jump to the column with that name in the header.
ok let me see if I get this right
so you are scanning QRcodes and those values go into Excel and Excel auto increments to next row
but you want to scan 'Bob' and then 1 or more items that go under 'Bob' and then when you scan 'Sue' you want to scan 1 or more items that go under 'Sue'
I don't think this is possible from excel in any default behavior
I was hoping you could define a table and have excel fill the table left to right and then go to the next row (I know that isn't exactly what you wanted but then you could create a table Name - Value and then using pivot table or similar create the table in the format you like), but I don't know if there is some setting somewhere to do that (it didn't work by default)
This could be done using a macro, but macros / vba must be enabled and don't work on excel online so i don't know if this is even an option.
Finally you could create the 'List' and then use power query or formulas to re-format the data:
Bob
12
13
14
15
Sue
13
14
16
Bob
18
13
16
Sue
12
13
14
and then you can use either power query or formulas to take that column of data and make:Bob Sue 12 13 13 14 14 16 15 12 18 13 13 14 16
