Inserting # of lines from one spreadsheet to another

G

Guest

I have a row that I have to copy from one spreadsheet in which the general
leders account is in a row. But I have to import this into a accounting
program. It requres the General Ledger account to be in a column on
separate rows. I have to import all the same data, such as Employee Id,
address, etc the only change being teh GL number in each column. This
requires me to copy 23 for every one row in the new spreadsheet. Then I
will use the vlookup to pull in the data I need. There is a row in the
orginal spreasheet for every check, which reslults in 23 rows in the new
spreadsheet. Is there a faster way than to cut and paste.
Hope this is clear?
 
A

Alan

Would it help if you copied all of your data in one go and then used
<Edit><Paste Special><Transpose> when you transfer the data?
 

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

Appending Data from one spreadsheet to another 4
How to sort entire spreadsheet by one column sort 5
How do I get rid of a blank row at bottom of Excel spreadsheet? 1
merging spreadsheet data 1
Inserting rows using a list of numbers 3
Easily extracting data from one spreadsheet to another 5
Linking 2 spreadsheet using data from the last row of spreadsheet 13
How do I insert a row between every line in my spreadsheet? 3

Top