would you able to help me to count different numbers that matches at least few digit
@BarbHendersonconsultingКүн бұрын
You would not be able to select the number buy you could put in *34*
@arnaudvandecalseyde57232 күн бұрын
I make labels every year to send out wishes to my clients. Every time I come back to this video 😂 Thanks for the help
@BarbHendersonconsulting2 күн бұрын
Love that!
@royaldj51185 күн бұрын
How do I get it to automatically clear and scan barcode for another item? How do I use it in User Form excel?
@BarbHendersonconsulting3 күн бұрын
Worksheets("Sheet1").Cells(2, 2) = ""
@thibiyar50685 күн бұрын
Thank you so much !!! At last found a solution for my question. Helped me a alot
@BarbHendersonconsulting4 күн бұрын
Glad it helped!
@usmanmohamed10866 күн бұрын
can I get a solution to my problem
@BarbHendersonconsulting4 күн бұрын
Try the steps again!
@usmanmohamed10866 күн бұрын
thank you madam, but in the last position is not receiving in from excel ,its opening blank word file ,, please suggest me , it s most helpful
@BarbHendersonconsulting4 күн бұрын
redo the steps
@thiagovieira31028 күн бұрын
Hi @barbHendersonconsulting thanks for this it’s Amazing. Just a quick question: I need to duplicate the attendance record in the columns f to forward. I did a new sub in the same macro, changing the parameters (lines and columns numbers/letters) but this part comes out always as a erro: fstrow = rng.Row rownumber = Activesheet.Range("a:a").Find(what:=barcode, after:=ActiveSheet.Cells(fstrow, 1), _ searchdirection:=xlPrevious).Row May you have some idea in how to proceed?
@BarbHendersonconsulting7 күн бұрын
I do not know, having something in "F" should not cause problems?
@Br7h_k8c8 күн бұрын
You have helped me so much , thankyou 🙏
@BarbHendersonconsulting8 күн бұрын
Glad I could help!
@cristinamarin11368 күн бұрын
Thank you
@BarbHendersonconsulting8 күн бұрын
You're welcome
@naveenkumar-wl7vd9 күн бұрын
Madam/sir pls how to apply the formula for Full data.pls give me
for some reason mine isn't showing the grid lines?? the page is blank
@BarbHendersonconsulting9 күн бұрын
go over the steps again, you must have missed something
@terryraines99528 күн бұрын
@@BarbHendersonconsulting found it, show grid, but how would I only select certain address ?
@willharalson429910 күн бұрын
Thank you! Very helpful
@BarbHendersonconsulting10 күн бұрын
Glad it was helpful!
@LFXMEDIA11 күн бұрын
I know it’s 8 years later but thanks for making it simple and to the point lol
@BarbHendersonconsulting11 күн бұрын
glad you liked it
@timwhite268011 күн бұрын
Why would I use this over a pivot table?
@BarbHendersonconsulting11 күн бұрын
I am giving you options!
@abassmariam300812 күн бұрын
❤good
@BarbHendersonconsulting11 күн бұрын
Glad you like it
@inioluwatonade239012 күн бұрын
Thanks so much. This video was really helpful
@BarbHendersonconsulting12 күн бұрын
You're welcome!
@jorgefoyld853813 күн бұрын
God bless you, Barb!
@BarbHendersonconsulting13 күн бұрын
you welcome!
@nikkilawson483413 күн бұрын
I watch this every year when I do my Christmas cards. Thank you so much!
@BarbHendersonconsulting13 күн бұрын
You are so welcome!
@MechE11B13 күн бұрын
Thank you so much..!
@BarbHendersonconsulting13 күн бұрын
You're welcome!
@HarveySpector-w1g14 күн бұрын
you need to retire ngl
@BarbHendersonconsulting13 күн бұрын
ok
@darkjaed14 күн бұрын
BARB. THANK YOU GIRL
@BarbHendersonconsulting13 күн бұрын
welcome
@atharvaalok226814 күн бұрын
Miss Henderson thank you very much for making this tutorial, this really helped me prepare for my practical tomorrow
@BarbHendersonconsulting14 күн бұрын
Glad it was helpful!
@villagewickets15 күн бұрын
Thnx
@BarbHendersonconsulting14 күн бұрын
Welcome
@johndeer105015 күн бұрын
This was way quicker than another way of doing this! Awesome thank you!
@BarbHendersonconsulting15 күн бұрын
Glad you found it useful!
@rajeshmajumdar499915 күн бұрын
Wonderful work! Thank you for sharing this video. I'll add functionality to search employees by SSO, as I manage over 1,000 employees. Thanks again, Barb!
@BarbHendersonconsulting15 күн бұрын
You are very welcome, Barb!
@sunilpanikar12299 күн бұрын
Hi Rajesh, did it work. was it useful for you ?
@MilindaWickramasingheMustang16 күн бұрын
No fuzz.. just business.. clear instructions and true information.. Thank you so much ❤
@BarbHendersonconsulting15 күн бұрын
You're welcome! 😊
@shubhamrathore370316 күн бұрын
Yes I need help I have a data like this 👇 Arun 49/100 Arun 10/4030 Arun 39/29 Bala 29/29 Bala 20/10 Rahul 10/29 Rahul 34/59 I want to convert this into this 👇 completely by formula, bcz I so many values like that Arun. 29/100, 10/4030, 39/29 Bala 29/29, 20/10 Rahul 10/29, 34/59
@BarbHendersonconsulting16 күн бұрын
=SUBSTITUTE(IF(D3=D2, E2&" "&E3,"")," ",",")
@shubhamrathore370315 күн бұрын
Thank you very much . My half of the work has been done. But I am unable to apply the formula correctly. Pls come with a video.
@Fifiiiii89516 күн бұрын
This is perfect omgggg thank you so much
@BarbHendersonconsulting16 күн бұрын
Happy to help
@AlanSchmelzleKellyEdmondson18 күн бұрын
I think I've told you before, but I only print labels once a year (for Christmas cards). I have a Post-It note on my Avery label package directing me to this video. I do a split screen of your video and my Word document and follow along. Bingo! Bango! Boingo! And I'm all done! So easy! THANK YOU
@BarbHendersonconsulting17 күн бұрын
Thanks for sharing!!
@fayazaiman786719 күн бұрын
Thank you so much
@BarbHendersonconsulting18 күн бұрын
You are very welcome!
@King_Raj119 күн бұрын
Very very thanks ❤
@BarbHendersonconsulting19 күн бұрын
Welcome 😊
@YouCantSeeMEorCanYou20 күн бұрын
I have been searching for something so similar. I wasnt looking for a weekly schedule because I send a daily shift out and rotate people roles for the day. I think this is the most useful video i have found. Thank you for the video.
@BarbHendersonconsulting20 күн бұрын
You are so welcome!
@TAKN-kh9ws20 күн бұрын
классно 🤝
@BarbHendersonconsulting20 күн бұрын
Спасибо
@naomijansenvanvuuren211922 күн бұрын
I want to understand how the % is calculated
@BarbHendersonconsulting22 күн бұрын
the actual days divided by the projected days
@alphaprinters976522 күн бұрын
Nice one. Direct and to the point. And this is the easiest method i've seen so far...by the way
@BarbHendersonconsulting22 күн бұрын
You're welcome. Glad you found it useful!
@lavendano492123 күн бұрын
Thank you I have bee trying to delete some macros and just couldn't. Thank you for sharing this :)
@BarbHendersonconsulting23 күн бұрын
Your welcome, Only people who have had that problem appreciate this
@kermets24 күн бұрын
How do I not include part of the sheet ?
@BarbHendersonconsulting24 күн бұрын
select the range of the sheet that you want to sort
@muthu339625 күн бұрын
Hi, my body of the email will look like the below, I want current user signature to be added at the end of the mail. “Dear ABC, Thanks for the update. Please action the below items. *Excel Table* Please free to reach out to us. After this I want my signature
@BarbHendersonconsulting25 күн бұрын
I think what you need to use is a template as sown in this video kzbin.info/www/bejne/f5Oreohon96ebLM
@muthu339626 күн бұрын
Hi, I'm always getting this error "Application-defined or object -defined error" on below line Set pageEditor = xInspect.WordEditor
@BarbHendersonconsulting25 күн бұрын
On the visual basic window Tools - References - OLE Automation and Microsoft Office 6.0 Object Library must be checked
@muthu339625 күн бұрын
Yes selected that, I have microsoft office 16.0 but still facing same error..It works fine sometimes and not working sometimes
@BarbHendersonconsulting24 күн бұрын
@@muthu3396 That is unusual. I do not know what is happening now!
@muthu339624 күн бұрын
Even I’m wondering that..If Icompletely close all the files and restart my system and try running it’s working but after switching to some other files and try to run im getting run time error
@RAKESHYADAV-tw1bf26 күн бұрын
Thank you 🎉🎉🎉good formula
@BarbHendersonconsulting25 күн бұрын
You're so welcome!
@thatkannadagirl2526 күн бұрын
Thank you, I was looking for this exact thing!
@BarbHendersonconsulting26 күн бұрын
Glad I could help!
@madaranagahawatte472527 күн бұрын
Thanks for this :)
@BarbHendersonconsulting27 күн бұрын
you are so welcome!
@garylillich28 күн бұрын
Want to consolidate monthly bank ledgers into one file, which shows ALL transactions. Is this the best approach??
@BarbHendersonconsulting27 күн бұрын
I think that would work!
@dwightcimino104028 күн бұрын
Thank you . . . you are the only one I found on the internet that either knew what they were doing . . . or were at least able to put it in operational form . . . that worked for me. God bless you.
@BarbHendersonconsulting28 күн бұрын
Glad I could help
@tabithahamby469329 күн бұрын
You just changed my life 😂✨
@BarbHendersonconsulting29 күн бұрын
happy to help!
@pravindilpake929429 күн бұрын
This video is still useful in 27/11/2024. thank you so much😊