Two different sheet data to be pasted on one another sheet

V

vishu123

New Member
Joined
Jul 26, 2019
Messages
6
I have a excel sheet where Sheet 2 named as 'master sheet' and sheet 3 named as 'revenue data'. I want to enter the company name in cell G2 in sheet 1 which will search the same name in column F of 'Master Sheet' and paste it in sheet 1 below master header. Similary the value of G2 needs to be searched in column B of 'Revenue Sheet' and then paste it in the sheet 1 below Revenue header.


Fro example: if I write 'Moto' in cell G2 and on clicking on Submit button then Moto name should be searched in both the Master & Revenue sheet and output should be pasted in the sheet 1 below each headers.


I don't have any knowledge of macro. Can you please help me in creating macro for the same
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
Sort by date Sort by votes
Master Tab has below data:

[TABLE="width: 1024"]
<colgroup><col width="64" span="16" style="width:48pt"></colgroup><tbody> [TR]
[TD][TABLE="width: 448"]
<colgroup><col width="64" span="7" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl65, width: 64"]Name[/TD]
[TD="class: xl65, width: 64"]Group[/TD]
[TD="class: xl65, width: 64"]Type[/TD]
[TD="class: xl65, width: 64"]Year[/TD]
[TD="class: xl65, width: 64"]Designation[/TD]
[TD="class: xl65, width: 64"]Company[/TD]
[TD="class: xl65, width: 64"]Link[/TD]
[/TR]
[TR]
[TD="class: xl65"]Anurag[/TD]
[TD="class: xl65"]abc[/TD]
[TD="class: xl65"]Employee[/TD]
[TD="class: xl65"]Current[/TD]
[TD="class: xl65"]Associate[/TD]
[TD="class: xl65"]Nokia[/TD]
[TD="class: xl65"]sjdchbdjh[/TD]
[/TR]
[TR]
[TD="class: xl65"]Amit[/TD]
[TD="class: xl65"]def[/TD]
[TD="class: xl65"]Customer[/TD]
[TD="class: xl65"]Previous[/TD]
[TD="class: xl65"]None[/TD]
[TD="class: xl65"]1 Store[/TD]
[TD="class: xl65"]ascvsdjcv[/TD]
[/TR]
[TR]
[TD="class: xl65"]Anil[/TD]
[TD="class: xl65"]abc[/TD]
[TD="class: xl65"]Customer[/TD]
[TD="class: xl65"]Current[/TD]
[TD="class: xl65"]None[/TD]
[TD="class: xl65"]2 Store[/TD]
[TD="class: xl65"]asdcbhsd[/TD]
[/TR]
[TR]
[TD="class: xl65"]Aditya[/TD]
[TD="class: xl66"]jkl[/TD]
[TD="class: xl65"]Customer[/TD]
[TD="class: xl65"]Previous[/TD]
[TD="class: xl65"]Associate[/TD]
[TD="class: xl65"]Samsung[/TD]
[TD="class: xl65"]asdcbhjdc[/TD]
[/TR]
[TR]
[TD="class: xl65"]Kauti[/TD]
[TD="class: xl65"]def[/TD]
[TD="class: xl65"]Employee[/TD]
[TD="class: xl65"]Previous[/TD]
[TD="class: xl65"]Associate[/TD]
[TD="class: xl65"]Samsung[/TD]
[TD="class: xl65"]sdccd[/TD]
[/TR]
[TR]
[TD="class: xl65"]Abhi[/TD]
[TD="class: xl65"]xyz[/TD]
[TD="class: xl65"]Investor[/TD]
[TD="class: xl65"]Current[/TD]
[TD="class: xl65"]Associate[/TD]
[TD="class: xl65"]Dell[/TD]
[TD="class: xl65"]asdjhcb[/TD]
[/TR]
[TR]
[TD="class: xl65"]Kun[/TD]
[TD="class: xl65"]wer[/TD]
[TD="class: xl65"]Investor[/TD]
[TD="class: xl65"]Current[/TD]
[TD="class: xl65"]Associate[/TD]
[TD="class: xl65"]Moto[/TD]
[TD="class: xl65"]tyhyh[/TD]
[/TR]
[TR]
[TD="class: xl65"]Art[/TD]
[TD="class: xl65"]drf[/TD]
[TD="class: xl65"]Customer[/TD]
[TD="class: xl65"]Current[/TD]
[TD="class: xl65"]None[/TD]
[TD="class: xl65"]LYF[/TD]
[TD="class: xl65"]cvbn[/TD]
[/TR]
[TR]
[TD="class: xl65"]Mai[/TD]
[TD="class: xl65"]xyz[/TD]
[TD="class: xl65"]Investor[/TD]
[TD="class: xl65"]Current[/TD]
[TD="class: xl65"]Associate[/TD]
[TD="class: xl65"]Moto[/TD]
[TD="class: xl65"]ert
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Revenue has below data:

[TABLE="width: 512"]
<colgroup><col width="64" span="8" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl65, width: 64"]Id[/TD]
[TD="class: xl65, width: 64"]Supplier Name[/TD]
[TD="class: xl65, width: 64"]Year 1[/TD]
[TD="class: xl65, width: 64"]Year 2[/TD]
[TD="class: xl65, width: 64"]Year 3[/TD]
[TD="class: xl65, width: 64"]Year 4[/TD]
[TD="class: xl65, width: 64"]Year 5[/TD]
[TD="class: xl65, width: 64"]Web Link[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]11[/TD]
[TD="class: xl65"]apple[/TD]
[TD="class: xl65, align: right"]65[/TD]
[TD="class: xl65, align: right"]87[/TD]
[TD="class: xl65, align: right"]94[/TD]
[TD="class: xl65, align: right"]67[/TD]
[TD="class: xl65, align: right"]54[/TD]
[TD="class: xl65"]sdcsd[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]22[/TD]
[TD="class: xl65"]Dell[/TD]
[TD="class: xl65, align: right"]72[/TD]
[TD="class: xl65, align: right"]96[/TD]
[TD="class: xl65, align: right"]55[/TD]
[TD="class: xl65, align: right"]55[/TD]
[TD="class: xl65, align: right"]72[/TD]
[TD="class: xl65"]zxc[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]33[/TD]
[TD="class: xl65"]LG[/TD]
[TD="class: xl65, align: right"]81[/TD]
[TD="class: xl65, align: right"]53[/TD]
[TD="class: xl65, align: right"]59[/TD]
[TD="class: xl65, align: right"]88[/TD]
[TD="class: xl65, align: right"]78[/TD]
[TD="class: xl65"]ghnhn[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]44[/TD]
[TD="class: xl65"]Samsung Pvt[/TD]
[TD="class: xl65, align: right"]69[/TD]
[TD="class: xl65, align: right"]88[/TD]
[TD="class: xl65, align: right"]74[/TD]
[TD="class: xl65, align: right"]75[/TD]
[TD="class: xl65, align: right"]86[/TD]
[TD="class: xl65"]cgfh[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]55[/TD]
[TD="class: xl65"]Dell[/TD]
[TD="class: xl65, align: right"]55[/TD]
[TD="class: xl65, align: right"]81[/TD]
[TD="class: xl65, align: right"]72[/TD]
[TD="class: xl65, align: right"]84[/TD]
[TD="class: xl65, align: right"]61[/TD]
[TD="class: xl65"]hjm[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]66[/TD]
[TD="class: xl65"]Moto Inc[/TD]
[TD="class: xl65, align: right"]86[/TD]
[TD="class: xl65, align: right"]73[/TD]
[TD="class: xl65, align: right"]79[/TD]
[TD="class: xl65, align: right"]61[/TD]
[TD="class: xl65, align: right"]76[/TD]
[TD="class: xl65"]dryty[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]77[/TD]
[TD="class: xl65"]Moto[/TD]
[TD="class: xl65, align: right"]54[/TD]
[TD="class: xl65, align: right"]58[/TD]
[TD="class: xl65, align: right"]88[/TD]
[TD="class: xl65, align: right"]63[/TD]
[TD="class: xl65, align: right"]93[/TD]
[TD="class: xl65"]bfbgb[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]88[/TD]
[TD="class: xl65"]LYF[/TD]
[TD="class: xl65, align: right"]72[/TD]
[TD="class: xl65, align: right"]69[/TD]
[TD="class: xl65, align: right"]75[/TD]
[TD="class: xl65, align: right"]54[/TD]
[TD="class: xl65, align: right"]83[/TD]
[TD="class: xl65"]wrtt[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]99[/TD]
[TD="class: xl65"]Dell Ltd[/TD]
[TD="class: xl65, align: right"]54[/TD]
[TD="class: xl65, align: right"]97[/TD]
[TD="class: xl65, align: right"]58[/TD]
[TD="class: xl65, align: right"]95[/TD]
[TD="class: xl65, align: right"]62[/TD]
[TD="class: xl65"]wer[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]12[/TD]
[TD="class: xl65"]LYF Mobile[/TD]
[TD="class: xl65, align: right"]50[/TD]
[TD="class: xl65, align: right"]86[/TD]
[TD="class: xl65, align: right"]53[/TD]
[TD="class: xl65, align: right"]79[/TD]
[TD="class: xl65, align: right"]50[/TD]
[TD="class: xl65"]dfbgb[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]13[/TD]
[TD="class: xl65"]apple[/TD]
[TD="class: xl65, align: right"]82[/TD]
[TD="class: xl65, align: right"]69[/TD]
[TD="class: xl65, align: right"]89[/TD]
[TD="class: xl65, align: right"]73[/TD]
[TD="class: xl65, align: right"]64[/TD]
[TD="class: xl65"]tyh[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]14[/TD]
[TD="class: xl65"]Samsung[/TD]
[TD="class: xl65, align: right"]89[/TD]
[TD="class: xl65, align: right"]94[/TD]
[TD="class: xl65, align: right"]80[/TD]
[TD="class: xl65, align: right"]72[/TD]
[TD="class: xl65, align: right"]50[/TD]
[TD="class: xl65"]gfhnh[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]15[/TD]
[TD="class: xl65"]LG[/TD]
[TD="class: xl65, align: right"]74[/TD]
[TD="class: xl65, align: right"]90[/TD]
[TD="class: xl65, align: right"]55[/TD]
[TD="class: xl65, align: right"]95[/TD]
[TD="class: xl65, align: right"]99[/TD]
[TD="class: xl65"]sdtr[/TD]
[/TR]
</tbody>[/TABLE]


I want in sheet 1 if I enter Moto in G2 then it should show me data in sheet 1 like:



Under Master Tab it must show:

[TABLE="width: 448"]
<colgroup><col width="64" span="7" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl65, width: 64"]Name[/TD]
[TD="class: xl65, width: 64"]Group[/TD]
[TD="class: xl65, width: 64"]Type[/TD]
[TD="class: xl65, width: 64"]Year[/TD]
[TD="class: xl65, width: 64"]Designation[/TD]
[TD="class: xl65, width: 64"]Company[/TD]
[TD="class: xl65, width: 64"]Link[/TD]
[/TR]
[TR]
[TD="class: xl65"]Kun[/TD]
[TD="class: xl65"]wer[/TD]
[TD="class: xl65"]Investor[/TD]
[TD="class: xl65"]Current[/TD]
[TD="class: xl65"]Associate[/TD]
[TD="class: xl65"]Moto[/TD]
[TD="class: xl65"]tyhyh[/TD]
[/TR]
[TR]
[TD="class: xl65"]Mai[/TD]
[TD="class: xl65"]xyz[/TD]
[TD="class: xl65"]Investor[/TD]
[TD="class: xl65"]Current[/TD]
[TD="class: xl65"]Associate[/TD]
[TD="class: xl65"]Moto[/TD]
[TD="class: xl65"]ert[/TD]
[/TR]
</tbody>[/TABLE]


Under Revenue header it must show

[TABLE="width: 512"]
<colgroup><col width="64" span="8" style="width: 48pt;"></colgroup><tbody>[TR]
[TD="class: xl65, width: 64"]Id[/TD]
[TD="class: xl65, width: 64"]Supplier Name[/TD]
[TD="class: xl65, width: 64"]Year 1[/TD]
[TD="class: xl65, width: 64"]Year 2[/TD]
[TD="class: xl65, width: 64"]Year 3[/TD]
[TD="class: xl65, width: 64"]Year 4[/TD]
[TD="class: xl65, width: 64"]Year 5[/TD]
[TD="class: xl65, width: 64"]Web Link[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]66[/TD]
[TD="class: xl65"]Moto Inc[/TD]
[TD="class: xl65, align: right"]86[/TD]
[TD="class: xl65, align: right"]73[/TD]
[TD="class: xl65, align: right"]79[/TD]
[TD="class: xl65, align: right"]61[/TD]
[TD="class: xl65, align: right"]76[/TD]
[TD="class: xl65"]dryty[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]77[/TD]
[TD="class: xl65"]Moto[/TD]
[TD="class: xl65, align: right"]54[/TD]
[TD="class: xl65, align: right"]58[/TD]
[TD="class: xl65, align: right"]88[/TD]
[TD="class: xl65, align: right"]63[/TD]
[TD="class: xl65, align: right"]93[/TD]
[TD="class: xl65"]bfbgb
[/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
Output would look like this:

[TABLE="width: 1152"]
<colgroup><col span="18"></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Moto[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]
clip_image002.png

<tbody>
</tbody>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 7"]Master Sheet[/TD]
[TD][/TD]
[TD="colspan: 8"]Revenue[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Name[/TD]
[TD]Group[/TD]
[TD]Type[/TD]
[TD]Year[/TD]
[TD]Designation[/TD]
[TD]Company[/TD]
[TD]Link[/TD]
[TD][/TD]
[TD]Id[/TD]
[TD]Supplier Name[/TD]
[TD]Year 1[/TD]
[TD]Year 2[/TD]
[TD]Year 3[/TD]
[TD]Year 4[/TD]
[TD]Year 5[/TD]
[TD]Web Link[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Kun[/TD]
[TD]wer[/TD]
[TD]Investor[/TD]
[TD]Current[/TD]
[TD]Associate[/TD]
[TD]Moto[/TD]
[TD]tyhyh[/TD]
[TD][/TD]
[TD="align: right"]66[/TD]
[TD]Moto Inc[/TD]
[TD="align: right"]86[/TD]
[TD="align: right"]73[/TD]
[TD="align: right"]79[/TD]
[TD="align: right"]61[/TD]
[TD="align: right"]76[/TD]
[TD]dryty[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Mai[/TD]
[TD]xyz[/TD]
[TD]Investor[/TD]
[TD]Current[/TD]
[TD]Associate[/TD]
[TD]Moto[/TD]
[TD]ert[/TD]
[TD][/TD]
[TD="align: right"]77[/TD]
[TD]Moto[/TD]
[TD="align: right"]54[/TD]
[TD="align: right"]58[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]63[/TD]
[TD="align: right"]93[/TD]
[TD]bfbgb[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
Try this

Change data in red by your information.
Code: 
Sub [B][COLOR=#0000ff]Copy_Data[/COLOR][/B]()
  Dim sh1 As Worksheet, sh2 As Worksheet, sh3 As Worksheet
  Set sh1 = Sheets("[COLOR=#ff0000]Sheet1[/COLOR]")
  Set sh2 = Sheets("[COLOR=#ff0000]Master[/COLOR]")
  Set sh3 = Sheets("[COLOR=#ff0000]Revenue[/COLOR]")
  
  sh1.Rows("3:" & Rows.Count).Clear
  sh2.Range("A1").AutoFilter Field:=6, Criteria1:="=*" & sh1.Range("G2") & "*"
  sh3.Range("A1").AutoFilter Field:=2, Criteria1:="=*" & sh1.Range("G2") & "*"
  sh2.AutoFilter.Range.EntireRow.Copy sh1.Range("A4")
  sh3.AutoFilter.Range.EntireRow.Copy sh1.Range("A" & Rows.Count).End(xlUp)(3)
End Sub

HOW TO INSTALL MACROs
------------------------------------
If you are new to macros, they are easy to install and use. To install it, simply press ALT+F11 to go into the VB editor and, once there, click Insert/Module on its menu bar, then copy/paste the above code into the code window that just opened up. That's it.... you are done. To use the macro, go back to the worksheet with your data on it and press ALT+F8, select the macro name (Copy_Data) from the list that appears and click the Run button. The macro will execute and perform the action(s) you asked for. If you will need to do this again in this same workbook, and if you are using XL2007 or above, make sure you save your file as an "Excel Macro-Enabled Workbook (*.xlsm) and answer the "do you want to enable macros" question as "Yes" or "OK" (depending on the button label for your version of Excel) the next time you open your workbook.
 
Upvote 0
Thanks a ton DanteAmor !!! This is working for me.

Only one change I want in this - after searching the records, it should paste side- by- side data for Master and revenue sheet with one blank column as separator.
 
Upvote 0
Master sheet have 7 columns so it should be pasted from cell A to cell G

Revenue sheet have 17 columns , so it should be pasted from cell I to cell W.

Also I want above Master's pasted Data, 7 cells merged and should be named as Master with Light Green Background. Similarly, above Revenue pasted data, 15 cells merged and should be named as Revenue with light blue background.

This will be really helpful if you can share codes on the basis of this requirement.

Thanks in Advance !!!
 
Upvote 0
vishu123 said:
Master sheet have 7 columns so it should be pasted from cell A to cell G

Revenue sheet have 17 columns , so it should be pasted from cell I to cell W.

Also I want above Master's pasted Data, 7 cells merged and should be named as Master with Light Green Background. Similarly, above Revenue pasted data, 15 cells merged and should be named as Revenue with light blue background.

This was not in the original requirement, it is better if you create a new thread.

This will be really helpful if you can share codes on the basis of this requirement.

Thanks in Advance !!!
Click to expand...


Try this

To leave a separation column.

Sub Copy_Data()
Dim sh1 As Worksheet, sh2 As Worksheet, sh3 As Worksheet
Set sh1 = Sheets("Sheet1")
Set sh2 = Sheets("Master")
Set sh3 = Sheets("Revenue")

sh1.Rows("3:" & Rows.Count).Clear
sh2.Range("A1").AutoFilter Field:=6, Criteria1:="=*" & sh1.Range("G2") & "*"
sh3.Range("A1").AutoFilter Field:=2, Criteria1:="=*" & sh1.Range("G2") & "*"
sh2.AutoFilter.Range.EntireRow.Copy sh1.Range("A4")
sh3.AutoFilter.Range.CurrentRegion.Copy sh1.Range("I4")
End Sub
 
Upvote 0
You must log in or register to reply here.

Similar threads

Z
  • Question Question
Vba - create new sheet and copy date into it.
Replies
1
Views
102
zerofeng
Z
J
  • Question Question
Formula for formula description.
Replies
2
Views
105
J23Excel
J
A
  • Question Question
Macro to import the same sheets names are repeated across files.
Replies
0
Views
84
Amer Omar
A
Y
  • Question Question
Consolidate all values from specific sheets into 1 master excel file
Replies
1
Views
263
Trebor76
T
F
  • Solved
Copy paste from one Excel workbook to another with same sheet names and update dates in range
Replies
8
Views
541
Skiier89
S

Forum statistics

Threads
1,224,737
Messages
6,180,664
Members
452,992
Latest member
TokugawaIesuma

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