LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Duplicating rows and changing cells

I am very new to VB programing and already found myself in a problem.
want to split some rows with info according with some cells values o
col A and B. And When i split those rows i also want to change th
value of those cells. For example:

I want to transform this:

1 1 MP3_Music
2 3 Wave_Music
4 4 MP3_Music

Into:

1 1 MP3_Music
2 2 Wave_Music
3 3 Wave_Music
4 4 MP3_Music

I though in using a ABS to see if i have a difference in a row. If tha
was true then the macro would add a new line. My problem is making th
macro search for for every difference for 200 or 300 lines and chang
them.

Is probably a dumb question but as i said before i am very new t
this..

TIA

Vito

--
Message posted from http://www.ExcelForum.com

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
duplicating rows Patty Excel Discussion (Misc queries) 1 May 10th 10 07:26 PM
Formula for Duplicating Rows J4mesD4wson Excel Discussion (Misc queries) 3 April 1st 09 06:07 PM
Duplicating rows help needed ArthurN Excel Worksheet Functions 3 October 28th 07 09:41 PM
Duplicating Rows Based on Cell Value [email protected] Excel Discussion (Misc queries) 6 September 19th 06 11:35 PM
Formula for Duplicating Rows!! GOL Excel Discussion (Misc queries) 2 May 22nd 06 08:54 PM


All times are GMT +1. The time now is 10:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"