newbie

I am trying to create a column "H" that will display the values in column F unless F is empty. In such a case, the value from column E will be entered into column H, however I am new to using vba and am not sure how to fix this macro as it continues to fail on the first line "If...

Hello guys, Im new wiht the PowerBI tools and trying to keep on... Also, I dont know how to call what I need to do even in spanish (my native language) so I´ll give an example Before that, I'd like to state that this is a real world problem for me, Im working in a large construction project...

Hi all, I'm using Excel 2010 and am very new to VBA (halfway through Excel VBA for Dummies 2010). I am trying to create a macro that formats all cells in row 1 that contain text and aligns right all cells with values (text or numbers) below those row 1 cells. My thinking is that it would be...

Hi guys fairly new to VBA coding, having only really started to need the functionality recently. I have a worksheet with several columns where alternating columns are dates of when the previous was updated. I wanted a VBA to update the date when a value is changed starting fromt eh 3rd row...

I attempted to write some code to insert a blank row after each change of value in column B. I also change the fill color to grey, add the text "Totals:" to column C and right justify it. I still have one bug. It overwrites the header (column labels) to add the grey bar and totals. Can...

I need to able to input city, county, csp territory and protection class territory. Where I input the city and county, and then the corresponding csp, and protection class is pulled from another sheet. I tried vlookup per a YouTube channel but it's not working correctly. Any other ideas?

I have a workbook with multiple sheets. The end user in my office will only be using one at a time but that sheet needs to be completely filled in. They then save and email the sheet to me. I have read multiple peoples VBA codes to get that to work but everytime I try to save the form it doesn't...

I have a series of swipe card "beeps" in excel 2010 for the month of april. They are sorted by date per each employee. There are multiple "beeps" per day since the employees go from the production floor to the cafeteria, home, or to the restroom I need to device a macro where I can calculate...

Hi, I am extremely new with VBA and have been trying for several hours on on how to change my x-axis label which now reads "1 to 12" to a string/text /timescale "Jan to Dec". my data structure looks similar to the below Dept Jan Feb March w 20 30 20 x 40 34 54 y...

Here's a total newbie problem that I could use some help on: I'm trying to create a list of items that allows me to tag each item with essentially unlimited tags and perhaps a limited number of other fields. Later, I'd like to be able to search that list for specific items by the tags that they...

Hi All, i really hope someone can help me with this as it means i can stop wasting 3 hours a night doing it manually. I have 3 CSV files that are price files and have fields such as Part Number and Quantity. I have 1 CSV file that is my upload file with the same fields but showing data from the...

Hello there, I find myself at this, my first Excel forum, for I find myself with nowhere else to turn. Any help offered will incredibly gratefully received. I'm working on a holiday tracker, and it's pretty evolved as it stands. The issue I have two sets of staff on the same page but treated...

Hi I have an array of boxes corresponding to each day of the month, into which I enter periods of sickness/absence by marking each day off with an "S". I can then count the number of days sick quite happily. I've been asked to count the number of occasions of sickness now, for example a person...

Hi, trying to un a macro when a specific cell is changed with the code below. Even though cell H5 changes (linked to cell in other sheet with formula =RR!E12) my macro doesn't run. Any suggestions on what I might have done wrong? /A Private Sub Worksheet_Change(ByVal Target As Range)...

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...

Hello, I'm new on these forums and I was wondering if anyone could help me with creating a macro. What I need to do is filter a database to show only rows that contain a date between today's date and 6 weeks in the past. If this isn't possible, perhaps a popup box where I can enter two values...

a few times a year I have to make some special signage up from three columns A1: Item B1: Number of Tickets to get Item C1: How many signs are needed so for example A1: Gadget B1: 100 Tickets C1: 3 Which I have to convert into A1: Gadget B1: 100 Tickets C1: Gadget D1: 100 Tickets E1: Gadget...

Hello everyone, I hope all of you have been doing great! I've been (slowly) learning VBA recently and realized that it'd be good practice to include error handling in my code. The set up: I'm linking a "profile" workbook to approx 60 other workbooks. As you can see from the below code, the...

Hello to all visitors of this post, I'm trying to compile some data to help out myself and fellow co-workers. I'm not an expert in excel by any means but here is what I have so far. I have multiple sheets (about 70 in all) that have data of customers that show pricing, quantity, and total...

Hey I would really appreciate if someone could help with this. I'm trying to use vlookup to items from a master list that have the word "dress". THe formula that I am currently using is VLOOKUP("*"&E5&"*",'Overall Summary'!A5:D1427,2,FALSE)...where E5 is the word dress, "overall summary" is the...