Move row values then paste to data table

[ifeelalone]

Hey everyone,

Need help in moving rows from "Sheet1" to data table of "Sheet2"

Contents of Sheet 1

if I hit a button, or run a vba, contents from row 2 will be transferred to Sheet 2. Like this:

for multiple rows of Sheet 1, like this

they will be transferred to Sheet 2. Like this:

 

[NoSparks]

As displayed, you're not likely to get much assistance with this post.
I'd suggest uploading the file to a file sharing site such as box and posting the share link.

 

[Joe4]

I'd suggest uploading the file to a file sharing site such as box and posting the share link.

Or better yet, use some the tools to post screen images mentioned in section B here: https://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html, as many of us cannot/will not download files from the internet for security reasons. So you will reach a bigger audience by posting the images directly to the thread than you will by posting a file link to download from.

 

[ifeelalone]

Or better yet, use some the tools to post screen images mentioned in section B here: https://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html, as many of us cannot/will not download files from the internet for security reasons. So you will reach a bigger audience by posting the images directly to the thread than you will by posting a file link to download from.

Pardon me, but you mean to say that I should link the file for you to download? Are you unable to see the images? on my view, i can see the images well. or should I post the table rather than an image?

 

[ifeelalone]

hey everyone, thanks for your suggestion, i posted the new inquiry HERE since i cannot edit my post thanks for the help!

 

[Joe4]

Please do not start a new thread on the same topic (that is against forum rules). Just keep posting to the current thread (you have 10 mintues in which to edit, after which you will need to add a new reply to the thread).

Are you unable to see the images? on my view, i can see the images well

As well as blocking file downloads, my workplace security also blocks certain types of images (it looks like there is nothing there). So i apologize if there is an image there, I cannot see it. I believe I can see most of them that are posted with the tools in the link I provided.

 

[Fluff]

Cross posted https://www.excelforum.com/excel-pr...move-row-values-then-paste-to-data-table.html

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[Fluff]

Are you unable to see the images?

As those images are hosted on ExcelForum, I suspect that only members here, who are also members of that site will be able to see them.

 

[ifeelalone]

Hey everyone, did not meant to confuse anybody. To get it right, here's the figures.

On sheet 1, I populate the contents on row 2,

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X
1	PLANT	TYPE	SUB-TYPE	CODE	DESCRIPTION	DETAILS	JANUARY	FEBRUARY	MARCH	APRIL	MAY	JUNE	JULY	AUGUST	SEPTEMBER	OCTOBER	NOVEMBER	DECEMBER	2020	2021	2022	2023	GROUP	B/A
2	Fruit	Apple	Red	11000112233	Small	Snow White	10	10	10	10	10	10	10	10	10	10	10	10	11	12	13	14	Princess	B
Sheet1

Then when I run a certain macro, contents from row 2 and till the row with values will be deleted and will go to sheet 2, and will transform into a data table,

Book1
	A	B	C	D	E	F	G	H	I	J
1	PLANT	TYPE	SUB-TYPE	CODE	DESCRIPTION	DETAILS	MONTH	PROJECTION	GROUP	B/A
2	Fruit	Apple	Red	11000112233	Small	Snow White	JANUARY	0	Princess	B
3	Fruit	Apple	Red	11000112233	Small	Snow White	FEBRUARY	0	Princess	B
4	Fruit	Apple	Red	11000112233	Small	Snow White	MARCH	0	Princess	B
5	Fruit	Apple	Red	11000112233	Small	Snow White	APRIL	0	Princess	B
6	Fruit	Apple	Red	11000112233	Small	Snow White	MAY	0	Princess	B
7	Fruit	Apple	Red	11000112233	Small	Snow White	JUNE	0	Princess	B
8	Fruit	Apple	Red	11000112233	Small	Snow White	JULY	0	Princess	B
9	Fruit	Apple	Red	11000112233	Small	Snow White	AUGUST	0	Princess	B
10	Fruit	Apple	Red	11000112233	Small	Snow White	SEPTEMBER	0	Princess	B
11	Fruit	Apple	Red	11000112233	Small	Snow White	OCTOBER	0	Princess	B
12	Fruit	Apple	Red	11000112233	Small	Snow White	NOVEMBER	0	Princess	B
13	Fruit	Apple	Red	11000112233	Small	Snow White	DECEMBER	0	Princess	B
14	Fruit	Apple	Red	11000112233	Small	Snow White	0	2020	Princess	B
15	Fruit	Apple	Red	11000112233	Small	Snow White	0	2021	Princess	B
16	Fruit	Apple	Red	11000112233	Small	Snow White	0	2022	Princess	B
17	Fruit	Apple	Red	11000112233	Small	Snow White	0	2023	Princess	B
Sheet2

if I repeat the process on sheet 1: populate then run a macro, the contents of sheet 1 (starting from row 2 till the row with value) will be moved to the sheet 2 table. It will be then paste to the next available row.

Hope I cleared things out, my apologies if I confused someone and did not follow the rules. Hope you still help me. Thank you in advance!