variable field location

Hello Forum - i have a production scheduling spreadsheet that has color fill on each line to indicate a range of times that have been calculated (it shows as a color bar on a calendar of weekdays - say 2pm on Wed thru 6pm on Thu). It's all working fine, but now I want to be able to place a text...

Hi, I have an Excel spreadsheet that has 3 columns and thousands of rows. The value in the third column indicates which row to copy. I am looking to copy the value from column A to column D if C has a value. Then based off the number in C copy the value from A to E EXAMPLE: -- removed...

I am getting an object required error for some of my declared variables not sure how to correct it. I probably have more errors than this too if anyone can help me out it would be appreciated I don't have much experience in VBA. Dim i As Integer, j As Integer, k As Integer Dim x As Range, y As...

Here's what I have (Ignore the x's, etc., they're just to show blank space): <C>xxxxxxx_123_XXXXX xxxxxxx_____XXXXX xxxxxxx_456_XXXXX xxxxxxx_789_XXXXX --------------------- 101112 Total 131415 </C> Is there a way to find and replace that word "Total" with something like autosum going...

I need to create a macro that will delete all sheets in a workbook that do NOT contain the substrings "Dec" and "09". All other sheets in the workbook may contain some variation of the months of the year (e.g. October 09, Sept 09, Jan. 09, etc) Some workbooks will contain 2 or 3 sheets with...

First Question: All, I need to enter a macro area and be able to force the autofilter off. Using Selection.AutoFilter only toggles me back and forth - I need to be sure it is off Second Question: I need to be able to select a field that will vary in location within the spreadsheet...