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

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

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

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.

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

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

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

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

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

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

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 all, I would like to sum all A1 cells from a workbook in C1 in "Main"spreadsheet of the same workbook. Also data from "Main" should not be counted. The number of sheets it is unknown Thank you for your help.

Hello , It is possible to insert a new spreadsheet with properties (tables, formulas,column width, etc) identical to a reference spreadsheet(Main) inside the same workbook without using copy-paste? Thank you for your help

Hello all, This is for a punch clock in excel. Using cmdIN I am able to insert a personal code ( col A ) and next to him computer’s time (col B) Using cmdOUT I am able to insert the same things in col F(personal code) and G(computer’s time) It is possible to bring time out next to time in (in...

Hello all, Since this post was started a couple of day ago in the old forum I decided to bring it back in this one. This code(thanks to coolkiran) is inserting computer's time in all cells belonging to column C for the same IDnumber as in Col A. I would like to change this code to insert...

It is possible to split a text from a cell in multiple cells? For example I would like to split 4-1405 from A1 as 4 in B1, first 2 digits in C1 and last 2 digits in D1. Thank you.

Hello, I created a form to introduce some data into a worksheet. When I applied a formula in one cell(col D) I saw that the data skipped that row. My guess is, the problem is the 3rd line in the code.I would like the code to look only for the firs 2 cell empty in that row instead of the...

Hello! I have one sheet(say SH1)with data in A1:C2. I want to create a form in VB with 2 Labels(L1 & L2) and 4 Text Boxes(TB1 to TB4). What I would like to accomplish is to have L1 showing data from cell A1 and L2 from A2. Also I want TB1 to show data from B1, TB2 from B2, TB3 from C1, TB4...

Hello, I need some help finding the next upper number from a table. For example table has 2x2 data A1:B2 C1 has a number in the range of my table. I want D1 to show the next number above C1 from my table. Also it is possible to identify the location of the number showed in D1? Any idea...

Hi, I have a col. that takes data from 6 different tables. When I update a cell in a table the column will automatic update. Is there a way to stop this automatic update until I give permission? Each update takes 30-45 sec (for updating one cell in a table) and to update a row in a table it...

Hi, Col. A has values that repeat 2 or more times. Col.B needs only one of each of the values from column A. I tried with Data/Remove duplicates but is not what I want. Any ideas? Thank you

Hello, I have 3 Tables: "Main" A B C D 1 2 Start Date:"B2" 3 End Date: "B3" Table A A B 1 111 "Date" 2 111 "Date" 3 222 "Date" Table B A B 1 111 "Date" 2 111 "Date" 3 333 "Date" 4 444 "Date" I want row...

Hello, In cell A1 I have a formula that gives me a value. When I eliminate 1 variable the result is #N/A. I need cell B1 to copy the final result from A1 or if there(A1) is #N/A, I want this cell(B1) to be empty. I tried this: =IF(A1="#N/A","",A1)but is still returning #N/A. Any ideas?