LinkBack URL
About LinkBacks
hello...
i wanna ask how 2 transfer a value from 1 sheet 2 another sheet at the same workbook? really need help coz im new in this excel programming n i dont know what to do and still study about this programming
hello...
i wanna ask how 2 transfer a value from 1 sheet 2 another sheet at the same workbook? really need help coz im new in this excel programming n i dont know what to do and still study about this programming
Assuming you were sending a value from Cell A1 on Sheet 1 to Cell A1 on Sheet2, here are a few:
or (this one transfers formulas as well)
Please Login or Register to view this content.
orPlease Login or Register to view this content.
Please Login or Register to view this content.
Perhaps it was the Noid who should have avoided me...
If you are satisfied with my solution click the small star icon on the left. Thanks
1. Make a copy of your workbook and run the following code on your copy (just in case)
2. With excel open, press ALT+F11 to open the Visual Basic Editor (VBE). From the "Insert" menu, select "Module".
3. Paste the code from above into the empty white space. Close the VBE.
4. From the developer tab, choose "Macros", select the Sub Name, and click "Run".
Amalia,
Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
You don't really need code for this.
If you want to use code do it any of the ways AlvaroSiza said they will all work but if you wanted to you could
just add this to say Cell A1 in sheet 3
=Sheet2!A1
you will copy across what ever is in A1 of Sheet 2.
This will copy a Row of data
Please Login or Register to view this content.
Irish RayRay,
Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore Moderators' or Administrators' requests - note that this includes requests by senior members as well, if you are unclear about their request or instruction then send a private message to them asking for help. Do not post a reply to a thread where a moderator has requested an action that has not been complied with e.g Title change or Code tags...etc
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks