I have a worksheet with 4 macro embedded shapes on it. I'm am trying to get code to work that will delete two of the 4, but I'm not having any luck.
Dim Shp as Shape
With wb2.Worksheets(1)
.Unprotect
For Each Shp In ActiveSheet.Shapes
If Shp.Name = "Group12"...
Hi all,
I am having some trouble summing up some data from the dynamic range B2:C15. All the fruit names that populate $B$2:$B$15 belong to to either of the 4 groups. These 4 groups are also dynamic lists.
They are:
Group1: Range $E$3:$E$15,
Group2: Range $F$3:$F$15,
Group3: Range...
What's the easiest way of me checking multiple columns between 2 worksheets?
I have two documents, both having the same columns such as:
<tbody>
A
B
C
D
1
ACTION TYPE
TIER 1
TIER2
TIER3
2
Reporting
GROUP1
GROUP4
3
Manager
GROUP2
GROUP4
4
Access management
GROUP1
GROUP3
5
so on...
Hello friends
I want to do three or more groups but I can not do it
Combines everyone
Please help me,
<tbody>
group1
group1
group2
group2
group3
group3
group3
12
12
12
12
12
12
12
12
12
12
12
12
12
12
12
12
12
12
12
12
12
</tbody>
<tbody>
</tbody>
Hello everybody,
I have a quite large data sets (70.000) and would like your help.
Data sets looks as follows:
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
COL1
(orderid)
COL2 (prod.id)
group1
230
group1
501
group2
1231
group2...
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.