Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

Excel VBA match and align cells

Comment:

I have two columns of info that i need to sort alphabetically, matching up cells that are the same and leaving gaps where not. e.g: Start with: aa bb cc aa aa dd dd dd end with: aa aa aa bb cc dd dd dd

Reply:

Example should be( the "__" are just to seprate the example columns):- Start with: aa___bb cc___aa aa___dd dd___dd end with: aa___aa aa___ _____bb cc___ dd___dd _____dd

0

computer freeze

Shut down window

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: It's easy to do for single quotes.... In Excel, highlight your range of cells. Click Format (on the menu bar) then Cells. Then click "Custom" under the category list box. In the textbox under "Type"...

Summary: I completed a spreadsheet using Excel with Visual Basic. It is to be used by several different users. I forwarded the spreadsheet to several users. Most were able to open the excel file and use it....

Summary: I installed Music Match 7.5 plus and it works fine as administrator but will not work as limited users. I want to allow my kids to be able to use the program but I would rather they not be set up wit...