If you want to be sure it saved instead of just a msgbox that is basically telling you the macro has ended, you can add an IF statement using the two lines he already gave you to do a simple verification check. Put this right above wbMaster.Close True IF wbMaster.Worksheets("Data".Cells(masterNextRow, 1).Value = wbLocal.Worksheets("Input").Range("F3"). Value And wbMaster.Worksheets("Data").Cells(masterNextRow, 2).Value = wbLocal.Worksheets("Input").Range("F5).Value Then MsgBox "Part Saved" Else MsgBox "Part not saved correctly" End IF
Great video - the one piece that I am looking for is how to assign a path name for a file on Onedrive that I want to update, not a local workbook. Is there more to it than just the correct path name? When I look at the file path for the Onedrive it shows me a link. Thanks in advance
Sir... Great video.... What about same work book and we only have sheets for form to data base.... Bot another workbook.... I am a beginner.... Thank you sir
How can I run this same code, but with the feature of keeping the vbMaster open while using the input source? I would like to see the data entry happen side by side and not have the master file automatically close each time an input is "saved". Thanks!
Thank You for the informative video. I would just like to know how we can transfer range of values. I tried inserting the range in the inverted commas, but it is taking only value of the 1'st mentioned cell. If anyone could please help me with it would be great help. Thanks Anyways :)
AB AN ERROR: thank you so much for your share and contribution us. i want to ask a question: normally this code run well but when i open another workbook i receive "RUN TIME ERROR NO 9", how can i fix this? (when i close the other workbook code starts well again) thanks a lot in advance!
Thanks. It's very useful. But can we have multiple copy of the input worksheet at clients side and data can be inputed at a time from multiple worksheets?
Sure, you can have all sorts of setups like this! VBA allows you to do a lot - if you're interested in learning how to do a lot more than I showed in this tutorial, you can look at my new VBA Course: www.teachexcel.com/vba-course-update.php?src=yt_comment_reply
Dear Sir, want to transfer data from one workbook to another workbook workbook -A 1. Receipt No. 2. Date 3. Name 4. Amount to Workbook - B in two different Sheets. can you please help me write correct VBA code.
Hi Travis, that is totally possible and I cover pieces of this puzzle in many of the tutorials I've made here on TH-cam (you can search for them on my channel) and also in my full VBA course: www.teachexcel.com/vba-course-update.php?src=yt_comment_reply_hgyMrkVWw-o
Hmm at about 11 minutes in, he added two lines of code that is responsible for clearing those entries... you could leave those two lines out, and it won't disappear.
i'm using ur command in VBA but its so weird that whatever I entered it will overwrite the 1st entry and always become a new entry. able to resolve? Thanks
Well it depends on a lot. I'd go over to our forum on www.teachexcel.com and upload the sample files you are working with and ask there - its much easier when the code and issue you are specifically mentioning is visible.
Is there a way that one can globally print all the codes ( Modules, Macros,....) in a an Excel file ( Workbook) to review, cross over,.... to be able to alter some without creating a catastrophe?
Well, probably copy/paste is the simplest way or copy/paste special values (Ctrl + C > Alt + E + S + V Enter) Otherwise, I'm not sure exactly what you mean by saving the data - if you can upload a sample file, you should ask in my forum and it will be much easier to help you. www.teachexcel.com/talk/microsoft-office?src=yt_comment
VBA/Macros Course (40% Discount): www.teachexcel.com/vba-course-update.php?src=youtube_pinned_comment_hgyMrkVWw-o
200+ Video Tutorials - 200+ Downloadable Excel Reference Files - 50+ Hours of Content
If you want to be sure it saved instead of just a msgbox that is basically telling you the macro has ended, you can add an IF statement using the two lines he already gave you to do a simple verification check. Put this right above wbMaster.Close True
IF wbMaster.Worksheets("Data".Cells(masterNextRow, 1).Value = wbLocal.Worksheets("Input").Range("F3"). Value And wbMaster.Worksheets("Data").Cells(masterNextRow, 2).Value = wbLocal.Worksheets("Input").Range("F5).Value Then
MsgBox "Part Saved"
Else
MsgBox "Part not saved correctly"
End IF
Very nice!!! :)
Exactly what I was looking for... Thank You!!!!
Great video - the one piece that I am looking for is how to assign a path name for a file on Onedrive that I want to update, not a local workbook. Is there more to it than just the correct path name? When I look at the file path for the Onedrive it shows me a link.
Thanks in advance
Sir... Great video.... What about same work book and we only have sheets for form to data base.... Bot another workbook.... I am a beginner.... Thank you sir
thank you, with little adjustment i'm able to finish my work
Fun one! I hacked out my own solution before watching the video. Picked up some good tips from your detailed lesson. Thanks for sharing. Thumbs up!!
Hi, may I know how I can save the data without opening the excel workbook using only the vba excel form.
How can I run this same code, but with the feature of keeping the vbMaster open while using the input source? I would like to see the data entry happen side by side and not have the master file automatically close each time an input is "saved". Thanks!
Thank You for the informative video.
I would just like to know how we can transfer range of values. I tried inserting the range in the inverted commas, but it is taking only value of the 1'st mentioned cell. If anyone could please help me with it would be great help.
Thanks Anyways :)
Very useful for me. Thanks
I have macro based excel sheet but how to share for multiple user entry. Please suggest.
Really Nice Simple Bit Of VBA Code Thumbs Up...Thank You Sir :)
AB AN ERROR: thank you so much for your share and contribution us. i want to ask a question: normally this code run well but when i open another workbook i receive "RUN TIME ERROR NO 9", how can i fix this? (when i close the other workbook code starts well again) thanks a lot in advance!
I need to do this but copy a full table over what changes do I need
Thanks a lot for this!!!
Thank you for sharing. But I found an error in the line of masterNextRow- subscript error.
Thanks. It's very useful. But can we have multiple copy of the input worksheet at clients side and data can be inputed at a time from multiple worksheets?
Sure, you can have all sorts of setups like this! VBA allows you to do a lot - if you're interested in learning how to do a lot more than I showed in this tutorial, you can look at my new VBA Course: www.teachexcel.com/vba-course-update.php?src=yt_comment_reply
I encountered error on masterNextRow it says subscript error
Dear Sir,
want to transfer data from one workbook to another workbook
workbook -A
1. Receipt No.
2. Date
3. Name
4. Amount
to Workbook - B in two different Sheets.
can you please help me write correct VBA code.
Hiii.. if my closed workbook stored in online how to mention the file path?
alright, what if I don't want to make duplicate entries but update an existing entry with additional/different information
Hi Travis, that is totally possible and I cover pieces of this puzzle in many of the tutorials I've made here on TH-cam (you can search for them on my channel) and also in my full VBA course: www.teachexcel.com/vba-course-update.php?src=yt_comment_reply_hgyMrkVWw-o
Is there a way to keep the values entered in the form instead of them disappearing when you hit save?
Hmm at about 11 minutes in, he added two lines of code that is responsible for clearing those entries... you could leave those two lines out, and it won't disappear.
I have application outside procedure error in each line
i'm using ur command in VBA but its so weird that whatever I entered it will overwrite the 1st entry and always become a new entry. able to resolve? Thanks
Well it depends on a lot. I'd go over to our forum on www.teachexcel.com and upload the sample files you are working with and ask there - its much easier when the code and issue you are specifically mentioning is visible.
Thank you so mutch
Why won’t my workbook file location work?
Sir what if I rename master workbook or chane location?
Shouldn't matter if its the Master workbook with the code in it.
Is there a way that one can globally print all the codes ( Modules, Macros,....) in a an Excel file ( Workbook) to review, cross over,.... to be able to alter some without creating a catastrophe?
How to save Data to another tab none vba pls
Well, probably copy/paste is the simplest way or copy/paste special values (Ctrl + C > Alt + E + S + V Enter) Otherwise, I'm not sure exactly what you mean by saving the data - if you can upload a sample file, you should ask in my forum and it will be much easier to help you. www.teachexcel.com/talk/microsoft-office?src=yt_comment