• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 296
  • Last Modified:

excel, vba, string parsing, automation, vlookups

A bit of a tricky task (for me).

In the attached example, I need the before tabs (1 and 2) to look like the after tabs (1 and 2).

There can be any number of names and /'s.

There are multiple before tabs
1 Solution
Ken ButtersCommented:
See attached spreadsheet.

Code is added to module1.

to run - execute macros ... select "parse"

Note : hard coded to loop through all the sheets in the workbook, but to skip over sheets whose names start with "after".
newparadigmzAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now