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 Need help with an excel macro im trying to make

Hey guys I have a very limited knowledge in visual basic and i need some
help..........I would like some sort of macro that will take the data in
an entire row that I specify and copy that row and paste that exact row
and format into each row below it that contains a certain value in a
column............for example:

I have an excel sheet and in row 1 I have a lot of data, I need to be
able to search all of the data in the rows below it for the letter "D"
and every cell in the A colomn that has the letter "D" I need to paste
the data from Row 1 into that any row below it containing "D".......but
the rows also contain the letters "F" "G" "H" and I dont want the macro
pasting row 1 into any of those other rows that contain any other
letters.....there is around 6000 rows in all and I really do not want to
do each individually by hand and my visual basic skills are slim to
none.....hope you guys can help...........thanx

*** Sent via Developersdex http://www.developersdex.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
anyway to make a macro for all of excel mithu Excel Discussion (Misc queries) 6 March 21st 07 04:38 PM
how do I debug my Excel macro & make it actually WORK? Brainless_in_Boston[_2_] Excel Programming 13 February 16th 06 07:20 PM
How do you cut a paste a macro or VB language in Excel and make it Angela Excel Programming 13 December 8th 05 09:48 PM
Macro to make excel close grandfilth Excel Programming 5 October 20th 05 05:20 PM
Make a macro run automatically in Excel 03??? Rob Excel Programming 1 June 29th 05 07:29 PM


All times are GMT +1. The time now is 09:36 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"