This is brilliant and has helped me thank you. What code do i put in when im transferring content from merged cells into another sheet where cells are merged?
This is very helpful to me. I just want to ask if my NoCalled cell is a cell that has a vlookup formula, how do I copy/paste the values only my Log without including the formula? Looking forward to your response. Thank you.
Hi Chester really great video. I am trying to pull across data that are formula and have formats. I just want these to be values only tried to search but struggling
Very good tutorial. Is it possible to do the contrary? Suppose I have a table with data and I want to automatically transfer those data into the form fields?
Thank you good sire. I just have one question. Is there a way to retain the score? I have a formula included In my main worksheet and when I click on the submit macro, the scores are messed up
Perfect tutorial! Thank you! Set NoCalled = CTrk.Range("D8") - is it possible set a longer range? I mean if I need that the information would be transfered not just from the D8 but from D8:D10 ?
Thank you for the video...btw if i have a total with the sum formula on the cell...how do I move that to the other sheet as a number rather than the whole formula cell moving...i just get "REF!" in the second sheet...help on this will be appreciated. I have seen your video on paste special...but i dont know how to integrate it within this code.
Hi Chester, very useful video thank you. Is there a way to send data to specific sheets depending on what customer is selected on the master sheet for example?
Thank you!! Can you answer a few questions or send me to a video. In my row I have different choices and then 3 columns with different dates ex volunteer signed up for parking on fri, I appreciate your help.
How can this be used, where the copied cells, is inserted as values, so if it is a formula it copies, that it inserts the results, instead of the formula (will be blank when it arrives) :)
This Video tutorial was a godsend. I am only having trouble with one areas, the worksheet I pulled for the data includes a sum and it is not coming over as the sum.
So I utilized this form similar to yours to expense invoices, and then have an invoice log. Everything seems to work once going to my DestCell. Then when it does the offset, it goes to the bottom on my Log where I then have totals. If I enter a 3rd invoice it then replaces the 2nd invoice entered at the bottom of the Log. In other words, it doesn't seem to just go to the next row as seen in the video. Any suggestions? Here is a copy of that section: 'Create a variable for the paste cell in the Invoice Entry worksheet Dim DestCell As Range If InvTrk.Range("A6") = "" Then 'If A6 is empty Set DestCell = InvTrk.Range("A6") '...then destination cell is A6 Else Set DestCell = InvTrk.Range("a6").End(xlDown).Offset(1, 0) '...otherwise the next empty row End If 'If no "InvDate has been entered, exit macro If InvDate = "" Then MsgBox "You must enter a Date before adding to the log" Exit Sub End If 'Copy and paste data from the Invoice Entry worksheet to the Invoice Tracking worksheet InvDate.Copy DestCell InvNo.Copy DestCell.Offset(0, 1) CoName.Copy DestCell.Offset(0, 2) RuckUp.Copy DestCell.Offset(0, 3) Mkt.Copy DestCell.Offset(0, 4)
Great video first of all but I have a question, I have table with multiple entries but only 1 cell with the transfer ID how could i make it so that when I click on the button the transfer ID on cell A1 auto fill with hoe ever many entries there are on the table on column A while everything else goes on column B,C&D while the transfer ID goes on column A example ID Item Country QTY 12345 Apples Canada 13 12345 oranges Canada 50 12345 Grapes Canada 16
This is brilliant and has helped me thank you. What code do i put in when im transferring content from merged cells into another sheet where cells are merged?
Thank you so much for taking the time to produce and upload these excellent tutorials... I really could have used your services back in the day
This is very helpful to me. I just want to ask if my NoCalled cell is a cell that has a vlookup formula, how do I copy/paste the values only my Log without including the formula? Looking forward to your response. Thank you.
Hi Chester really great video. I am trying to pull across data that are formula and have formats. I just want these to be values only tried to search but struggling
thanks for sharing the code, I found it really useful since I am trying to get more experience, coding in vba.
Very good tutorial.
Is it possible to do the contrary? Suppose I have a table with data and I want to automatically transfer those data into the form fields?
Thank you good sire. I just have one question. Is there a way to retain the score? I have a formula included In my main worksheet and when I click on the submit macro, the scores are messed up
Perfect tutorial! Thank you!
Set NoCalled = CTrk.Range("D8") - is it possible set a longer range? I mean if I need that the information would be transfered not just from the D8 but from D8:D10 ?
Thank you for the video...btw if i have a total with the sum formula on the cell...how do I move that to the other sheet as a number rather than the whole formula cell moving...i just get "REF!" in the second sheet...help on this will be appreciated. I have seen your video on paste special...but i dont know how to integrate it within this code.
I am looking for help on this as well
Hi Chester, very useful video thank you. Is there a way to send data to specific sheets depending on what customer is selected on the master sheet for example?
Thank you!! Can you answer a few questions or send me to a video. In my row I have different choices and then 3 columns with different dates ex volunteer signed up for parking on fri, I appreciate your help.
How can this be used, where the copied cells, is inserted as values, so if it is a formula it copies, that it inserts the results, instead of the formula (will be blank when it arrives) :)
Thank you for the macro Chester. You do a great job!!!
Thank you for the macro Chester
Super, it is working
Thank You Sir
Thank you a lot, very, very useful! :-)
This Video tutorial was a godsend. I am only having trouble with one areas, the worksheet I pulled for the data includes a sum and it is not coming over as the sum.
Awesome video, thank you! Does anyone know how to do exactly this, but copy over only the values generated from a formula? Thanks!
So I utilized this form similar to yours to expense invoices, and then have an invoice log. Everything seems to work once going to my DestCell. Then when it does the offset, it goes to the bottom on my Log where I then have totals. If I enter a 3rd invoice it then replaces the 2nd invoice entered at the bottom of the Log. In other words, it doesn't seem to just go to the next row as seen in the video. Any suggestions?
Here is a copy of that section:
'Create a variable for the paste cell in the Invoice Entry worksheet
Dim DestCell As Range
If InvTrk.Range("A6") = "" Then 'If A6 is empty
Set DestCell = InvTrk.Range("A6") '...then destination cell is A6
Else
Set DestCell = InvTrk.Range("a6").End(xlDown).Offset(1, 0) '...otherwise the next empty row
End If
'If no "InvDate has been entered, exit macro
If InvDate = "" Then
MsgBox "You must enter a Date before adding to the log"
Exit Sub
End If
'Copy and paste data from the Invoice Entry worksheet to the Invoice Tracking worksheet
InvDate.Copy DestCell
InvNo.Copy DestCell.Offset(0, 1)
CoName.Copy DestCell.Offset(0, 2)
RuckUp.Copy DestCell.Offset(0, 3)
Mkt.Copy DestCell.Offset(0, 4)
Great video first of all but I have a question, I have table with multiple entries but only 1 cell with the transfer ID how could i make it so that when I click on the button the transfer ID on cell A1 auto fill with hoe ever many entries there are on the table on column A while everything else goes on column B,C&D while the transfer ID goes on column A
example
ID Item Country QTY
12345 Apples Canada 13
12345 oranges Canada 50
12345 Grapes Canada 16
👍👍👍👍👍