vbaexcel

Hi guys, i need some help. maybe you guys could help me with some idea or in script with vba. I have two tables. one for borrowing table, the other one for returning table. How to avoid double value when i try to fill "amount returned", when in the ID's column has some, same ID. Here's the...

Hello, I keep receiving RunTime Error 1004 at the saveAs line of my code. The code is below. I have tried multiple different solutions people have posted, but it doesn't help. Private Sub CommandButton1_Click() Dim Path As String Dim Name As String Dim Loc As String Set wb = Workbooks.Add...

0 I have the following code to delete multiple sheets. This code takes forever to delete the sheets, not sure how can I speed up the process. If someone can help me out, would be great. Sub DeleteSelectedSheets() Dim h As Long, RESA1() As Variant RESA1 = Array("Upload EC", "V-UploadEC", "EC...

<tbody> Hi I am trying to update my updatesheet data to mastersheet via headers with vba. Anyone can help me Master Sheet A B C D 1 First Name Last Name Age Salary ($) 2 John Smith 50 5000 3 John Smith 45 2000 4 J. John 40 2800 Update Sheet...

I spent last night looking for an answer to my question but i didn't find anything specific to my ask. I have a huge sheet that contains lots of data. In Column A, I have the Date and time. I would like to have a VBA code that does few actions. 1) Insert a column B next to column A that gives...

I have 3 work sheets within a workbook: 'RawSupplier' 'RawBalance' 'DataForMap' I need to compile data from 'RawSupplier' and 'RawBalances' onto 'DataForMap'. The Raw sheets contain customer info. I need all the data from 'RawSupplier' and only one column from 'RawBalances' showing...

Hi all. I've written a macro that iterates between several workbooks. Each workbook has a sheet with a data validation list with different "Views" as options. When selecting each view, the workbook automatically hides and unhides columns. All i need to do is, go through every view and get the...