Here is my current Macro. What I want is on the new sheets that are created for the information to start on Row 6 instead of Row 2 (Just like on the Master Sheet). How do I do this? Attached is the sheet for your review.
Please Login or Register to view this content.
Last edited by Caedmonball19; 08-23-2013 at 03:00 PM.
Why make an new question. It looks to me this an duplicate post (to me).
http://www.excelforum.com/excel-prog...41#post3377741
This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
I started a new one as I felt it was beginning to stray from my original dilemma. I apologize for breaking Rule 5 of your forum rules. I did also edit my post so I was no longer breaking Rule 3.
Last edited by Caedmonball19; 08-22-2013 at 05:43 PM.
Hi caedmonball19
I agree...this issue is a New Issue from your previous sited Thread. Now, having said that and not knowing what you're trying to accomplish, to paste the copied Data into Row 6 you simply need change these two lines of Code fromToPlease Login or Register to view this content.However, I don't believe that resolves your issue.Please Login or Register to view this content.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
Jaslake, interesting dilemma. When I make that change it does start on Row 6 but then it skips rows. I have 4 blank spaces between each entry now. Thoughts?
Last edited by Caedmonball19; 08-23-2013 at 10:43 AM.
Hi Caedmonball19
Are you using the Code you posted in your Post #1? If so, how is it you're getting more than one entry in each of the individual worksheets? All entries are cleared each time the Code runs...I'm missing something.Please Login or Register to view this content.
Hey Jaslake I have attached a copy of the workbook with the change. Look at Sheet 5001. It starts on Row 6 now and then skips down 4 lines to enter the next entry.
Hi Caedmonball19
I got ya...let me look...
Hi Caedmonball19
Try thisPlease Login or Register to view this content.
You are a wiseman Jaslake. I will test this is the main document and let you know how it worked.
Jaslake,
Okay so that part works but now it still only allows me to format the very top row. As soon as the sheet is updated it wipes out everything in Rows 2-5. I want to keep the same 5 Rows as the Main Sheet. Any ideas?
EDIT:
I changes this code
toPlease Login or Register to view this content.
It looks okay is this right?Please Login or Register to view this content.
Last edited by Caedmonball19; 08-23-2013 at 02:42 PM.
Deleted...Caedmonball19 sorted it out...good for you
Last edited by jaslake; 08-23-2013 at 06:22 PM.
If it worked...it's probably correct
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks