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...
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...
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...
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.