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

Excel Template to Format data from one worksheet to another

M

Mglines

New Member
I need to create a Template that will allow users to paste a certain report in worksheet 2 then in Worksheet 1 it populates just certain data from Worksheet 2.


Example the report has 30 columns of Data. We only want to look at 7 data points

I named worksheet 2 'Paste Data Here'

I used the function ='Paste Data Here'!A2 but when I tested the data didnt show up on Worksheet 1 like I wanted.
 
Hi,


Is the data one worksheet 1 consistently in the same structure. So is the data you want to see on Worksheet 2 always in the same place on worksheet 1?


If not then you cannot use the formula.


If there are other pieces of information on the two sheets that is the same then you can think of using VLOOKUP, SUMIF or other such lookup function
 
Thank you.


I used Vlookup. One issue that came up was if there was no data in that area it would come back #NA so I had to use

=IF('Paste Data Here'!D200="","",VLOOKUP('Formatted data'!D200,VLookup!A200:B296,2,FALSE))


This allows them to paste up to 200 rows of data and have it formated.
 
You must log in or register to reply here.
Back
Top