-
Jan 21st, 2013, 03:11 PM
#1
Thread Starter
New Member
Macro Button To Distribute Data Dynamically
Hey guys I'm trying to figure out how to write a macro that will take the information of a column and distribute it throughout multiple worksheets. I'm trying to get the data in cell I6 of my summary sheet into cell B51 of the following sheet, and then I7 of the summary sheet into B51 of the sheet following that and so on. I honestly don't know where to start as I am almost completely new to VBA (most of my programming background is in HTML) so any help would be great! I've already got a variable that defines all of the worksheet names called 'shtName' if that helps at all.
-
Jan 21st, 2013, 03:16 PM
#2
Re: Macro Button To Distribute Data Dynamically
sometimes the quickest way is to record a macro, perform the actions (or part of the actions) yourself by hand... stop the macro, then look at the code in the macro... it should show you what you need, from there it's just a matter of simply modifying that code to finish it off.
-tg
-
Jan 21st, 2013, 03:22 PM
#3
Thread Starter
New Member
Re: Macro Button To Distribute Data Dynamically
I appreciate the advice. I tried it but as far as I can tell the code you get from doing that is no more dynamic than just going through each worksheet and linking the cells (which is what I'm trying to avoid doing).
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|