Search results

Hello, You are right, it is like a shoot in the dark without autocad. I was hoping that being excel vba it will be easy to manipulate some lines of code. For example I tried to change this lines : ActiveWorkbook.ActiveSheet.Range("A1").Sort _ key1:=ActiveWorkbook.ActiveSheet.Columns("A") to...

Hello, I have this excel macro extracting data from a drawing (please see code below). I played with this macro and I changed a couple of things but now I need your help to add/change some lines of this code to do this: -insert data starting with col BA instead of A -make excel to extract...

Thank you for reply.

To be more specific, I don't want excel to look inside the drawing. Only to scan the file name. Thanks

Hello all, It is possible for Excel to create automatic worksheets from files that are in the same folder with an workbook? In folder “Drawings” I have drawings with extension (.dwg) and an excel Workbook named “GeneralData”. I would like this workbook to create a worksheet with the name of...

SirJB, You area correct when you said that those drawings are not in the cell and there is no reference between them and cells bellow. I just uploaded a file that reflects what I want to achieve. Thank you.

Hello all, It is possible to connect an excel group of drawings to a value? In col B I have unique values and in col F I have a group of drawings(triangles, circles). For example when I move the val from B1 to B2 I would like to have the drawing corresponding to B1 going from F1 to F2. Thank...

Hi SirJB, I tested the macro and is running nice and smooth. Thank you so much

Hello Sirjb Thank you for helping with this problem. I will test it Monday morning and I will let you know how it is working(I have excel 2010 only at work). Once again, thank you so much.

Perhaps I need to bring more explanations: 1. Data in "REPORT" represents an initial estimation and it will be changed with data from sheets(pieces) only for the pieces that I have a spreadsheet; 2. All other data will stay unchanged until a new sheet(piece) will be inserted. In thread's name I...

Hello all, I need help with a VBA that will bring data into a table as shown in the attached excel file. I hope there are enough explanations inside the excel file. Thank you

Now it's working. Thank you so much

When I do this way Worksheets("verify").Range("D2").Select in macro is yellow

Still the same error. Should I rename the macro as Sumprod and still use Call Sumproduct?

Hi, Private sub CmdCheck_click() is yellow and Sumproduct was shown in blue. My cmdButton is named CmdCheck.

Hi Narayan, I created a module “Sumproduct” using your code and is working fine. Then I tried to execute this module into a CmdButton code and I get this message: “Expect variable or procedure not module”. This is the code I use for cmdButton: Private Sub CmdCheck_click() 'insert data to...

So, if I put this into a code for a cmdbutton will work? I tried with a macro recorded and when I tried to execute it I had a error. I will test it tomorow and I will let you know how it is working. Thank you

Hi Narayank, Formula posting by me is working fine. I want a VBA because sometimes formula is loosing the reference cells in data sheet( Because of a VBA code that deletes automatic a number of cells every day), that is why I think VBA will solve the problem. Thanks

Hello all, I need help in transforming this formula in VBA: =Sumproduct((data!A2:data!A14000=verify!A2)*(data!B2:data!B14000>=verify!B2)*(data!C2:data!C14000<=verify!C2),(data!D2:data!D14000)) This formula goes in sheet verify cell D2 Thank you for your help.

Hello all, These are the steps to have a Pivot Table using data from the entire workbook without having this Pivot table taking data direct from each sheet: 1. Open your workbook 2. Go to http://msdn.microsoft.com/en-us/library/cc793964%28v=office.12%29.aspx and copy the code 3. Alt+F11, create...

The method provided in that site is dificult and there are no guarantee that al the updates of the table will work or if it will handle large amount of spreadsheets. Because of this I have decided for a different approach: 1. Copy all data into a different spreadsheet inside the workbook 2...

Hello all, I would like to create a Pivot table using data from the entire workbook. My data is in every sheet at B26:F41 and I want my Pivot table on sheet”Report”(same workbook) in col O, P &Q. The number of sheets and their name is unknown. Any ideas will be very helpful. Thank you

Thanks Abhi, Is working really nice.

Hello all, I have a workbook with a lot of spreadsheets and I created a small form to open the spreadsheet that I type in textbox. This form has only 1 text box and 1 cmdbutton. This is the code I used for the cmd button: Private Sub cmdOpen_Click() ActiveWorkbook.Sheets("Sheet").Activate...

Hello, I copied the formula from C1 in A1 and I saw that is working. Then I put back the formula in C1 and is still working. I don't know why it didn't work from the first time but most important thing is that this code is working(and I checked with multiple pages not only 2 :)) Thank you so...