macros and vba

I have multiple tabs of data (named AB, BC, CD, EF, FG, GH, HI, IJ, JK, KL, LM, MN, NO, OP, PQ, QR, RS, ST, TU, UV, VW, WX, XY, YZ, Z00, Z01, Z02, Z03) in my "critical numbers spread-sheet" with wanted numbers per application identified in each tab but columns and rows are inconsistent. I have...

I'm trying to select a textbox from my form in excel with the command #set focus "but apparently it gives me an error, can someone help me? Error: Private Sub cmd_Recheck1_Click() A0r = in_A0r.Value A90r = in_A90r.Value A_90r = in_A_90r.Value A1 = 0 A2 = A90r - A0r...

Since I added the time format the code stopped working, is there any way to include the time in the file name? Code: Sub SaveAsPDF() Dim FilePath As String Select Case MachineName Case "A4", "A8.1", "A8.2", "A8.3", "A12.1", "A12.2", "A12.3", "A20.1", "A20.2" FilePath...

I tried to create a procedure whose objective is to convert the excel spreadsheet to pdf and save it in the folder "D:\Users\(UserName)\Documents\Project\(MachineName)", this program will be used by several users on different computers , how can I make the PDF be saved in the documents...

Transformed(PRow * (c - 1) + 1, 29) = "=MAX(Y" & Sum + 2 & ", IF(H" & Sum & "= 99,I" & Sum & ",SUM(OFFSET(H" & Sum - 1 & ",1,12,1,-H" & Sum & "),Y" & Sum + 3 & ")/H" & Sum & ")) " Formula is getting pushed and code is running properly But i want to evaluate the formula and push in value. I...

I have created an event like when something changes in a cell, then an advanced filter should happen. The values to be filtered will be in C2:E3 with C2,D2,E2 as headers. the values will be filtered in B6:D67 with B6,C6,D6 as headers. Now the issue is: the values which I filter with...

HI guys, I hope somebody can help me here. I'm using Windows 10, Microsoft office 365. 1) I have many webpage URL with me in Column A. Using VBA, I want to extract an image from one webpage URL and put it in the next respective column. (Please note, it is a webpage URL, EX: Chicco 6 Feeding...

I'm very new to Macros and all things excel and have been trying to find the correct code or help for days. I have a few urls that are all dynamically built with the hyperlink formula based on populated data on other sheets. One of my sheets contains all the of website formulas for the...

Hi I have a unique problem. I have multiple csv files and I need that the date value (ddmmyyyy format) mentioned in B3 column to be printed from D5 onwards in D column across all cell where a value is mentioned in C column. I shall merge all these csv files into one xlsx file through VB code and...

I am new to VBA and I am struggling to define filters by which my data should be copied to an overview sheet. I would like for all rows to appear that contain the current month plus all dates in the next three months. My current date format is MMMM YYYY (Oct 20 etc.). This is my current code, it...

Dear experts, I'm new , Could you please help me to fix this is it possible to open the hyperlink automatically based on previous cell value (Any Value) on each cell. Appreciate your support in advance

Hi, I have created a custom budget sheet that we will be using in our organisation and have hit a road block with what I would like it to do next, and hope that someone may be able to offer some help. I have scoured the internet and tried to work this out but my knowledge is limited! Thank you...

Hi, I have coded for a solver problem in macros. But the problem is the range in B column is auto filtered and the other rows are hidden. So as per inputs, only the rows in B column that satisfy the input are shown. It can start at any row. How do I include the code to use only visible cells in...

I have 28 tabs of data (named AB, BC, CD, EF, FG, GH, HI, IJ, JK, KL, LM, MN, NO, OP, PQ, QR, RS, ST, TU, UV, VW, WX, XY, YZ, Z00, Z01, Z02, Z03) in my spread-sheet with varying data (columns and rows are inconsistent) in each tab. I need a summary tab with count of each column per tab(only...

I currently have an Access DB and Excel workbook that are linked and updating tables and graphs properly when I refresh from Excel. What I would like to happen is user selection from a drop down on the Excel worksheet launches the update of the Excel document via linked Access queries. The...

I have data in a list with client, X amount under the title of the month - I need to merge this data with other data which is listed x client, x amount & month. (In same row) I can get the VBA to copy & paste the data required but how do i get it to look at the title for various rows when...

I have a spreadsheet with a main tab that has a variety of fields for the user to fill out. One of them is "Supervisor" (B5) and at the end I have a "Submit" button. Once I click the Submit button, I would like to be taken to the tab that corresponds with the name in B5. For instance, if B5 =...

Afternoon all First and foremost, thank you for your help in advance. Greatly appreciate it. I am building a workbook whereby I have a code in 4 worksheets that hides columns based on a value found in row 5. The code in each of these worksheets is within their own sub and is as follows: Sub...

Hi, I've been trying to get this done to analyze the data. However, I am unable to un-pivot this table. Could someone please guide me here? Input table- <tbody> A A A A A B B B B B WEEK MON TUE WED THURS FRI MON TUE WED THURS FRI 1 100 100 100 100 100 100 100 100 100 100 2 150 150 150...

Hi, I have twoexcel documents, "Book1" and "Book2". Book1 is exportedfrom our business system. Book2 is a compilation of forecast from the businesssystem data that were exported. Today Ihave to manually put in the data from Book1 to Book2. I want to put a VBA Codein Book2 to import data from...