Recent content by tazz

Hello all, I need help with a matrix assembly. I have a number of matrices with headers named a1, b1, a2, etc and rows matching the headers. I would like the assembly matrix to get in cell corresponding to a1a1 all the values from the matrices and so on until all the values from all matrices go...

Thank you so much for your code and for your time in dealing with my code. Have a great day.

Hello Nebu, I changed the name of the sheet and it worked for WB_SOURCE. I tried the same thing with another file where I need to extract data from, I changed name of the file and of the sheet where data is located(this time is sheet 3 named "NEW DATA") )and I get the same error on this line...

Hello Nebu, Thank you for your reply and solution provided. I followed your indication to change path and enable ActiveX DO 6.1 but I get a message of error: "Sheet1$ not a valid name" and when I debug the line starting with "rs. open query.... " is yellow. Do you know what the probkem could be...

Hello all, I need your expert analysis to fix the macro inside the workbook WB_RECEIVER. For a couple of days I try to figure out what I did wrong. This macro is supposed to select data from a closed workbook using as filter criteria the value in cell G1. Please find the attached files as...

Hello, I made the suggested changes and is working really nice. Thank you to both of you.

Hello all, I have this sheet with 2 macro: one that will extract data from an acad file and the other one that fills empty cells in col BA.Both of them were working fine until I descovered that the data extractor thinks that data like 5-3303 is May-03 (as shown in sheet"before modifications"). I...

Hi SirJB, This is the link for the original source of the code http://chandoo.org/forum/threads/selecting-and-putting-data-in-columns.14069/#post-84492 Thanks

Hi Narayan, Could you please help me in making this changes to make the lisp working on any sheet. Also do you have an idea why the sheet has such a big size? Thanks Ps: I forgot to specify that the mastermind of this code is Sirjb(thanks)

Hello all, I have a workbook with 2 worksheets and I tried to apply the same macro separate on both of them. Macro is working is working only in one of them(TEST) and on the other one(PIECE) I get a message of error. Also there is another problem: the sheet that is working has a very huge...

Guys, Both of your macros are working perfect. Thank you so much.

Hello SirJB, This code is working really nice. Is there a way to make it stop if there are no empty cells? Thank you. @crouchsw I also tested your code but for some reason is filling only cell 3. Thank you for the head start

Hello, I need help with a macro that will fill all empty cells in a column(say BA)between BA2 and the last filled cell in the column. The filled cells could have value "Filled"(or any other value ) Thank you for your help.

Hi SirJB, This code is working for "active sheet" Thank you

Hi kyajaiinc, If you go to this web page:www.rondebruin.nl/windows_articles.htm you will find exactly what you need. Have you saved the workbook as a macro excel? I made this mistakes a couple of times and this is the first thing I check. Also, a good way to find an answer to your question is...