How to copy information from sheet 2 into sheet1 [Closed]

Report
Posts
6
Registration date
Thursday March 1, 2018
Status
Member
Last seen
March 8, 2018
-
 Blocked Profile -
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

1 reply


Take a look at this article:
https://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!

Posts
6
Registration date
Thursday March 1, 2018
Status
Member
Last seen
March 8, 2018

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
Blocked Profile
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.
Posts
6
Registration date
Thursday March 1, 2018
Status
Member
Last seen
March 8, 2018

Thanks will try that out hopefully will have success
Thanks again
Posts
6
Registration date
Thursday March 1, 2018
Status
Member
Last seen
March 8, 2018

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.
Blocked Profile
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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!