Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
PLZ! Help me out with this "killdupes" script
I have a huge problem. I have a xls. file being created as an export from another program. It has a number of worksheets that i have to analyse with vba-script in excel 2002 as follows: 1. on each worksheet in column A beginning with 4 row and ending with the last not empty row i want to check if there are strings with same text before "-"symbol and if there is - delete that whole row. example BEFO textb texta texta-44 "texta-44" should be deleted. but only the cell with fewer symblos should be deleted (not "texta" in this example) AFTER: textb texta 2. Then check on every two sheets in column "A" : if there is a text on one sheet same as text on the other sheet (in any row of column A) and if there is put that text in the msgbox along with the names of the sheets, that share this text. for example if we take sheets from previous example to do that it would result in: MSGBOX will say "in sheet "BEFORE" and sheet "AFTER": textb, texta. in sheet "x" and "y": abc" where x and y are names of the sheets and abc is a text that is in sheet x and in sheet y. and this way process all possible pairs of sheets in the workbook. this is all too tough for me.. probably someone of you will be able to do this challenge. i would REALLY appreciate. -- popovsky ------------------------------------------------------------------------ popovsky's Profile: http://www.excelforum.com/member.php...o&userid=25309 View this thread: http://www.excelforum.com/showthread...hreadid=388258 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
VB Script: Code for "Sheets in selection" | Excel Discussion (Misc queries) | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |