LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 157
Default Select dynamic data in 2 columns, and repeat macro to next sheet

Can someone help me with a macro? I tried recording this, but the issue I am
having is that the data changes from sheet to sheet, and would change month
to month, so it won't always be the same.
I have about 15 sheets in my workbook, all set up with the same columns. I
am trying to select all cells with data in them in columns C and D, then will
run the rest of my macro I have already built. I just can't figure out what
to add to my macro that will select only cells in columns C & D with data in
them. What I want it to do, select all cells in columns C & D with data in
them, then my macro multiples the data in those cells times -1 to change the
debits and credits. I have everything else done but the selection. I will
run this macro on each sheet, so if you can help me figure out a way to run
the macro, then select the next sheet, run the macro, etc. to the end, that
would be great too! Otherwise I'm selecting each sheet, running the macro,
then proceeding to the next sheet.

Thanks in advance for any help you can give me!!
 
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
Macro to go to select sheet Kevin Excel Discussion (Misc queries) 2 December 18th 07 02:28 AM
Macro won't select columns Vick Excel Discussion (Misc queries) 1 August 17th 07 02:17 AM
select last cell in a dynamic list using a macro uncrox Excel Discussion (Misc queries) 4 July 19th 06 01:27 PM
macro sheet select Dave K Excel Discussion (Misc queries) 2 October 21st 05 10:08 PM
Macro, select Sheet "Number", NOT Sheet Name DAA Excel Worksheet Functions 4 November 30th 04 05:29 PM


All times are GMT +1. The time now is 08:35 PM.

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"