Hello,
I need some help with some code to copy a row of data from multiple tabs to a summary tab. What I have is a worksheet with several tabs, all formatted the same, in column G, there is a calculation of the number of days a case has been open, when that data gets to be >90, I need that row, column A to I to copy to the next empty row on the "Summary" tab. I have looked on here and found some similar scenarios, but none seem to work for what I want. Any help will be appreciated. Thanks
I just posted this for someone else with a very similar issue. There's probably another way to do what you're asking but this will basically merge all sheets to one and then sort Descending by column G. You'd then just have to delete everything else that you don't want which I'm sure there's a way to add to the macro.
Please Login or Register to view this content.
Assuming you have headers in row 1:
Please Login or Register to view this content.
Thanks for the help, but I get a "Run-Time error 1004" code.
Sub Consolidate_90Days()
Dim wsSum As Worksheet: Set wsSum = Sheets("Summary") 'make sure this matches your summary sheet name
Dim ws As Worksheet
The sheet name is "Summary"; How exactly do I need the second line of code to be? Do I need to change any other lines? Sorry for the questions, but I am new to coding and trying to work my way thru it.
Last edited by rmwindham; 08-28-2014 at 06:10 PM.
Is there a trailing space at the end of your sheet name? "Summary "?
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clickingbelow their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
No there isn't
I could not replicate the problem. Can you attach your workbook?
Sure, here it is and thanks
No workbook attached
How about now? It shows in Go Advanced, manage attachments. Am I doing it correctly?
Nope. You probably need to click the insert inline or done button after you select the workbook. You will be able to see it in your post when you do
Now Attached
Wrong file, last one had no sample data, this one has data
Sheet name needs to match.
But that is not going to be your only issue.
Please also note that your columns in the summary sheet do not line up with the others sheets. You will need to add a column A
Please Login or Register to view this content.
Thanks very much. There is a Column A, it is hidden on the data pages. Only need it to show on the Summary page. Your code is very close, but shows some rows that are less than 90 days and doesn't show all of the rows that are over 90 days. I will tinker with it. Thanks again
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks