sheetsraw

So, after much searching the wonderful web, I still can find a solution. I am trying to create an Excel VBS Script that does multiple functions. I have some of it working (yay me), but now I need some help. First part of it needs to find data in a specific column, that is greater than a...

I'm trying to create a search for it will search the sheet and display information in separate area. This is what i have but it's not pulling any info. ub Searchdata() Dim Lastrow As Long Dim count As Integer Lastrow = Sheets("Raw Data").Cells(Rows.count, 2).End(xlUp).Row For X = 2 To Lastrow...

Hello, I am trying to write a macro, which will loop through all headers in a specific sheet and in case last 12 characters are "_TEAM_OFFICE", it will copy/paste the filtered results into another sheet. Same procedure will go for all other columns in range. Unfortunately, my code doesn't seem...

Hi, I am new to Macros. Have written this simple macro but it keeps falling out at the line in RED? any suggestions? Sub GlassMacro1() ' ' GlassMacro1 Macro ' Add Sheets & put them in order ' ' Sheets("Sheet1").Name = "Raw Data DB Viewer" Sheets("Sheet2").Name = "Working Data DB...