beginner

Just started using VBA, so I know next to nothing. Most likely a very basic question here. What I am trying to do on my spreadsheet is highlight every cell that contains bolded font, from G2 to AU12. This is going to be a running spreadsheet, so my first question is: is that possible to...

Hi all, I am looking for a little macro help. I am trying to import 10-20 pages of we information into a single excel sheet. Baseball stats for fantasy. I love it and it keeps me busy during down time. I am a beginner at code to say the least, but have a little experience. Here is what i am...

Hi.. Im just new here and also in VBA. (just like 48 hours ago when i started) I made a mistake on deleting a bunch of lines earlier but i managed to retype them because i got a a print screen saved. but things doesn't work the same. i got this code where I want to display the name, time and...

I have a file "Blank Master" that returns the file name to cell A2... We re-save the file daily as the date i.e "May 17, 2016" with the updated and relevant data. I would like Cell A1 to return the day of the week once the file is re-saved as a date. With this in A1...

Basically I want to have Master sheet w/ date and employees name and craft code generate into individual timesheets Below is an example, I already have the finished product Timesheet I just need a formula or Macro to generate these from the master list. <tbody> PERFORMANCE MECHANICAL INC...

Hey guys, I'm completely new to this site and quite frankly it is my first time joining a forum. I'm trying to set up an excel sheet where I can record the weights of an object. In the column I want to be able to enter the weight as a number, lets say 40, and have it return as 40 lbs. Is this...

I am unfamiliar with VBA, but the more I research what I need to accomplish, the more it seems that it might be my best bet. I am creating a workbook for a small business that has been paper-and-pencil for decades and none of the users are comfortable or familiar with Excel, tablets...

I am just learning the ropes of VBA and have the following problem I am trying to work through. I am able to handle the first two requests, but am struggling to understand the best way to incorporate loops and working between values in one worksheet in order to populate cells in another...

Hello All, I am new to Access, and I am starting to figure things out, working up to designing a database for my company. I am wondering if I am going in the right direction, or if it is plainly obvious to someone more experienced, that I will have problems down the road. Here is a screenshot...

So I only recently have started using excel so I'm very basic at it. So naturally I'm working in a project that requires extensive knowledge of it. I work as an IT help desk at corporate for a medical group. I have decided to take the 100,000 tickets we have and export them to excel to create a...

Hello guys, I created a searchable drop down list on excel and i want to duplicate it about 10 times, but when i do it, excel considers the 10 copies at one so when i choose an option in one of them, this same option is selected in the ten drop down list. How can this be fixed? should i create...

I am using excel to make sheet with drop list where the price of the corresponding item appears in a specified cell. However there's more than 64 items and i can't add more "IF". Here's the formula: How could i could i extend the list? Thank you in advance!

Hello, I'm currently building a very large database, in which two of the columns contain the same information, but in different forms. One column gives the name of given country in the set (eg Afghanistan) and the other column gives the abbreviation of that name (eg AFG). I am trying to set...

Hi all, I'm trying to track changes from a shared document on a Sharepoint Repository. I am not the author, but could do it from the author's perspective if necessary. When I download it, is there a way to highlight the recently changed cells or indicate that they were the most recently updated...

Question: So basically I am trying to search in a certain column for the word "Work Type" but the problem is that the very first row in the column already has that word. What I want to do is find the 2nd time in the same column (many rows down) that word is repeated. I also need to be able to...

Good morning, I'm looking for some help to try and solve a problem i'm encountering. I need to it display information like this: 'C' Channel However, it overrides and displays like this in the cell: C' Channel But, if you check the formula bar it shows: 'C' Channel Can anyone help on how to...

Hello! This is my first post to this website! I have been lurking on here for sometime now... I have been dabbling with macros for a bit, but this is my first major one I have tried to construct/meld together from what I have seen online. I am beyond stuck and close to giving up. I am trying...

Hi, I have no idea how to do a VBA, but got one online which nearly does the job. Basically i have 2000 columns for 4000 rows, so manual copy and paste will take days. I have a blank column between each which i need a basic formula inserted. EG in cell D4 i need (C5-C4)/C4. The macro i have does...

I'm quite new with VBA in excel, and recently saw someone create a spreadsheet where they made achievements for a game called Morrowind (all credit goes to Morrowind – Now with Achievements! | Visit Scenic Magical Elf Land for creating the original spreadsheet). I thought I could use that...

Hi all. Once again, any help on this will be greatly appreciated. In my spreadsheet, I've created a combobox with two dependent listboxes and a command button ("Show") What I need is for the data in the sheet to be filtered to show only the data which matches the selection in the second...