Recognize values then populate up to 10 new rows

K

Kreiz

New Member
Joined
May 6, 2011
Messages
38
Greetings...

This site has done wonders for many of old friends who I've lost all touch with once they've found bigger paying jobs :D

I have a daily report of tracking information that i am needing to modify as rapid as possible. I need excel to recognize values in two columns and create 6-10 new columns in the same sheet or a new sheet with populated information.

eg..

*date*mile*beginCITY*beginSTATE*finalCITY*finalSTATE*size*time*who*what*

As the program recognizes a specific value for *beginCITY*beginSTATE* column as *Chicago*IL* I need it to create 3-5 new rows with all the same data but preset cities/states for that determined *Chicago*IL* and then do the same for *finalCITY*finalSTATE* 3-5 new rows only the city and state will change to the predetermined "outer cities/states"

Can anybody think of a way to start as i will be continuously be adding data for the city and state ranges (ie everytime it sees a Chicago IL it will make new row for 3-5 predetermined values i set)

Thank you for your time,
 
Sort by date Sort by votes
Now I hope I didnt set myself up for failure on this, there is actually more columns than Ive shown, generally the reports go out to column "AI", would there be a way i can setup column "L" for column "AO"?

I though by editing the macro i could get it to work but no chance....It works before I try to edit to our specs..

Excel Workbook
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAO
1LOAD#CALLSTATUSFLAGOKCUSTOMERSHIPDELIVSTIMEDTIMESHIP CITYS STCONS CITYC ST$CUST$CARRCARRIERMILESPHONETYPEWEIGHTEQUIPPALLET TOTSALESPERSONDISPATCHERSTOPSPO#BOL#INVOICEDDRIVERDRIVER CELTRAILER#REF#NOTESTRUCK#
201300ACTIVECOMPANIES40771407731600700FORT COLLINSCOOAKLANDCA00687TL44000VRMEHER1234567812345678=K2&" "&L2&" | "&M2& " "&N2
301300ACTIVECOMPANIES40770407731600700FORT COLLINSCOSAN DIEGOCA00687TL44000RMEHER1234567812345678=K3&" "&L3&" | "&M3& " "&N3
401000ACTIVECOMPANIES40769407711300600FORT COLLINSCOGRANITE CITYIL001047TL44000VRMEHER1234567812345678=K4&" "&L4&" | "&M4& " "&N4
501400ACTIVECOMPANIES40774407751700900JACKSONVILLEFLCHARLESTONSC00207TL44000VRMEHER1234567812345678=K5&" "&L5&" | "&M5& " "&N5
60SCHEDACTIVECOMPANIES4077140772SCHED600JACKSONVILLEFLCHARLESTONSC00327TL44000VRMEHER1234567812345678=K6&" "&L6&" | "&M6& " "&N6
Sheet2




I changed the macro to look like the following, change "L2" with "AO2" and
w2.Columns(12).ClearContents to w2.Columns(41).ClearContents thinking that would fix but no....

Option Explicit
Sub ReorgData()
' hiker95, 08/11/2011
' http://www.mrexcel.com/forum/showthread.php?t=548474
Dim w1 As Worksheet, w2 As Worksheet
Dim LR As Long, a As Long, FR As Long, SR As Long, ER As Long
Application.ScreenUpdating = True
Set w1 = Worksheets("Sheet1")
Set w2 = Worksheets("Sheet2")
w2.Columns(41).ClearContents
LR = w2.Cells(Rows.Count, 1).End(xlUp).Row
With w2.Range("ao2:ao" & LR)
.FormulaR1C1 = "=RC[-9]&"" ""&RC[-8]&"" | ""&RC[-6]& "" ""&RC[-5]"
.Value = .Value
End With
For a = LR To 2 Step -1
FR = 0
On Error Resume Next
FR = Application.Match(w2.Range("ao" & a), w1.Columns(1), 0)
On Error GoTo 0
If FR <> 0 Then
SR = FR + 1
ER = w1.Range("B" & SR).End(xlDown).Row
w2.Rows(a).Offset(1).Resize(ER - SR + 1).Insert
w2.Rows(a).Copy w2.Rows(a).Offset(1).Resize(ER - SR + 1)
Application.DisplayAlerts = False
w1.Range("B" & SR & ":C" & ER).Copy w2.Range("C" & a + 1).Resize(ER - SR, 2)
Application.DisplayAlerts = False
w1.Range("D" & SR & ":E" & ER).Copy w2.Range("F" & a + 1).Resize(ER - SR, 2)
End If
Next a
w2.Columns(41).ClearContents
w2.Activate
Application.ScreenUpdating = False
End SubI
 
Upvote 0

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
Also, do you have any suggestions on a way to have the user select which of the lanes(rows) they want to multiply?

Sometimes we have 3-5 of the same shipment or we have shipments that on certain days we do not want to have creatively made....Would that be the part where we only put the formula =K2&" "&L2&" | "&M2& " "&N2 for only the lanes we want the macro to work?
 
Upvote 0
I have added another shipping lane as well, with this macro will I be able to add more and more lanes onto sheet 1?


Excel Workbook
ABCDE
1*Origin-CityOr-StDest-CityDe-St
2FORT COLLINS CO | OAKLAND CA****
3*DENVERCOOAKLANDCA
4*SIDNEYNEOAKLANDCA
5*COLBYKSOAKLANDCA
6*PUEBLOCOOAKLANDCA
7*CHEYENNEWYOAKLANDCA
8*FORT COLLINSCOFRESNOCA
9*FORT COLLINSCOSAN FRANCISCOCA
10*FORT COLLINSCOSACRAMENTOCA
11*FORT COLLINSCOSTOCKTONCA
12*FORT COLLINSCOYUBA CITYCA
13FORT COLLINS CO | GRANITE CITY IL****
14*DENVERCOGRANITE CITYIL
15*SIDNEYNEGRANITE CITYIL
16*COLBYKSGRANITE CITYIL
17*PUEBLOCOGRANITE CITYIL
18*CHEYENNEWYGRANITE CITYIL
19*FORT COLLINSCOST LOUISMO
20*FORT COLLINSCOCAPE GIRARDEAUMO
21*FORT COLLINSCOQUINCYIL
22*FORT COLLINSCOSPRINGFIELDIL
23*FORT COLLINSCOEVANSVILLEIN
24*FORT COLLINSCOKANSAS CITYMO
25FORT COLLINS CO | SAN DIEGO CA****
26*DENVERCOSAN DIEGOCA
27*SIDNEYNESAN DIEGOCA
28*COLBYKSSAN DIEGOCA
29*PUEBLOCOSAN DIEGOCA
30*CHEYENNEWYSAN DIEGOCA
31*FORT COLLINSCOIMPERIALCA
32*FORT COLLINSCOOCEANSIDECA
33*FORT COLLINSCORIVERSIDECA
34*FORT COLLINSCOYUMAAZ
35*FORT COLLINSCOBLYTHECA
36JACKSONVILLE FL | CHARLESTON SC****
37*SAVANNAHGACHARLESTONSC
38*TAMPAFLCHARLESTONSC
39*ORLANDOFLCHARLESTONSC
40*VALDOSTAGACHARLESTONSC
Sheet1
 
Last edited:
Upvote 0
Kreiz,


Sample worksheets:


Excel Workbook
ABCDE
1Origin-CityOr-StDest-CityDe-St
2FORT COLLINS CO | OAKLAND CA
3DENVERCOOAKLANDCA
4SIDNEYNEOAKLANDCA
5COLBYKSOAKLANDCA
6PUEBLOCOOAKLANDCA
7CHEYENNEWYOAKLANDCA
8FORT COLLINSCOFRESNOCA
9FORT COLLINSCOSAN FRANCISCOCA
10FORT COLLINSCOSACRAMENTOCA
11FORT COLLINSCOSTOCKTONCA
12FORT COLLINSCOYUBA CITYCA
13FORT COLLINS CO | GRANITE CITY IL
14DENVERCOGRANITE CITYIL
15SIDNEYNEGRANITE CITYIL
16COLBYKSGRANITE CITYIL
17PUEBLOCOGRANITE CITYIL
18CHEYENNEWYGRANITE CITYIL
19FORT COLLINSCOST LOUISMO
20FORT COLLINSCOCAPE GIRARDEAUMO
21FORT COLLINSCOQUINCYIL
22FORT COLLINSCOSPRINGFIELDIL
23FORT COLLINSCOEVANSVILLEIN
24FORT COLLINSCOKANSAS CITYMO
25FORT COLLINS CO | SAN DIEGO CA
26DENVERCOSAN DIEGOCA
27SIDNEYNESAN DIEGOCA
28COLBYKSSAN DIEGOCA
29PUEBLOCOSAN DIEGOCA
30CHEYENNEWYSAN DIEGOCA
31FORT COLLINSCOIMPERIALCA
32FORT COLLINSCOOCEANSIDECA
33FORT COLLINSCORIVERSIDECA
34FORT COLLINSCOYUMAAZ
35FORT COLLINSCOBLYTHECA
36JACKSONVILLE FL | CHARLESTON SC
37SAVANNAHGACHARLESTONSC
38TAMPAFLCHARLESTONSC
39ORLANDOFLCHARLESTONSC
40VALDOSTAGACHARLESTONSC
41
Sheet1





