-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
key1
-
P
Transpose every 2 columns into new row, moving to new row after last column
Hi there, I have a sheet in the following format <tbody> Date Key1 Attr1 Key2 Attr2 Key3 Attr3 Key4 Attr4 1 Jan 2019 1 23 3 43 3 25 1 54 2 Jan 2019 2 23 2 23 2 54 2 23 3 Jan 2019 4 25 1 54 4 43 2 34 4 Jan 2019 3 23 4 23 2 32 4 23 5 Jan 2019 1 27 1 24 1 14 2 44 </tbody> which I want...- prshntmv
- Thread
- columns jan key1 row transpose columns
- Replies: 3
- Forum: Excel Questions
-
P
Compile Error on Sorting
I'm trying to insert a line of code at the end of my macro that will sort the list alphabetically. I keep getting this compile error and it points to the word Key1 in my line of code saying that it expects the end of a statement With Sheets("Doc Checklist").Range("C2:C500").Sort...- Pat_The_Bat
- Thread
- code compile error key1 line
- Replies: 3
- Forum: Excel Questions
-
G
Parse cell using patterns
I have a series of patterns that I am searching for in a cell. For each pattern I find in the cell, I want to parse the matching string and write it to a new row in a new worksheet, along with a key value in a separate cell. I am writing a function in a module. I am able to use the like...- GregFullington
- Thread
- c.value cell key1 key2 parse
- Replies: 6
- Forum: Excel Questions
Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.
