macro - help

I have been assigned the task of creating a tool for use by employees in scheduling a conference room. Does anyone have experience with this who could possibly point me in the right direction? My hope was this could be done using VBA. Thanks,

Good day all, this is my first post here. I have a table of information that I edit each day, needing to have the newest information on the top of the list. I need to do a count of non-blank cells in column A, and as I append the list, I add a blank row at the top of the list. Well, I actually...

First let me say, I know very little about macros. I have a few personal macros that I use which I found online over the years, but other than doing minor changes to them I have just copied them from other sources and assigned a shortcut to them to run. I don't know how to actually create one...

Hi there, I send out weekly reports that include data from the most recent two weeks and data from the most recent month. Each time I refresh my report with new data, I have to go in and manually uncheck the boxes of previous weeks and select the most recent checkbox. I wondered if there could...

Hi, hope you can help. I currently have a spreadsheet set up with a macro in; we copy data into tab A, run the macro and it pulls through the info into tab B. We use this to format the information downloaded straight from our bank, however the bank's statements are now downloading in a...

Hey guys! I'm a newbie on VBA and I need some help with a VBA code. Baiscally I have a workbook with several sheets. In one sheet (Summary), I have a dropdown list with all the months in the year (dropdown list is in cell "F9". What I would like to do is that: if Januray is select in the...

Good day, i'm creating a macro that splits a master file into over 30 files, each of those files needs to have a macro that shows/hide columns for some of the sheets on them. i'm not able to figure out a way to add this code to each new file If ActiveSheet.Columns("B:D").Hidden = True Then...

Hi all, Basically I want to automate the importation of a Text/CSV file into my Excel. The problem that I am having is that the pathway and file name of my source changes on monthly basis. For example: For the month of January, a January folder is created where all the data in dumped in. So...

I have the following save macro that unlocks a cell, saves the file with a new name and then locks the cell again to protect a formula. The issue I'm having is when it locks the sheet again, it does not allow my pictures in the report to be modified. Is there something I can add to the code...

Hey there. I'm new to macros and programming. I am trying to make this data <colgroup><col style="width:48pt" width="64" span="15"> </colgroup><tbody> device1 app1 app2 app3 app4 app5 app6 app7 app8 device2 app1 app2 app3...

I have 2 sheets, in sheet1 I have 2 columns Product code and Values, In sheet2 also I have 2 columns Product code and Values, In sheet1 A column a same product may be there for more than one time with different values but in sheet2 the product code is there only for once without having any...

Hi there Could you please help me here I need to merge particular sheet "Consolidated data" from the different work book saved in the same folder to another work book without formulas. Save as values.

Goal: Prevent exited employees from using certain company spreadsheets. I've searched for this question, but most of the questions refer to allowing only a specific list of users access. I have another workbook that only a few people need access to, so I put their ID numbers on a hidden sheet...

Hello, I have a button running three macros. I was to have this run through multiple sheets in a workbook, but not all the sheets. Just selected sheets. I have this code on the button. It seems to run through and select the sheets as the message box pops up. But it is not actually running the...

Good day, I'd like to ask for your kind assistance please, I couldnt use the macros on this sheet when i lock the worksheet is there a work around on it?, even if I sent the macros unlocked. can anyone help me please thank you so much. below are the Macros i use in a sheet. Sub Resolved() '...

Hello Can anyone please point me in the right direction with some VBA? I want to copy and paste a worksheet ("Phase2_Timeline") onto a new worksheet (that hasn't yet been created), but for it to be called "TU Report " & Format(Date, "dd-mmm-yy"). I have been trying; Sub Create_TUReport()...

Hello Sorry this could be really simple but I've spent hours and feel like I'm going round in circles! Any help would be really appreciated. I want a macro to insert a new row below the current active cell, then copy and paste format and formula from row 8 into that new row. I have been...

Hi all, I'm not very good at Marcos or VBA (I'm sure many say that!) I trying to pull specific data from a website. I would like to do the following: I need to extract data from a website (name of aplace and address) and import it into an excel sheet. The data on the website is not under...

Hello, I am hoping someone can help me with my dilemma, I don't even know where to begin coding this one. I have a Workbook with 6 Sheets: TRACKER, FY19 SUMMARY, FY20 SUMMARY, FY21 SUMMARY, FY22 SUMMARY, FY23SUMMARY, and FY24 SUMMARY. I need to move a portion of a row of data from the...

Sorry for the long post, any help is appreciated. I am working on the Macro below. I am hoping someone can provide a little guidance on a few questions. 1. Should the Marco be in Module1, The spreadsheet I am running it against or in ThisWorkbook? 2. I can run the solver without an issue...