new to vba

Within a Workbook, I have a window (Sheet2) that needs to be active for entering raw data and a window (Sheet1) that will be up on a monitor, showing live, manipulated data. In order to keep the current line item on the screen I have it run Application.Goto Target.EntireRow on Sheet1, which...

Hello I am pretty much a VBA rookie, but learning a lot in the last month so please talk to me like I am six and explain as much as possible :) I had a thought about putting in a couple macros depending on if a cell is blank or has an "X" I want to have a macro ran depending on which option is...

I'm not sure what's wrong with my code. The loop in question "loops", but the TagRowCounter variable stops increasing at 318. This is right where part of the logic starts "working", or NOT working in this case. What I'm trying to do is list Tag Numbers with their respective Rooms. Every Tag...

I'm relatively new to VBA, and have run into a "not knowing what code I need" section. I might have used the wrong terminology in my explanation, I apologize in advance. I'm loading Room and Floor data from Component to JCX (with a cross-sheet check on the Floor data from Space). The problem...

Okay here we go. What I have is a excel workbook with a lot of data from columns A to AZ filled with data. What i am trying to do is create a vba code that will take data from two of these columns, and display them on another worksheet. For example this is what the excel sheet looks like with...