Search results

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...

Hi SirJB7 I came back with one more thing. I am so happy with this macro, I have decided to apply it to multiple sheets into a workbook(one by one). So I tried to change "DATA1" into "ActiveSheet" hoping that will solve the problem. Could you please help on this one also? Thank you for your time.

Hi, SirJB7 This macro is working perfect. Thank you for your help.

Hi, SirJB7 I tried my best to make this macro running but...it was not enough. Please take a look in the attached file and, if your time allows you, give it a try. Thank you and "Happy New Year!!!"

Hi, SirJB7 This is what I did: I put your code into a module and I run it. There is a message of error:Subscript out of range. The yellow line in code is: Set rngS=Worksheet(KsSourceWS).Range(KsSourceRng) Is there anything that I should change in order to make this code working? Thank you for...

Hi, SirJB7 thank you so much for your help. I will give it a try and I will let you know how is working. I really appreciate your time you put in to solve this puzzle. Thank you

Hi SirJB7, You are correct in your assumptions: a. discard all cases without data in BB (data like in rows 2:6 included). No BB data means I don't need information from cells left and right b. there are only 4 combination c. only 2nd one has 3 values For the other 3 cases values in BA are...

hello, As I said, those colors are only for visual purpose. I don't need them, I put it there for those who would like to help in order to differentiate between data. There are 4 sets of data: 1. 1 cell numbers and another cell combination(Pink) 2. 3 cells all numbers(green) 3.2 cells w/...

Thank you for your tip.

Hello all, I need help with a VBA code able to select and put data in columns as shown in the attached example. Thank you for your help

Hi, Sirjb This macro will bring some data from a dwg and it will insert it starting with col A. I want that the extracting process to start with col BA. Also it will very useful if I can make excel to bring only "plate" or others. Thank you for your help.