Copy data from specific location and paste as value in different tab within file.

ankrups

Board Regular
Joined
Mar 14, 2006
Messages
127
Office Version
  1. 2021
Platform
  1. Windows
Hello,

I have a situation that I have 30 tab in a file and want to copy specific location from all tabs (excluding 5 tabs that I described) and past into specific location in "IMPORT" tab one after another row.

Note:
It should be coded such a way that any future creation of tab with the same formate, should copy as per rest.
Should exclude 5 tabs that I described including "IMPORT" tab.

Please help me out to overcome this scenario.
 
Hi there,

In IMPORT TAB, doesn't copy the data from specific location. Out put is like below.

22 9
1 3Y1DPOSSIHI2Q9NK66HAKEP03 TRUE
 
Upvote 0
That makes no sense. Use an HTML maker to show me or at least give full detail. There's no such thing as too much information. Doesn't copy what specifically? From what location is it not copying from....

This is what it does.

First Worksheet with Dummy Data
Excel Workbook
ABCD
1CUSTOMER NAME:JOHN LTD.
2
3PRODUCT NAMEKEY LINES01/13/1302/13/13
4XYZBASELINE12001400
5PROMO5000
6
7123BASELINE22003300
8PROMO5000
9
10QWEBASELINE12001400
11PROMO5000
Sheet


Second Worksheet with Dummy Data
Excel Workbook
ABCD
1CUSTOMER NAME:LAWRENCE LTD.
2
3PRODUCT NAMEKEY LINES13-Jan13-Feb
4XYZBASELINE1200014000
5PROMO50000
6
7123BASELINE2200033000
8PROMO50000
9
10QWEBASELINE1200014000
11PROMO50000
Sheet


Resulting Data
Excel Workbook
ABCDE
1PRODUCT NAMECUSTOMER NAME:KEY LINES01/13/1302/13/13
2XYZJOHN LTD.BASELINE12001400
3BASELINEJOHN LTD.PROMO5000
4123JOHN LTD.BASELINE22003300
5BASELINEJOHN LTD.PROMO5000
6QWEJOHN LTD.BASELINE12001400
7BASELINEJOHN LTD.PROMO5000
8XYZLAWRENCE LTD.BASELINE1200014000
9BASELINELAWRENCE LTD.PROMO50000
10123LAWRENCE LTD.BASELINE2200033000
11BASELINELAWRENCE LTD.PROMO50000
12QWELAWRENCE LTD.BASELINE1200014000
13BASELINELAWRENCE LTD.PROMO50000
Sheet


Is this not what you need? If not, specifically in detail, what is not as desired. Give cell references, worksheet references, what's in the cell and so on.
 
Upvote 0
This is exactly i need but some how code is not working from my side..

HTML 4 is also can't install add in due to excel version that I have. Currently I have 2010 excel version.

I will send you soon the screen shot..do you know any other HTML add in that I can show your the image...
 
Upvote 0

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