How to Copy Rows from sheet1 to sheet2

**seaottersut** · 03-14-2013, 01:38 PM

Hey there, im trying to figure out the formula to automatically copy a full row on sheet1 to sheet2

i found some formulas but they aren't working for me...

for example:

excelexample1.png

Input formula (or macro) and it will get put into the following highlighted area.

excelexample2.png

OR

Does anyone know of a way to create a form on Word or adobe, that can be filled via .csv or any other type from excel?

**arlu1201** · 03-14-2013, 02:39 PM

How would a png help us? Post a sample workbook.

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

**seaottersut** · 03-14-2013, 03:21 PM

test1formula.xlsx

sorry about that

**newdoverman** · 03-14-2013, 03:22 PM

Select on sheet2 cells A3:D3 and enter the formula =SHEET1!A3:D3 then complete by Ctrl+Shift+Enter. (array formula)

**seaottersut** · 03-14-2013, 03:38 PM

okay great!

now one more question. is there any formula to use an excel spreadsheet to autofill a custom form?

for example, you have a whole table of information on excel.

we want to implement some way to use the whole row of information to autofill a PDF form.

any thoughts?

**newdoverman** · 03-14-2013, 04:04 PM

If this is a true PDF created in Acrobat, you will have to know what the fields are called (if they are actually fields and not just blank spaces).

If you can re-create the form in Excel you can use VBA code to take the table data and enter it in the correct fields. If the form can be used in Word format and fields entered that match your column headers in Excel then a "Mail Merge" can be done to fill in the fields. The filled form can then be saved as a PDF.

There are too many variables to give a definitive answer to your question so, I hope that the above gives you some ideas on how to solve your problem.