macros

Hi, I need VBA code to get the list of top 10 recently modified files on the excel ribbon as macros in excel ribbon. The list of these files must be obtained from the Sharepoint link.

Hello, I am new to VBA Are you able to have VBA that extracts data from softwares such as SAP/Oracle etc..? Thank you

I know this has been asked many times here and in so many different ways before. Still unable to figure out a way to achieve this as per my needs. So, I'm looking for a VBA code to insert multiple photos and arrange them in specific manner(not inside the cells) and resize with custom width...

I would like to copy from Cells O4:O9 in Sheet 1. The destination would be a transposed paste result into A1:F1 in Sheet 2. I would like the information to remain their temporarily. Then, if I run the macro again, I would like it to copy the new data in O4:O9, but this time paste into A2:F2 on...

Hi This is the original file for which I seek your kind consideration. This is the desired output file I need your kind gesture and help to get the output file with the following parameters Delete Column A ,C, D ,J,K,M,O,and P to AH completely. After the given columns are deleted I request...

I have two separate macros in my book: one that refreshes 12 tabs containing CSV data that points to a source outside the book (and which itself receives updated numbers each day); and one that updates data tables in other tabs in my book that rely on these 12 CSV-data tabs to be refreshed. The...

Hi Enclosed is the Scheduler file. I request you to kindly help me with the following by way of a macros. 1)I have added a scheduler till 25-Jun-24--30-Jun-24. 2)However I request a macros where the same worksheet mentioned above is created but with the first working day(Monday) to the last...

I'm trying to loop through 10 scenarios via a validation list. On each scenario the calculation engine provides an output in a fixed range. The output needs to be copied / pasted onto a dashboard sheet going down the row with fixed distance (so the dashboard sheet will have 10 sets of output)...

Hello, Here is the issue I am having, I built a workbook containing several tables, each table on their own sheet. The purpose of the workbook is too assist with tracking of patient lines. How the table functions is that when a new line is placed on a patient, a staff member will add that...

Hello, I'm new to VBA and trying to make a custom Dashboard for a manager. Below lies my attempt at creating a data refresh and save macro that will be tied to a button on the "Dashboard" sheet. My main question is: Am I actually calling the RefreshData() sub twice in WriteData(), thereby...

Hello Everyone, this is my first post in this community, I have this very weird problem regarding on the Macros files with excel, basically, there is a file using Macros working on my laptop, but I can't make it work on other laptops, those other laptops have the same office version, and even...

Good Afternoon Could a formula be created to count occurrences of values in ranges and list the occurrences at the conclusion of values in column a. example - looking for a total count of Crits would find 2 values that fall in the Ranges value of 900-1000 [the ones showing 1000] Next looking...

I have a POS that is using 10 Shapes (Categories) as buttons. I have a Macro to call the Subcategories. It works for 9 of the buttons, but not 10. Sub POS_LoadSubCategory() With pos 'Remove any existing product shapes For Each ProdShp In pos.Shapes If InStr(ProdShp.Name...

Our company uses Office 365. We are using macros in around 15 unrelated areas of my workplace and suddenly, after years of working perfectly, they seem to be crashing randomly. This started a few weeks ago, and more and more files are having the issue. For example, there is a file used daily...

Hello All , I have taken interest in excel VBA recently and am trying to learn and apply some optimizations to my daily excel workflow sheets. I have an excel table which has date that is replugged into multiple sheets in my workbook. Instead of pluging them in each table. I would like to find...

Hello all, new to macros here, but this one has me extra stumped. I want to copy two cells (B21 and B23) in Sheet1 and paste the numbers into Sheet2. The catch is the figures being copied need to be pasted into the last empty column in Rows 2 and 3. The copying and pasting isn't so much an...

I've been trying to update some old spreadsheets that add 30 days to a date to instead use workday to add 30 working days. I've managed to convert my old dates into the correct dates using workday however, when I do it in that order it completly messes up my pivot tables later. Is there a way of...

Hi I have this document with all the students marks for a given term. The same can be accessed here https://docs.google.com/spreadsheets/d/18z-l-RLOcf069-3txj_4YwQ6OXALHL_4/edit?usp=sharing&ouid=105636336571610671345&rtpof=true&sd=true What I am trying to figure out that if there is a way in...

Hi I have this document with all the students marks for a given term. The same can be accessed here https://docs.google.com/spreadsheets/d/18z-l-RLOcf069-3txj_4YwQ6OXALHL_4/edit?usp=sharing&ouid=105636336571610671345&rtpof=true&sd=true What I am trying to figure out that if there is a way in...

Hi, I have a workbook. First sheet has dates September 1st 2023 to September 30th 2023 (a2 to a31). I have 6 comments in each cell of each row. (columns B,C,D,E,F and G). The next 30 sheets are for the thirty days of September, titled September 1st 2023, September 2nd 2023 etc. Using VBA I want...