How to copy information from sheet 2 into sheet1

R28G 6 Posts Thursday March 1, 2018Registration date March 8, 2018 Last seen - Mar 1, 2018 at 11:13 PM - Latest reply: ac3mark 9622 Posts Monday June 3, 2013Registration dateModeratorStatus June 22, 2018 Last seen
- Mar 8, 2018 at 08:28 AM
I have a spread sheet with two sheets.
The first contains names and i need to copy information from sheet 2 into sheet1.
in Sheet 1 F66 =Sheet2 A2
Sheet 1 F67=Sheet 2 A4
Sheet 1 F68 =Sheet 2 A6
etc
then other cells in sheet 1 with different patterns in sheet2.
Thanks in advance.
I am not a young member and used basic spreadsheets in the past but now need to do above for a project i am doing

Thanks for the Forum, my first Post
See more 

Your reply

9 replies

ac3mark 9622 Posts Monday June 3, 2013Registration dateModeratorStatus June 22, 2018 Last seen - Mar 2, 2018 at 02:59 PM
0
Thank you
Take a look at this article:
http://ccm.net/faq/54862-how-to-copy-data-from-one-excel-sheet-to-another-using-a-formula

It goes over moving data to another sheet after qualifying it!

R28G 6 Posts Thursday March 1, 2018Registration date March 8, 2018 Last seen - Mar 4, 2018 at 09:09 PM
Thanks for your patience.
i don't understand where or what i need to enter. I have not used code before and am struggling to make sense of it.
Can you simplify to something like:
to shit data from sh 1 A1 to sh 2 A3 enter this info "here'? hopefully if i have one entry i can work out what i need to do with the rest.
Thanks again
ac3mark 9622 Posts Monday June 3, 2013Registration dateModeratorStatus June 22, 2018 Last seen - Mar 5, 2018 at 04:45 PM
Findlastrow, accepts the variable for the worksheet that you want to place th edata onto. So if you wanted to find the last row of "sheet2", you would call:

FindLastRow("Sheet2")


Pass the sheet to the fnc.
R28G 6 Posts Thursday March 1, 2018Registration date March 8, 2018 Last seen - Mar 5, 2018 at 10:49 PM
Thanks will try that out hopefully will have success
Thanks again
R28G 6 Posts Thursday March 1, 2018Registration date March 8, 2018 Last seen - Mar 8, 2018 at 08:02 AM
Thanks ac3mark i have not had any success so i will abandoned it for now and get a book on how to write codes for excel.
Thanks again.
ac3mark 9622 Posts Monday June 3, 2013Registration dateModeratorStatus June 22, 2018 Last seen - Mar 8, 2018 at 08:28 AM
Get a Book on VBA. Visual Basic for Applications. It will cover the language that ALL MS products use, not just Excel. Your skills can then cascade into automating WORD documents, and Power Point Presentations as well.
Respond to ac3mark