coding

Hi I have this code happening in Excel, would like to do it in Access but do not know how. Can someone help? =IFERROR(VLOOKUP($AG5,VST!B$11:C$85,2,0),IFERROR(VLOOKUP($M5,VST!B$11:C$85,2,0),IFERROR(VLOOKUP($N5,VST!B$11:C$85,2,0),IFERROR(VLOOKUP($AC5,VST!B$11:C$85,2,0)," No"))))

Hello colleagues, I am new here and also new to vba and I would like some help with coding. I implement a script for my company and I am in the final step. I have the active cell on which I have a formula that has been recordered and I selected the active cell I copied and I need the code so...

*I have VERY limited experience with coding* I am trying to use VBA to insert a pivot table. I am having trouble modifying the recorded macro adding the pivot table. When I try to repeat the macro, I am getting an error "Runtime error 1004" My table has the following columns (starting at A5)...

Hi guys, I need assistance in the following two VBAs coding. This is the excel worksheet that I need help with. 1) This is the current coding that I have for delete(empty cells) Sub delRowsGO() Application.ScreenUpdating = False Dim txtCel As Range Set txtCel =...

I am just a common user of Excel trying to do uncommon things and wishing I could do more. Would appreciate answers written in "layman's" terms as I certainly don't understand anything related to coding such as VBA. :confused: Working on a project that is intended to be used by people who know...

Hi there, Background story: I have coding that loops through .xls* files. It starts out at the named parent folder, which is organized then in subfolders(layer1), and those subfolders have subfolders(layer2), which contain the .xls* files. The subfolders(layer1), subfolders(layer2), and excel...

Hi all, I am writing some code to fix up some survey information. The type of data I receive has a x, y and z co-ordinates for the same points, lets say a shot at the ground line, a shot at the top of a structure and shots part way up the structure. The software that will be importing this...

hi all, I am very new to VBA coding features . My company given me database spread sheet in which there are about more than 150000 lines in that sheet. So i need a user form to retrieve the data from the database spread sheet and edit the features and update the same in the field. I have...

Hello there, I am trying to repurpose coding that is used in another workbook to make it effective for the one I'm trying to create now. Essentially, it combines all the data from dozens of files into a single file where I can extract the data and/or utilize in pivot tables. There's a line in...

I'm a beginner working with VBA. I first used the "record a new macro" function in Excel to create my first set of Macro's. I progressed to the point of looking for snippets of code on the internet to accomplish specific tasks that needed to be done. However, I am very aware that my coding is...

Hello, I am new to excel vba and trying to this coding. Need your help if someone can help me on that.

Hello! Goal: Run an index match down the data in column #54 , based on the info in cell $A$2 and cell $A7. 1) I'm having trouble getting the VBA coding to reference the tab name that I'm working on without manually typing it in the coding. I'll need to run this macro on many different tabs...

I have a data base in Excel which I need to clear of all data. The problem is when I just delete it i also destroy the excel 'coding' I could supply the file if anyone here can help Thanking you in advance Ted Cullen

Hi, I have moved a section of coding from the sheet1 module to just a module. (I want to try and tidy my coding). The code was working fine in the sheet module but now I have moved it, it comes up with this 91 error. I am fairly sure it is to do with the sheet name or the "activesheet" part...

Hi All, I have some coding that allows me to copy data from one sheet to another, but i want the same coding to look at Cell M4 and display a Message box if Cell M4 contains the wording "Select Variant" Is this possible and where would it need to be within the coding (shown below sorry for...

Hi Everyone, I have a UserForm where a user can check some check boxes and fill in some field. I have one inputfield where the users enters a number, when the user enters 0, I want a msgbox displayed, and when the user hits "ok" I wan't the form to be still open, but the code to stop executing...

Hi Everyone, I have created some code, and what it should do is select row 5, starting in column F tot the last filled cell of that row, so for example F5:ZZ5 and change all values to "No". Next it prompts the user to enter a number, for example "20", it now puts 20 random values in the range...

How do I pull a row of data from one sheet and transpose it as column into another sheet? For example, I can pull from one range and transpose it to another range in the same sheet: Range(Cells(1, 1), Cells(5, 1)) =WorksheetFunction.Transpose(Range(Cells(1, 5), Cells(1, 10))) I can even...

VBA coding in power point