LinkBack URL
About LinkBacks
I will need a Macro that will Copy and Paste Information from Sheet 2 to Sheet 1. I will need it to basically Copy SKU- Find SKU on Sheet 1 and copy Inventory to Sheet 1.
I have attached a Spreadsheet as an example.
Any help is greatly appreciated!
I will need a Macro that will Copy and Paste Information from Sheet 2 to Sheet 1. I will need it to basically Copy SKU- Find SKU on Sheet 1 and copy Inventory to Sheet 1.
I have attached a Spreadsheet as an example.
Any help is greatly appreciated!
Last edited by Fredbugatti; 05-15-2014 at 12:07 AM.
Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)
To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thanks, Sorry I am new to this Forum. I will definitely make it more descriptive
Sent from my iPhone using Tapatalk
Waiting for title change
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Column K in Sheet 2 would be the column we will need to copy and paste to column C in Sheet 1 Based on the SKU
You will not receive any suggestions until you change your thread title, sorry
I have just changed the Thread Title. Please check and confirm if ok
Sent from my iPhone using Tapatalk
Thanks for changing the thread title as per mod request
A simple Vlookup will do that work for you...
In C2 Cell of Sheet1
=IFERROR(VLOOKUP(A2,Sheet2!A:K,11,FALSE),"-")
Drag it down...
Great, How would I change the format of the numbers so it would not show the formula in C2 Cell ?
If you don't want the formula to stay in those cells then just select the range and copy paste it as values using Paste Special option.
But keep in mind that any change in source sheet (sheet2) will get reflected immediately in sheet1 when the formula resides in those cells.
Once you copy pasted the formula arrived result as values then there is no connectivity between those base cells.
Got it!
Is there any way to create a button for this specific spreadsheet to press using the code you gave me to simplify it ?
How to install your new code
- Copy the Excel VBA code
- Select the workbook in which you want to store the Excel VBA code
- Press Alt+F11 to open the Visual Basic Editor
- Choose Insert > Module
- Edit > Paste the macro into the module that appeared
- Close the VBEditor
- Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)
Refer the attached file for details
Please Login or Register to view this content.
Thanks so much! I appreciate your help!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks