Using VBA to search over multiple sheets and paste data into new one

drabbit

New Member
Joined
Oct 4, 2021
Messages
7
Office Version
  1. 365
Platform
  1. Windows
Hello,
Im new in VBA, and im searching for a script that would search in multiple sheets within one woorkbook, for specific text (specified in script itself) and paste it in a new sheet. for a descritpion:
- multiple sheets (search in all of them)
- skip new reference sheet + few others sheets - for example sheet3 and sheet4
- in all sheets i've got names and number of hours next to them, I need to look for specific name within all sheets and once there copy whole row with it.
- if name is within sheet copy cell value B12 and C13 as well within same row in output sheet.

I've been searching for something like this within threads,and i found similarities but as I started this week i was not able to pull together exactly what I need from several scripts. Thank you for every answer.
 

drabbit

New Member
Joined
Oct 4, 2021
Messages
7
Office Version
  1. 365
Platform
  1. Windows
Thanks a lot, I put a bit of modification and its working like charm, is there also possibility to copy with the name from every source sheet, also cell B12 and C13?
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

abhi221996

New Member
Joined
Sep 29, 2021
Messages
12
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
hello there!
i am trying to copy every chart from multiple sheets and arranging them in a single sheet.
like searching every sheet for chart and then pasting it to a single new sheet.
but i am not getting the way of copying all the activecharts from every sheet and pasting and arranging all the charts to a single new sheet.
 

Forum statistics

Threads
1,147,733
Messages
5,742,859
Members
423,760
Latest member
photogfrog

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
Top