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...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.