Worksheet Sheet2 before the macro (with some columns hidden for brevity):


Excel Workbook
ABGHIJKLMNRAAABACAI
1LOAD#CALLSHIPDELIVSTIMEDTIMESHIP CITYS STCONS CITYC STMILESPO#BOL#INVOICEDTRUCK#
20130040771407731600700FORT COLLINSCOOAKLANDCA6871234567812345678
30130040770407731600700FORT COLLINSCOSAN DIEGOCA6871234567812345678
40100040769407711300600FORT COLLINSCOGRANITE CITYIL10471234567812345678
50140040774407751700900JACKSONVILLEFLCHARLESTONSC2071234567812345678
60SCHED4077140772SCHED600JACKSONVILLEFLCHARLESTONSC3271234567812345678
7
Sheet2





After the macro (the RED font shows the inserted informaiton):


Excel Workbook
ABGHIJKLMNRAAABACAI
1LOAD#CALLSHIPDELIVSTIMEDTIMESHIP CITYS STCONS CITYC STMILESPO#BOL#INVOICEDTRUCK#
20130040771407731600700FORT COLLINSCOOAKLANDCA6871234567812345678
30130040771407731600700DENVERCOOAKLANDCA6871234567812345678
40130040771407731600700SIDNEYNEOAKLANDCA6871234567812345678
50130040771407731600700COLBYKSOAKLANDCA6871234567812345678
60130040771407731600700PUEBLOCOOAKLANDCA6871234567812345678
70130040771407731600700CHEYENNEWYOAKLANDCA6871234567812345678
80130040771407731600700FORT COLLINSCOFRESNOCA6871234567812345678
90130040771407731600700FORT COLLINSCOSAN FRANCISCOCA6871234567812345678
100130040771407731600700FORT COLLINSCOSACRAMENTOCA6871234567812345678
110130040771407731600700FORT COLLINSCOSTOCKTONCA6871234567812345678
120130040771407731600700FORT COLLINSCOYUBA CITYCA6871234567812345678
130130040770407731600700FORT COLLINSCOSAN DIEGOCA6871234567812345678
140130040770407731600700DENVERCOSAN DIEGOCA6871234567812345678
150130040770407731600700SIDNEYNESAN DIEGOCA6871234567812345678
160130040770407731600700COLBYKSSAN DIEGOCA6871234567812345678
170130040770407731600700PUEBLOCOSAN DIEGOCA6871234567812345678
180130040770407731600700CHEYENNEWYSAN DIEGOCA6871234567812345678
190130040770407731600700FORT COLLINSCOIMPERIALCA6871234567812345678
200130040770407731600700FORT COLLINSCOOCEANSIDECA6871234567812345678
210130040770407731600700FORT COLLINSCORIVERSIDECA6871234567812345678
220130040770407731600700FORT COLLINSCOYUMAAZ6871234567812345678
230130040770407731600700FORT COLLINSCOBLYTHECA6871234567812345678
Sheet2





