Hi Shirley, There is certainly no need for you to type things out again and you can deal with the issue in a number of ways. Are you aware of the fact that you can have more than one spread sheet in each workbook? If not, this might be a really good way of gathering all the data for one year into a single file. Essentially you can have any number of spread sheets in a workbook though the default is normally 3 I think. You could , therefore, have a sheet for your income, a sheet for your expenditure and then a separate sheet for each of the monthly VAT returns. You can then get clever and summarise the monthly data on a summary sheet and have this updated automatically. Alternatively, you can select and then copy and paste data from one spread sheet into another sheet, either in the same workbook or in another workbook altogether. If you do this, you need to be very careful where you paste the incoming data as it will overwrite data in the receiving cells if you paste in the wrong place. It's a bit too much to describe the above on list but, if it would be helpful, please contact me off list and I'll try to help. My email address is : Jamie.cuthbertson@xxxxxxxxxxxx Regards, Jamie From: jaws-uk-bounce@xxxxxxxxxxxxx [mailto:jaws-uk-bounce@xxxxxxxxxxxxx] On Behalf Of shirley clow Sent: 22 November 2011 14:41 To: jaws-uk@xxxxxxxxxxxxx Subject: [jaws-uk] Re: Help with XL. Hello Jamie, Thank you for responding to my question. I will explain further what I want to do. I have a small business, my accountant likes to have all my purchases and sales listed on one spread sheet. Each 3 months I do my VAT return on a separate spreadsheet. What I would like to do is to put all of the details from each VAT spreadsheet into one!... this will save me a great deal of time, having to type out everything again. I hope that makes things a little clearer. Kind regards, Shirley. ----- Original Message ----- From: "Jamie Cuthbertson" <jamie.cuthbertson@xxxxxxxxxxxx> To: <jaws-uk@xxxxxxxxxxxxx> Sent: Tuesday, November 22, 2011 9:56 AM Subject: [jaws-uk] Re: Help with XL. > Hi Shirley, > > > From your question, I'm not entirely sure what you are hoping to do. > Merging things in Excel is a specific action where a number of cells are > merged into a single cell. If there is data in the cells at the time of > the > merge, you are likely to lose data from some of the cells. > > > > It sounds more like you are meaning copying and pasting information from > one > sheet to another but, before being able to properly answer your question, > I'd need to get more specific information on exactly what you want to > achieve. > > > > Cheers for now, > > > > Jamie > > > > > > From: jaws-uk-bounce@xxxxxxxxxxxxx [mailto:jaws-uk-bounce@xxxxxxxxxxxxx] > On > Behalf Of shirley clow > Sent: 20 November 2011 19:29 > To: jaws-uk@xxxxxxxxxxxxx > Subject: [jaws-uk] Help with XL. > > > > Hi, > can anyone tell me if I can merge 2 XL spreadsheets by copying and > pasting. > > If so, could you tell me how it's done. > > Many thanks, > > Shirley. > ** To leave the list, click on the immediately-following link:- > ** [mailto:jaws-uk-request@xxxxxxxxxxxxx?subject=unsubscribe] > ** If this link doesn't work then send a message to: > ** jaws-uk-request@xxxxxxxxxxxxx > ** and in the Subject line type > ** unsubscribe > ** For other list commands such as vacation mode, click on the > ** immediately-following link:- > ** [mailto:jaws-uk-request@xxxxxxxxxxxxx?subject=faq] > ** or send a message, to > ** jaws-uk-request@xxxxxxxxxxxxx with the Subject:- faq > > > > __________ Information from ESET Smart Security, version of virus > signature > database 6647 (20111121) __________ > > The message was checked by ESET Smart Security. > > http://www.eset.com > > > __________ Information from ESET Smart Security, version of virus > signature > database 6649 (20111121) __________ > > The message was checked by ESET Smart Security. > > http://www.eset.com > > > > ** To leave the list, click on the immediately-following link:- > ** [mailto:jaws-uk-request@xxxxxxxxxxxxx?subject=unsubscribe] > ** If this link doesn't work then send a message to: > ** jaws-uk-request@xxxxxxxxxxxxx > ** and in the Subject line type > ** unsubscribe > ** For other list commands such as vacation mode, click on the > ** immediately-following link:- > ** [mailto:jaws-uk-request@xxxxxxxxxxxxx?subject=faq] > ** or send a message, to > ** jaws-uk-request@xxxxxxxxxxxxx with the Subject:- faq > ---------------------------------------------------------------------------- ---- No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.920 / Virus Database: 271.1.1/4032 - Release Date: 11/22/11 07:55:00 ** To leave the list, click on the immediately-following link:- ** [mailto:jaws-uk-request@xxxxxxxxxxxxx?subject=unsubscribe] ** If this link doesn't work then send a message to: ** jaws-uk-request@xxxxxxxxxxxxx ** and in the Subject line type ** unsubscribe ** For other list commands such as vacation mode, click on the ** immediately-following link:- ** [mailto:jaws-uk-request@xxxxxxxxxxxxx?subject=faq] ** or send a message, to ** jaws-uk-request@xxxxxxxxxxxxx with the Subject:- faq __________ Information from ESET Smart Security, version of virus signature database 6654 (20111123) __________ The message was checked by ESET Smart Security. http://www.eset.com ** To leave the list, click on the immediately-following link:- ** [mailto:jaws-uk-request@xxxxxxxxxxxxx?subject=unsubscribe] ** If this link doesn't work then send a message to: ** jaws-uk-request@xxxxxxxxxxxxx ** and in the Subject line type ** unsubscribe ** For other list commands such as vacation mode, click on the ** immediately-following link:- ** [mailto:jaws-uk-request@xxxxxxxxxxxxx?subject=faq] ** or send a message, to ** jaws-uk-request@xxxxxxxxxxxxx with the Subject:- faq