Re: USD $25.00 PAYPAL. VBA script to collect data from multiple worksheets
Great work! I wired you the money. I might have some more work for you very soon! Thanks a lot!
Posts by goldengloves
-
-
Re: USD $25.00 PAYPAL. VBA script to collect data from multiple worksheets
\Im having a problem integrating it into my actual workbook tho could you please take a look at it? Its giving me the error Run time error '91'. Object variable or With block variable not set. heres he full file https://www.yousendit.com/download/ZGJjeUNITWM4NVZjR0E9PQ
-
Re: USD $25.00 PAYPAL. VBA script to collect data from multiple worksheets
I apologize I didn't get back to you sooner, i hadn't checked the forums directly since i thought they would notify me by e-mail. great work my friend, would you please provide me your paypal account so i can transfer you some money?
-
[INDENT]Okay so here is the situation. I have a Workbook with 33 work sheets containing a column which is called "Cert" which contains a number referring to the certification number of an elevator, on the same row as the cert number is a date of when the Elevator itself was used last out on a job. The maximum days an elevator can be used is 500 days, after 500 days we need to summarize all the dates that it was used in one page. The result page has a possibility of holding 250 entries so the results will be spread out on 2 pages. I want that when i input the "Elevator Number" then it pulls all the dates from all worksheets into the result cell range. Here is the workbook.
Here is the workbook.
http://www.ozgrid.com/forum/at…mentid=34231&d=1288036885
[/INDENT] -
Re: VBA script to collect data from multiple worksheets
Bump. I will pay 25$ by paypal to whoever can help me with that.
-
Okay so here is the situation. I have a Workbook with 33 work sheets containing a column which is called "Cert" which contains a number referring to the certification number of an elevator, on the same row as the cert number is a date of when the Elevator itself was used last out on a job. The maximum days an elevator can be used is 500 days, after 500 days we need to summarize all the dates that it was used in one page. The result page has a possibility of holding 250 entries so the results will be spread out on 2 pages. I want that when i input the "Elevator Number" then it pulls all the dates from all worksheets into the result cell range. Here is the workbook.