Excel Workbook
ABGHIJKLMNRAAABACAI
240100040769407711300600FORT COLLINSCOGRANITE CITYIL10471234567812345678
250100040769407711300600DENVERCOGRANITE CITYIL10471234567812345678
260100040769407711300600SIDNEYNEGRANITE CITYIL10471234567812345678
270100040769407711300600COLBYKSGRANITE CITYIL10471234567812345678
280100040769407711300600PUEBLOCOGRANITE CITYIL10471234567812345678
290100040769407711300600CHEYENNEWYGRANITE CITYIL10471234567812345678
300100040769407711300600FORT COLLINSCOST LOUISMO10471234567812345678
310100040769407711300600FORT COLLINSCOCAPE GIRARDEAUMO10471234567812345678
320100040769407711300600FORT COLLINSCOQUINCYIL10471234567812345678
330100040769407711300600FORT COLLINSCOSPRINGFIELDIL10471234567812345678
340100040769407711300600FORT COLLINSCOEVANSVILLEIN10471234567812345678
350100040769407711300600FORT COLLINSCOKANSAS CITYMO10471234567812345678
360140040774407751700900JACKSONVILLEFLCHARLESTONSC2071234567812345678
370140040774407751700900SAVANNAHGACHARLESTONSC2071234567812345678
380140040774407751700900TAMPAFLCHARLESTONSC2071234567812345678
390140040774407751700900ORLANDOFLCHARLESTONSC2071234567812345678
400140040774407751700900VALDOSTAGACHARLESTONSC2071234567812345678
410SCHED4077140772SCHED600JACKSONVILLEFLCHARLESTONSC3271234567812345678
420SCHED4077140772SCHED600SAVANNAHGACHARLESTONSC3271234567812345678
430SCHED4077140772SCHED600TAMPAFLCHARLESTONSC3271234567812345678
440SCHED4077140772SCHED600ORLANDOFLCHARLESTONSC3271234567812345678
450SCHED4077140772SCHED600VALDOSTAGACHARLESTONSC3271234567812345678
46
Sheet2





Code to follow before I timeout.
 
Upvote 0
Kreiz,


Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).

1. Copy the below code, by highlighting the code and pressing the keys CTRL + C
2. Open your workbook
3. Press the keys ALT + F11 to open the Visual Basic Editor
4. Press the keys ALT + I to activate the Insert menu
5. Press M to insert a Standard Module
6. Where the cursor is flashing, paste the code by pressing the keys CTRL + V
7. Press the keys ALT + Q to exit the Editor, and return to Excel
8. To run the macro from Excel, open the workbook, and press ALT + F8 to display the Run Macro Dialog. Double Click the macro's name to Run it.


Code: 
Option Explicit
Sub ReorgDataV2()
' hiker95, 08/13/2011
' http://www.mrexcel.com/forum/showthread.php?t=548474
Dim w1 As Worksheet, w2 As Worksheet
Dim LR As Long, a As Long, FR As Long, SR As Long, ER As Long
Application.ScreenUpdating = True
Set w1 = Worksheets("Sheet1")
Set w2 = Worksheets("Sheet2")
w2.Columns("AO:AO").ClearContents
LR = w2.Cells(Rows.Count, 1).End(xlUp).Row
With w2.Range("AO2:AO" & LR)
  .FormulaR1C1 = "=RC[-30]&"" ""&RC[-29]&"" | ""&RC[-28]&"" ""&RC[-27]"
  .Value = .Value
End With
For a = LR To 2 Step -1
  FR = 0
  On Error Resume Next
  FR = Application.Match(w2.Range("AO" & a), w1.Columns(1), 0)
  On Error GoTo 0
  If FR <> 0 Then
    SR = FR + 1
    ER = w1.Range("B" & SR).End(xlDown).Row
    w2.Rows(a).Offset(1).Resize(ER - SR + 1).Insert
    w2.Rows(a).Copy w2.Rows(a).Offset(1).Resize(ER - SR + 1)
    Application.DisplayAlerts = False
    w1.Range("B" & SR & ":E" & ER).Copy w2.Range("K" & a + 1).Resize(ER - SR, 4)
    Application.DisplayAlerts = True
  End If
Next a
w2.Columns("AO:AO").ClearContents
w2.Activate
Application.ScreenUpdating = False
End Sub


Before you use the macro with Excel 2007 or newer, save your workbook, Save As, a macro enabled workbook with the file extension .xlsm


Then run the ReorgDataV2 macro.
 
Upvote 0
Hiker you are a BIG help! I greatly appreciate it, this works to the "T" I am now looking at all my orders and boggled that with a click 20 becomes 120 with ease....is there a way that I set this so that ONLY the rows with "X" in in column: A will get the '''K2&" "&L2&" | "&M2& " "&N2''' ?

