VBA to copy all the text and numbers between the same or two supplied keywords in many rows of Excel sheet1 into a single column in the rows of sheet2

S

sr1111

New Member
Joined
Sep 2, 2022
Messages
46
Office Version
  1. 2013
  2. 2011
  3. 2010
  4. 2007
Platform
  1. Windows
VBA to copy all the text and numbers between the same or two supplied keywords in many rows of Excel sheet1 into a single column in the rows of sheet2
Say The two given keywords/symbols are: "**1**" and "::::"
Excel sheet data is in approx a million rows.
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
You must log in or register to reply here.

Similar threads

I
  • Question Question
Searching multiple occurence of same keyword from text file and saving its output in different Excel worksheets
Replies
5
Views
324
myall_blues
myall_blues
V
  • Question Question
copy from source sheet1 to destination sheet2 vba code
Replies
1
Views
239
Vishaal
V
Y
  • Question Question
VBA to copy, format, drag down data from other workbooks
Replies
1
Views
436
Yna26
Y
M
  • Solved
VBA to Insert Mismatched Row in separate worksheet
2 3
Replies
21
Views
648
Peter_SSs
Peter_SSs
O
  • Question Question
Running through a Config and pulling out the relevant information using keywords into smaller sheets
Replies
0
Views
283
oitbc
O

Forum statistics

Threads
1,223,234
Messages
6,170,891
Members
452,366
Latest member
TePunaBloke

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