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...
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
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):
101112 Total 131415
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...
All, I need to enter a macro area and be able to force the autofilter off.
only toggles me back and forth - I need to be sure it is off
I need to be able to select a field that will vary in location within the spreadsheet...