Impoting data from Sheet 1 to Sheet 2

G

Guest

Hi,

I am being asked to create an spreadsheet where:

*Sheet 1 has data that someone will update and add to daily
*Sheet 2 has data only from a specific range of columns from sheet 1 that
updates real time based on what you are adding or changing on sheet 1.

Example: Sheet 1 has information in columns A to M but sheet 2 only needs
information from columns C and G-K. However, they want the data from sheet 1,
columns C and G-K to update automatically to sheet 2 based on the updates
they do on sheet 1. Does that make sense or did I make it more confusing? :)

Is this possible? If so, how do I do that?

Thank you so much in advance!

a-leano
 
G

Gord Dibben

Copy the columns needed then Edit>Paste Special>Paste Links from Sheet1 to
Sheet2.


Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Replace data from sheet 2 into sheet 1 1
pulling from one sheet to another 3
moving answer from one sheet to another 1
How do I automatically get information from sheet 1 into sheet 2 7
Excel A CountIF question... I think 2
Import from sheet 1 to sheet 2 18
Autofill a row from sheet 1 to a column on sheet 2 1
Remove duplicates from Sheet 2 3

Top