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
@harilibo
Жыл бұрын
thanks for sharing the code, I found it really useful since I am trying to get more experience, coding in vba.
@IvanCortinas_ES
3 жыл бұрын
Thank you for the macro Chester. You do a great job!!!
@SuperHanme
3 жыл бұрын
Thank you for the macro Chester
@johandaugaarddrejer9009
2 жыл бұрын
Thank you a lot, very, very useful! :-)
@ramkrishnarao1212
2 жыл бұрын
Super, it is working
@keanujeeves-kinsella7516
10 ай бұрын
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?
@michellegygax6527
3 жыл бұрын
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.
@seanain1
2 жыл бұрын
Thank You Sir
@jasonshirtcliffe9057
Жыл бұрын
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
@sebjanavlashi5524
2 жыл бұрын
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?
@juddyuk
2 жыл бұрын
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?
@sandychilders9509
2 жыл бұрын
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.
@greenmotiv4544
Жыл бұрын
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.
@aka7minimouse
3 жыл бұрын
Awesome video, thank you! Does anyone know how to do exactly this, but copy over only the values generated from a formula? Thanks!
@simaserslavas2897
2 жыл бұрын
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 ?
@reginaldpetalcorin2049
3 жыл бұрын
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
@SaadKhan-mf9mg
3 жыл бұрын
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.
@aka7minimouse
3 жыл бұрын
I am looking for help on this as well
@johandaugaarddrejer9009
Жыл бұрын
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) :)
@sorasenpie6832
2 жыл бұрын
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
@redhaakhund1271
3 жыл бұрын
👍👍👍👍👍
@vdcbootcamp5903
2 жыл бұрын
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)
Пікірлер: 23