Linking specific cell to specific spot

**davor123** · 08-27-2013, 03:09 AM

Hello! I am facing a problem :S
I have excell document which looks like:

predracun.jpg

Now, i would like to copy text to another document in pre-determined spots:

knjiga.JPG

I am wondering if there is a way to crate formula which will allow me to MARK and DRAG in second file.Instead of manually entering (copying) text from first file, that formula would allow me automatic filling cells by draging in second document (row 1 in fist document will fill page 1 in second, etc).

Thanks alot!

cross-post: http://www.mrexcel.com/forum/excel-q...ific-spot.html

**:) Sixthsense :)** · 08-27-2013, 03:12 AM

Nice Pics

But please attach a sample workbook with enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Note: Please don't attach documents containing confidential data like (address, telephone, ID#s, etc.).

**hemesh** · 08-27-2013, 03:13 AM

Hello davor123, can you please upload a sample book for better understanding with the results you want

**davor123** · 08-27-2013, 04:15 AM

I recieved data as shown in first spreadsheet (Document 1).

My goal is to import that data into pre-defined form (shown in Document 2). As you can see, the form covers one whole page for each fruit.

I would like to create a formula, which would allow me to mark and drag first page (so each fruit will get it's own page with data in right cells)

Hope i explained it well. Thanks!

Example.xlsx