Text Recognize and Column select

Copper Contributor

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.

 

 

4 Replies

@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:

DateAcct NameProductAmt
1/2/2023GeorgioClipper$40.50
1/3/2023MichaelaSkipper

$156.75

1/3/2023MichaelaClipper$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:

BobSue
1213
1314
1416
1512
1813
1314
16 

@mtarler yes that is how I want to do it.

I will try the power query and see how that works for me.

 

thank you for your help.