As such this will make it so that the entire data column AO isn't populated and ALL the shipments ARE NOT multiplied, only the ones the user puts X in place of the LOAD# will get multiplied?

I have tried changing you following statement to fit this need but have been unsuccessful in getting excel to recognize a value in column A and place a formula in column AO

With w2.Range("AO2:AO" & LR)
.FormulaR1C1 = "=RC[-30]&"" ""&RC[-29]&"" | ""&RC[-28]&"" ""&RC[-27]"
.Value = .Value
End With
 
Upvote 0
Kreiz,


Sample worksheets:


Excel Workbook
ABCDE
1Origin-CityOr-StDest-CityDe-St
2FORT COLLINS CO | OAKLAND CA
3DENVERCOOAKLANDCA
4SIDNEYNEOAKLANDCA
5COLBYKSOAKLANDCA
6PUEBLOCOOAKLANDCA
7CHEYENNEWYOAKLANDCA
8FORT COLLINSCOFRESNOCA
9FORT COLLINSCOSAN FRANCISCOCA
10FORT COLLINSCOSACRAMENTOCA
11FORT COLLINSCOSTOCKTONCA
12FORT COLLINSCOYUBA CITYCA
13FORT COLLINS CO | GRANITE CITY IL
14DENVERCOGRANITE CITYIL
15SIDNEYNEGRANITE CITYIL
16COLBYKSGRANITE CITYIL
17PUEBLOCOGRANITE CITYIL
18CHEYENNEWYGRANITE CITYIL
19FORT COLLINSCOST LOUISMO
20FORT COLLINSCOCAPE GIRARDEAUMO
21FORT COLLINSCOQUINCYIL
22FORT COLLINSCOSPRINGFIELDIL
23FORT COLLINSCOEVANSVILLEIN
24FORT COLLINSCOKANSAS CITYMO
25FORT COLLINS CO | SAN DIEGO CA
26DENVERCOSAN DIEGOCA
27SIDNEYNESAN DIEGOCA
28COLBYKSSAN DIEGOCA
29PUEBLOCOSAN DIEGOCA
30CHEYENNEWYSAN DIEGOCA
31FORT COLLINSCOIMPERIALCA
32FORT COLLINSCOOCEANSIDECA
33FORT COLLINSCORIVERSIDECA
34FORT COLLINSCOYUMAAZ
35FORT COLLINSCOBLYTHECA
36JACKSONVILLE FL | CHARLESTON SC
37SAVANNAHGACHARLESTONSC
38TAMPAFLCHARLESTONSC
39ORLANDOFLCHARLESTONSC
40VALDOSTAGACHARLESTONSC
41
Sheet1





Excel Workbook
ABGHIJKLMNRAAABACAI
1LOAD#CALLSHIPDELIVSTIMEDTIMESHIP CITYS STCONS CITYC STMILESPO#BOL#INVOICEDTRUCK#
20130040771407731600700FORT COLLINSCOOAKLANDCA6871234567812345678
3X130040770407731600700FORT COLLINSCOSAN DIEGOCA6871234567812345678
40100040769407711300600FORT COLLINSCOGRANITE CITYIL10471234567812345678
5X140040774407751700900JACKSONVILLEFLCHARLESTONSC2071234567812345678
60SCHED4077140772SCHED600JACKSONVILLEFLCHARLESTONSC3271234567812345678
7
Sheet2





After the new macro:


Excel Workbook
ABGHIJKLMNRAAABACAI
1LOAD#CALLSHIPDELIVSTIMEDTIMESHIP CITYS STCONS CITYC STMILESPO#BOL#INVOICEDTRUCK#
20130040771407731600700FORT COLLINSCOOAKLANDCA6871234567812345678
3X130040770407731600700FORT COLLINSCOSAN DIEGOCA6871234567812345678
4X130040770407731600700DENVERCOSAN DIEGOCA6871234567812345678
5X130040770407731600700SIDNEYNESAN DIEGOCA6871234567812345678
6X130040770407731600700COLBYKSSAN DIEGOCA6871234567812345678
7X130040770407731600700PUEBLOCOSAN DIEGOCA6871234567812345678
8X130040770407731600700CHEYENNEWYSAN DIEGOCA6871234567812345678
9X130040770407731600700FORT COLLINSCOIMPERIALCA6871234567812345678
10X130040770407731600700FORT COLLINSCOOCEANSIDECA6871234567812345678
11X130040770407731600700FORT COLLINSCORIVERSIDECA6871234567812345678
12X130040770407731600700FORT COLLINSCOYUMAAZ6871234567812345678
13X130040770407731600700FORT COLLINSCOBLYTHECA6871234567812345678
140100040769407711300600FORT COLLINSCOGRANITE CITYIL10471234567812345678
15X140040774407751700900JACKSONVILLEFLCHARLESTONSC2071234567812345678
16X140040774407751700900SAVANNAHGACHARLESTONSC2071234567812345678
17X140040774407751700900TAMPAFLCHARLESTONSC2071234567812345678
18X140040774407751700900ORLANDOFLCHARLESTONSC2071234567812345678
19X140040774407751700900VALDOSTAGACHARLESTONSC2071234567812345678
200SCHED4077140772SCHED600JACKSONVILLEFLCHARLESTONSC3271234567812345678
21
Sheet2





Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).


