• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Getting data from Sheet1 to sheet2

S

Shabbo

Member
Dear Sir,

Can you please help me to get data from sheet1 to sheet2, using formula, in sheet1 I have multiple columns and sheet2 I have some columns which are required for daily work, instead of copying and pasting of data if I use formula, it will avoid errors.

Please help.
 

Attachments

  • Book10.xlsx
    11.8 KB · Views: 2
AliGW said:
If you have 2024 or 365, in A4 followed by ENTER:

=CHOOSECOLS(Sheet1!A2:K30,1,2,3,7,8,9)
Click to expand...
Dear Sir,

Thanks for your reply, but its not working properly, its not giving result as per number's what we have given, also it will be better if it will work on the basis of headings.
 

Attachments

  • Book10.xlsx
    13.9 KB · Views: 2
Do I really look like a Sir??? :confused:

You entered the formula incorrectly.

Remove ALL sample data from A2 onwards, then in A2 followed by ENTER (NOT CTRL+SHIFT+ENTER):

=CHOOSECOLS(Sheet1!A2:K30,1,2,3,7,8,9)

Do NOT copy down - the formula will spill by itself.

it will be better if it will work on the basis of headings.
Click to expand...
No need.
 

Attachments

  • Shabbo Book10(6) SPILL 365 AliGW.xlsx
    13.8 KB · Views: 1
AliGW said:
Do I really look like a Sir??? :confused:

You entered the formula incorrectly.

Remove ALL sample data from A2 onwards, then in A2 followed by ENTER (NOT CTRL+SHIFT+ENTER):

=CHOOSECOLS(Sheet1!A2:K30,1,2,3,7,8,9)

Do NOT copy down - the formula will spill by itself.


No need.
Click to expand...
Dear mam,

It worked thanks but if I change heading below data not getting changed, can you please help me with formula connected with header.
 
Why did you not provide more realistic sample data at the outset?

If you provide a realistic layout, then I shall see what I can do. I am not gpoing to guess.
 
By the way - you have two Diff columns. All columns would need distinct names for anything to work.

I am waiting for an updated sample workbook that properly reflects your real data layout.

In the meantime, if headings are unique and match across workseets, then you could use this:

=DROP(REDUCE("",A1:F1,LAMBDA(x,y,HSTACK(x,FILTER(Sheet1!A2:K30,Sheet1!A1:K1=y)))),,1)
 
You must log in or register to reply here.
Back
Top