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

[ankrups]

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.

 

[ankrups]

Hi there,

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

22 9
1 3Y1DPOSSIHI2Q9NK66HAKEP03 TRUE

 

[rjwebgraphix]

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
	A	B	C	D
1	CUSTOMER NAME:	JOHN LTD.
2
3	PRODUCT NAME	KEY LINES	01/13/13	02/13/13
4	XYZ	BASELINE	1200	1400
5		PROMO	5000
6
7	123	BASELINE	2200	3300
8		PROMO	5000
9
10	QWE	BASELINE	1200	1400
11		PROMO	5000
Sheet

Second Worksheet with Dummy Data

Excel Workbook
	A	B	C	D
1	CUSTOMER NAME:	LAWRENCE LTD.
2
3	PRODUCT NAME	KEY LINES	13-Jan	13-Feb
4	XYZ	BASELINE	12000	14000
5		PROMO	50000
6
7	123	BASELINE	22000	33000
8		PROMO	50000
9
10	QWE	BASELINE	12000	14000
11		PROMO	50000
Sheet

Resulting Data

Excel Workbook
	A	B	C	D	E
1	PRODUCT NAME	CUSTOMER NAME:	KEY LINES	01/13/13	02/13/13
2	XYZ	JOHN LTD.	BASELINE	1200	1400
3	BASELINE	JOHN LTD.	PROMO	5000
4	123	JOHN LTD.	BASELINE	2200	3300
5	BASELINE	JOHN LTD.	PROMO	5000
6	QWE	JOHN LTD.	BASELINE	1200	1400
7	BASELINE	JOHN LTD.	PROMO	5000
8	XYZ	LAWRENCE LTD.	BASELINE	12000	14000
9	BASELINE	LAWRENCE LTD.	PROMO	50000
10	123	LAWRENCE LTD.	BASELINE	22000	33000
11	BASELINE	LAWRENCE LTD.	PROMO	50000
12	QWE	LAWRENCE LTD.	BASELINE	12000	14000
13	BASELINE	LAWRENCE LTD.	PROMO	50000
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.

 

[ankrups]

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...