Tom Urtis (@TomUrtis) | teapawt

Tom Urtis@TomUrtis15h

Keyboard shortcut to select the next or previous worksheet.

16

918

Tom Urtis@TomUrtisOct 22

Identifying the source row and listing a selected record's contents of a ListBox having vertical field dividers.

10

920

Tom Urtis@TomUrtisOct 21

Showing a vertical divider between ListBox fields without affecting the worksheet or source data range.

6

701

Tom Urtis@TomUrtisOct 20

Parsing a string at the position of the first numeric character.

7

791

Tom Urtis@TomUrtisOct 20

Reordering field locations in a VBA array.

17

1,169

Tom Urtis@TomUrtisOct 19

Selecting all worksheets as a group, or deselecting all but one worksheet.

9

827

Tom Urtis@TomUrtisOct 17

Selecting more than one worksheet as a group.

16

997

Tom Urtis@TomUrtisOct 16

Showing your active window's named ranges by setting its Zoom property to 39% or less.

5

702

Tom Urtis@TomUrtisOct 15

Reordering field locations in a VBA array.

8

994

Tom Urtis@TomUrtisOct 14

Operating with the last number in a dynamic list.

9

920

Tom Urtis@TomUrtisOct 13

Showing elapsed times with custom formats for hours, minutes, and decimalized sums.

1

12

1,053

Tom Urtis@TomUrtisOct 12

Extracting text between character sets of differing types, lengths, and instances.

1

7

861

Tom Urtis@TomUrtisOct 11

Open a new Word document from Excel with this macro.

7

1,610

Tom Urtis@TomUrtisOct 9

Listing incremental cell values into a contiguous range, using two function alternatives: OFFSET and INDEX.

1

15

1,101

Tom Urtis retweeted

Ken Puls, FCPA, FCMA@kpulsOct 8

Many will argue #Excel is NOT a database.🥊 But, at our Nov 5 Vancouver #PowerBI and Modern Excel meet-up, Richard Nero will show how in a few clicks you can turn Excel workbooks into cloud based #SQL databases that fuel #AIAgents. Sign up here to join us: meetup.com/vancouver-power-b…

Excel as A Database and AI Agent Fuel | Richard Nero, Thu, Nov 5, 2026, 9:00 AM | Meetup

**SESSION TRACK:** Excel **SESSION OUTLINE:** Many will argue Excel is not a database. Well, Microsoft MVP Richard Nero will show how in a few clicks you can turn Excel wo

1

399

Tom Urtis@TomUrtisOct 8

Counting multiple criteria in more than one criteria range.

17

1,033

Tom Urtis@TomUrtisOct 7

Looking up the max (or min or average) for each unique item in a list.

18

1,772

Tom Urtis@TomUrtisOct 6

Converting text (non-number) percent values to real decimalized numbers.

1

16

1,646

Tom Urtis@TomUrtisOct 6

Opening PowerPoint and running a presentation slideshow from Excel.

9

1,373

Tom Urtis@TomUrtisOct 4

Disabling the pop-up menu when right-clicking onto a worksheet tab.

16

1,645