Macro to delete lines and change cell values

**prvimoon** · 04-11-2019, 04:39 PM

Hi,

I would like a macro that can do the following:

If Columns L and M has just the number 0 in the cell, delete the line.
Replace the values in Column G so that the text "1 of 1" -> "1", "2 to 2" -> "2", "1 to 3" -> "3", "1 of 10" -> "10". Basically, changing the cell value to the last number.
Replace Column R's cells if it has something in the text, for example looking for "General Admission" in "Example Super Ticket General Admission" and change it to "GA" or looking for "VIP Admission" in "Test Camp Special VIP Admission" and change it to "VIP".

I've attached before and after XLSX files to show what I mean. Thanks!

**JLGWhiz** · 04-11-2019, 05:15 PM

Please Login or Register  to view this content.

This assumes data begins in row 2. If not, change the number in red font to the correct row number

**prvimoon** · 04-11-2019, 06:27 PM

Thanks, works like a charm! Now I'm just missing the last part to replace Column R's cell values to the ones I want.

**JLGWhiz** · 04-12-2019, 09:53 AM

Originally Posted by prvimoon

Thanks, works like a charm! Now I'm just missing the last part to replace Column R's cell values to the ones I want.

You're welcome. You can probably do the cfolumn R changes using the Replace All feature in the Excel Find/Replace dialog box from the Home tab of the ribbon. If you can list all of the target strings you want to replace with their corresponding replacement values, I could incorporate that into the other code.

Maybe you can modify this code which uses the two examples you listed.

Please Login or Register  to view this content.

**prvimoon** · 04-12-2019, 03:26 PM

From my test of the data provided in the thread and on the original worksheet, the modified macro works great on both and does everything I need it to do. Thanks again for all of your help!

**JLGWhiz** · 04-12-2019, 03:46 PM

Originally Posted by prvimoon

From my test of the data provided in the thread and on the original worksheet, the modified macro works great on both and does everything I need it to do. Thanks again for all of your help!

You're welcome,
regards, JLG

Macro to delete lines and change cell values

LinkBack

Thread Tools

Rate This Thread

Display

Macro to delete lines and change cell values

Re: Macro to delete lines and change cell values

Re: Macro to delete lines and change cell values

Re: Macro to delete lines and change cell values

Re: Macro to delete lines and change cell values

Re: Macro to delete lines and change cell values

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] change macro to delete values in rows

[SOLVED] Combine values from multiple cells into one cell, then delete duplicate lines

[SOLVED] Need Macro to Distribute Values within a Cell to Multiple Lines

[SOLVED] Macro - To change cell fonts whenever their values change

[SOLVED] Macro to Delete useless lines, rearrange by dates and skip lines between different days.

[SOLVED] Macro to Delete Rows and Change Cell Values

macro - look for change in cell, delete other cells

Bookmarks

Bookmarks

Posting Permissions