Code: 
Option Explicit
Sub ReorgDataV3wXinColA()
' hiker95, 08/15/2011
' http://www.mrexcel.com/forum/showthread.php?t=548474
Dim w1 As Worksheet, w2 As Worksheet
Dim LR As Long, a As Long, FR As Long, SR As Long, ER As Long
Set w1 = Worksheets("Sheet1")
Set w2 = Worksheets("Sheet2")
a = Application.CountIf(w2.Columns(1), "X")
If a = 0 Then
  MsgBox "There are no single character  X  in the rows in column A in Sheet2 - macro terminated!"
  Exit Sub
End If
Application.ScreenUpdating = False
w2.Columns("AO:AO").ClearContents
LR = w2.Cells(Rows.Count, 1).End(xlUp).Row
For a = 2 To LR Step 1
  If w2.Cells(a, 1) = "X" Or w2.Cells(a, 1) = "x" Then
    With w2.Range("AO" & a)
      .FormulaR1C1 = "=RC[-30]&"" ""&RC[-29]&"" | ""&RC[-28]&"" ""&RC[-27]"
      .Value = .Value
    End With
  End If
Next a
For a = LR To 2 Step -1
  If w2.Cells(a, "AO") = "" Then
    'do nothing
  Else
    FR = 0
    On Error Resume Next
    FR = Application.Match(w2.Range("AO" & a), w1.Columns(1), 0)
    On Error GoTo 0
    If FR <> 0 Then
      SR = FR + 1
      ER = w1.Range("B" & SR).End(xlDown).Row
      w2.Rows(a).Offset(1).Resize(ER - SR + 1).Insert
      w2.Rows(a).Copy w2.Rows(a).Offset(1).Resize(ER - SR + 1)
      Application.DisplayAlerts = False
      w1.Range("B" & SR & ":E" & ER).Copy w2.Range("K" & a + 1).Resize(ER - SR, 4)
      Application.DisplayAlerts = True
    End If
  End If
Next a
w2.Columns("AO:AO").ClearContents
w2.Activate
Application.ScreenUpdating = True
End Sub


Before you use the macro with Excel 2007 or newer, save your workbook, Save As, a macro enabled workbook with the file extension .xlsm

Then run the ReorgDataV3wXinColA macro.
 
Upvote 0
Hiker you are a Hero!

Sorry for the delay, I've been running loops around the office to catch up on what I've neglected these past weeks while learning Excel all day :rofl:
 
Upvote 0
You must log in or register to reply here.

Similar threads

R
  • Solved
Compare similar company names between two tables and return one of the values
Replies
2
Views
1K
realtoast
R
U
  • Question Question
When a value is detected in a cell, a VBA code or function will insert a new row with specific values and functions already in each cell
Replies
0
Views
347
ubergreen
U
U
  • Question Question
Create a new sheet in a separate workbook for each group of matching numbers/values
Replies
0
Views
247
ubergreen
U
D
  • Question Question
Generating Reports in Word Using Data in Excel
Replies
1
Views
399
Dan_W
D
D
  • Question Question
VBA Code to Apply an AVERAGE of a Range on Cells as New Records are added Via a User Form
Replies
2
Views
88
Denny57
D

Forum statistics

Threads
1,224,534
Messages
6,179,390
Members
452,909
Latest member
VickiS

Share this page

We've detected that you are using an adblocker.

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.
Go back
Back
Top