vba & excel 2013

Hi, I am attempting to pull a cell value based on the value of a specific array of cells. The data set would have thse identifiers on both the vertical and horizontal axis of the data set. It would essentially be a index, match, match from a separate workbook but through vba. I tried writing...

Hello Everyone, I am looking for a macro for Copy &Paste Formulas for a multiple files stored in a folder. For Example: I have afolder named “monthly calculations” which is kept in C drive desktop. There are12 excel file inside that folder which every excel file consists many excelformulas. But...

I have specific rows and columns I need to sort on multiple worksheets. Columns A:O and rows 1-126. Can you help me with vba code to run?

Hello my name is sebastiaan and i am doing an internship in an company fort hat company i am trying to make an excel file that works with userforms to keep track of the maintance of the UV machines that are installed in section 1-8 and in 9-12 and in 13-16. Each section has 4 userforms: Main...

I have VBA code to hide rows based on cell value and it works perfectly fine, but I am wondering if inserting a union into the code would make it run more efficiency as there can be many rows that need to be hidden at one time. Thoughts? Sub HideRws() Dim Rng As Range, Cl As Range With...

I have a user form,SortForm that has 30 radio Buttons on it. The purpose of the form is to allow the user to pick one of the buttons to use as a key to sort the spreadsheet. It is sorting on courses and these change for each registration period. What I am attempting to do is change the...

Hello everyone, I need to make this code run as one. Thank you for your help. Sub InsertSaturday() Dim i As Integer i = 6 Do While i < 100 Cells(i, 3).Value = "Saturday" i = i + 6 Loop End Sub Sub InsertSunday() Dim j As Integer j = 7 Do While j < 100 Cells(j, 3).Value = "Sunday"...

I have written the SUB below - when I clicked [X] it is working all right - but the dialog box is appearing twice before saving. When I used the SAVE Icon - it does the same thing BUT there's a prompt that say "Excel has stop working" - when I ignore the prompt - it saves the file. I am trying...

good afternoon, i am looking for a way to bring several text cells(excel) or records(access) merged together into a single cell/record. i have 4 columns and the first 3 are grouping/hyarchy with the last column being the text that i need. have a look at this example...

If I already have a workbook open, and know the name of the workbook, why can't I simply assign the workbook to a variable? Example: If I have workbook A and workbook B, and both are open. The code is in workbook A. Why can't I do something simple like: Sub Assign_WB Dim wb as Workbook Set...

I cannot seem to get this to work. I want to pass a 2D-array from a subroutine to other subroutines in which a data manipulation should take place. I am calling below subroutine from a command button on Sheet1. In Module1 I have declared the variables as public. Inside the subroutine...

I have 50 named ranges. Some of them are just a range, others have dynamic ranges (formulas). None appear to be incorrect. Everything is calculating correctly based off of the named ranges. I have used the Name Manager to filter for Names with Errors and there are none listed. I need to...

Hello everyone, Just quickly, I am trying to create a macro where it will copy specific range in various workbooks and paste in a new workbook. My problem is that when I run a macro not all workbooks available at the time of running a macro. So Microsoft gives an error message "file either...

Hi All Firstly, many apologies, I know this has been asked and answered previously. Unfortunately I am not experienced (or intelligent) enough to make those solutions work for me! I am therefore asking about my specific situation. I save a daily .csv file in Sharesync with the previous...

Hi All, Below is my problem: I have a excel file which have 8 different sheets and eachsheets contains a table of data which range is “D6: Q2926”. In every sheet ofthose 8 sheets, same range data is available and that sheet is uploaded togoogle docs for editing. Now for security purpose, I am...

I have 3 data files "Data1", "Data2", and "Data3". All 3 files are stored on desktop. I need help in pasting this data on Sheet1 of "Final Data" file one below another. Data in all 3 data files are not fixed and last row may very every time. This needs to be done very frequently and hence a...

I have a UDF I based off of a prior I was using. The prior one works just fine. But for some reason, this new one just returns a #VALUE error. I have 3 columns with Headers of: TD ST FLR In the FLR I input my UDF and it is based off of the TD & ST. Could someone give it a look over and...

Requesting help for > VBA to check range (C2:G1001), The Criteria: if C2 and D2 are filled (not empty) then G2 must be > 0 to have a complete entry, if criteria was met then it is "legit"; the cursor should stay at G2 until it is filled with a number. To exit such checking, it is "legit" to...

Hi!!! I need to break my original excel file into 6 different workbooks due to it's size. Now, I want to put the total values of last row for each sheet of that 6 workbooks to 6 different cell in a new excel workbook without opening it. Actually I want to create a macro so that it show me the...

Hi guys, Hope you can help me out, I'm a newbie here but I'm always looking for ways to reduce amount of time in getting data. What I'm try to do right now is to pull worksheet data with same worksheet name from different workbooks and consolidate into a different workbook one a worksheet.