nyc

  1. E

    How do you pull particular information out of a single word cell in order to shorten it?

    Two charts below, chart 1 "First" and chart 2 "update". I want to be able to take A1 in "first" and shorten it for say "TennisBalls, LLC nyc Champion" in A2. Same for A3/A4 with Brick, LLC. I have 1000 invoices I need to shorten by just saying the vendor name rather than the full bill payment...
  2. tbablue

    For Next loop - introducing a variable to control my macro

    The rudimentary code below passes a value to the macro PRINTz_ONE, runs PRINTz_ONE then introduces the next value, .......... and so on. Sub PRINTz_GRP() On Error Resume Next With Range("SITEx_PICKER") .Value = "ROLLED-UP": PRINTz_ONE .Value = "NYC"...
  3. P

    VBA to Automatically insert row based on cell text in current row (with partial data)

    Hi Guys, Sorry if this is an easy question, I'm a VBA beginner. This is a training tracker used within our team. Is there a module that; automatically detects cell value "Did Not Attend" in column "J" and if TRUE - inserts a duplicated row below (without the cell data of "J" & "L:S") Many...
  4. T

    Where to get consultation for my huge excel model?

    Hi all, I have found this board extremely helpful for individual problem solving. With all the knowledge here, I also thought it might be helpful for recommending professional excel/access experts. For the last year I've been building/using a somewhat complex and dynamic test analysis program...
  5. D

    VBA practitioners in NYC

    Are there any VBA practitioners in NYC who would like to meet up once a month and talk shop over coffee? -Jason

We've detected that you are using an adblocker.

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.
Go back
Back
Top