Track employee leave in Excel
7:56
14 күн бұрын
Just display the numbers in Excel
5:07
Select and copy PDF to Excel
3:03
Пікірлер
@Edward20100
@Edward20100 2 күн бұрын
Thanks ❤
@BarbHendersonconsulting
@BarbHendersonconsulting 2 күн бұрын
You're welcome 😊
@RinkySaha-f9q
@RinkySaha-f9q 2 күн бұрын
would you able to help me to count different numbers that matches at least few digit
@BarbHendersonconsulting
@BarbHendersonconsulting Күн бұрын
You would not be able to select the number buy you could put in *34*
@arnaudvandecalseyde5723
@arnaudvandecalseyde5723 2 күн бұрын
I make labels every year to send out wishes to my clients. Every time I come back to this video 😂 Thanks for the help
@BarbHendersonconsulting
@BarbHendersonconsulting 2 күн бұрын
Love that!
@royaldj5118
@royaldj5118 5 күн бұрын
How do I get it to automatically clear and scan barcode for another item? How do I use it in User Form excel?
@BarbHendersonconsulting
@BarbHendersonconsulting 3 күн бұрын
Worksheets("Sheet1").Cells(2, 2) = ""
@thibiyar5068
@thibiyar5068 5 күн бұрын
Thank you so much !!! At last found a solution for my question. Helped me a alot
@BarbHendersonconsulting
@BarbHendersonconsulting 4 күн бұрын
Glad it helped!
@usmanmohamed1086
@usmanmohamed1086 6 күн бұрын
can I get a solution to my problem
@BarbHendersonconsulting
@BarbHendersonconsulting 4 күн бұрын
Try the steps again!
@usmanmohamed1086
@usmanmohamed1086 6 күн бұрын
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
@BarbHendersonconsulting
@BarbHendersonconsulting 4 күн бұрын
redo the steps
@thiagovieira3102
@thiagovieira3102 8 күн бұрын
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?
@BarbHendersonconsulting
@BarbHendersonconsulting 7 күн бұрын
I do not know, having something in "F" should not cause problems?
@Br7h_k8c
@Br7h_k8c 8 күн бұрын
You have helped me so much , thankyou 🙏
@BarbHendersonconsulting
@BarbHendersonconsulting 8 күн бұрын
Glad I could help!
@cristinamarin1136
@cristinamarin1136 8 күн бұрын
Thank you
@BarbHendersonconsulting
@BarbHendersonconsulting 8 күн бұрын
You're welcome
@naveenkumar-wl7vd
@naveenkumar-wl7vd 9 күн бұрын
Madam/sir pls how to apply the formula for Full data.pls give me
@BarbHendersonconsulting
@BarbHendersonconsulting 8 күн бұрын
docs.google.com/spreadsheets/d/1CUY2eW3p5Isu_npp0Zw0s92ib3ipKqxg/copy
@ps67ps
@ps67ps 9 күн бұрын
Thank you!
@BarbHendersonconsulting
@BarbHendersonconsulting 9 күн бұрын
Welcome!
@terryraines9952
@terryraines9952 10 күн бұрын
for some reason mine isn't showing the grid lines?? the page is blank
@BarbHendersonconsulting
@BarbHendersonconsulting 9 күн бұрын
go over the steps again, you must have missed something
@terryraines9952
@terryraines9952 8 күн бұрын
@@BarbHendersonconsulting found it, show grid, but how would I only select certain address ?
@willharalson4299
@willharalson4299 10 күн бұрын
Thank you! Very helpful
@BarbHendersonconsulting
@BarbHendersonconsulting 10 күн бұрын
Glad it was helpful!
@LFXMEDIA
@LFXMEDIA 11 күн бұрын
I know it’s 8 years later but thanks for making it simple and to the point lol
@BarbHendersonconsulting
@BarbHendersonconsulting 11 күн бұрын
glad you liked it
@timwhite2680
@timwhite2680 11 күн бұрын
Why would I use this over a pivot table?
@BarbHendersonconsulting
@BarbHendersonconsulting 11 күн бұрын
I am giving you options!
@abassmariam3008
@abassmariam3008 12 күн бұрын
❤good
@BarbHendersonconsulting
@BarbHendersonconsulting 11 күн бұрын
Glad you like it
@inioluwatonade2390
@inioluwatonade2390 12 күн бұрын
Thanks so much. This video was really helpful
@BarbHendersonconsulting
@BarbHendersonconsulting 12 күн бұрын
You're welcome!
@jorgefoyld8538
@jorgefoyld8538 13 күн бұрын
God bless you, Barb!
@BarbHendersonconsulting
@BarbHendersonconsulting 13 күн бұрын
you welcome!
@nikkilawson4834
@nikkilawson4834 13 күн бұрын
I watch this every year when I do my Christmas cards. Thank you so much!
@BarbHendersonconsulting
@BarbHendersonconsulting 13 күн бұрын
You are so welcome!
@MechE11B
@MechE11B 13 күн бұрын
Thank you so much..!
@BarbHendersonconsulting
@BarbHendersonconsulting 13 күн бұрын
You're welcome!
@HarveySpector-w1g
@HarveySpector-w1g 14 күн бұрын
you need to retire ngl
@BarbHendersonconsulting
@BarbHendersonconsulting 13 күн бұрын
ok
@darkjaed
@darkjaed 14 күн бұрын
BARB. THANK YOU GIRL
@BarbHendersonconsulting
@BarbHendersonconsulting 13 күн бұрын
welcome
@atharvaalok2268
@atharvaalok2268 14 күн бұрын
Miss Henderson thank you very much for making this tutorial, this really helped me prepare for my practical tomorrow
@BarbHendersonconsulting
@BarbHendersonconsulting 14 күн бұрын
Glad it was helpful!
@villagewickets
@villagewickets 15 күн бұрын
Thnx
@BarbHendersonconsulting
@BarbHendersonconsulting 14 күн бұрын
Welcome
@johndeer1050
@johndeer1050 15 күн бұрын
This was way quicker than another way of doing this! Awesome thank you!
@BarbHendersonconsulting
@BarbHendersonconsulting 15 күн бұрын
Glad you found it useful!
@rajeshmajumdar4999
@rajeshmajumdar4999 15 күн бұрын
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!
@BarbHendersonconsulting
@BarbHendersonconsulting 15 күн бұрын
You are very welcome, Barb!
@sunilpanikar1229
@sunilpanikar1229 9 күн бұрын
Hi Rajesh, did it work. was it useful for you ?
@MilindaWickramasingheMustang
@MilindaWickramasingheMustang 16 күн бұрын
No fuzz.. just business.. clear instructions and true information.. Thank you so much ❤
@BarbHendersonconsulting
@BarbHendersonconsulting 15 күн бұрын
You're welcome! 😊
@shubhamrathore3703
@shubhamrathore3703 16 күн бұрын
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
@BarbHendersonconsulting
@BarbHendersonconsulting 16 күн бұрын
=SUBSTITUTE(IF(D3=D2, E2&" "&E3,"")," ",",")
@shubhamrathore3703
@shubhamrathore3703 15 күн бұрын
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.
@Fifiiiii895
@Fifiiiii895 16 күн бұрын
This is perfect omgggg thank you so much
@BarbHendersonconsulting
@BarbHendersonconsulting 16 күн бұрын
Happy to help
@AlanSchmelzleKellyEdmondson
@AlanSchmelzleKellyEdmondson 18 күн бұрын
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
@BarbHendersonconsulting
@BarbHendersonconsulting 17 күн бұрын
Thanks for sharing!!
@fayazaiman7867
@fayazaiman7867 19 күн бұрын
Thank you so much
@BarbHendersonconsulting
@BarbHendersonconsulting 18 күн бұрын
You are very welcome!
@King_Raj1
@King_Raj1 19 күн бұрын
Very very thanks ❤
@BarbHendersonconsulting
@BarbHendersonconsulting 19 күн бұрын
Welcome 😊
@YouCantSeeMEorCanYou
@YouCantSeeMEorCanYou 20 күн бұрын
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.
@BarbHendersonconsulting
@BarbHendersonconsulting 20 күн бұрын
You are so welcome!
@TAKN-kh9ws
@TAKN-kh9ws 20 күн бұрын
классно 🤝
@BarbHendersonconsulting
@BarbHendersonconsulting 20 күн бұрын
Спасибо
@naomijansenvanvuuren2119
@naomijansenvanvuuren2119 22 күн бұрын
I want to understand how the % is calculated
@BarbHendersonconsulting
@BarbHendersonconsulting 22 күн бұрын
the actual days divided by the projected days
@alphaprinters9765
@alphaprinters9765 22 күн бұрын
Nice one. Direct and to the point. And this is the easiest method i've seen so far...by the way
@BarbHendersonconsulting
@BarbHendersonconsulting 22 күн бұрын
You're welcome. Glad you found it useful!
@lavendano4921
@lavendano4921 23 күн бұрын
Thank you I have bee trying to delete some macros and just couldn't. Thank you for sharing this :)
@BarbHendersonconsulting
@BarbHendersonconsulting 23 күн бұрын
Your welcome, Only people who have had that problem appreciate this
@kermets
@kermets 24 күн бұрын
How do I not include part of the sheet ?
@BarbHendersonconsulting
@BarbHendersonconsulting 24 күн бұрын
select the range of the sheet that you want to sort
@muthu3396
@muthu3396 25 күн бұрын
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
@BarbHendersonconsulting
@BarbHendersonconsulting 25 күн бұрын
I think what you need to use is a template as sown in this video kzbin.info/www/bejne/f5Oreohon96ebLM
@muthu3396
@muthu3396 26 күн бұрын
Hi, I'm always getting this error "Application-defined or object -defined error" on below line Set pageEditor = xInspect.WordEditor
@BarbHendersonconsulting
@BarbHendersonconsulting 25 күн бұрын
On the visual basic window Tools - References - OLE Automation and Microsoft Office 6.0 Object Library must be checked
@muthu3396
@muthu3396 25 күн бұрын
Yes selected that, I have microsoft office 16.0 but still facing same error..It works fine sometimes and not working sometimes
@BarbHendersonconsulting
@BarbHendersonconsulting 24 күн бұрын
@@muthu3396 That is unusual. I do not know what is happening now!
@muthu3396
@muthu3396 24 күн бұрын
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-tw1bf
@RAKESHYADAV-tw1bf 26 күн бұрын
Thank you 🎉🎉🎉good formula
@BarbHendersonconsulting
@BarbHendersonconsulting 25 күн бұрын
You're so welcome!
@thatkannadagirl25
@thatkannadagirl25 26 күн бұрын
Thank you, I was looking for this exact thing!
@BarbHendersonconsulting
@BarbHendersonconsulting 26 күн бұрын
Glad I could help!
@madaranagahawatte4725
@madaranagahawatte4725 27 күн бұрын
Thanks for this :)
@BarbHendersonconsulting
@BarbHendersonconsulting 27 күн бұрын
you are so welcome!
@garylillich
@garylillich 28 күн бұрын
Want to consolidate monthly bank ledgers into one file, which shows ALL transactions. Is this the best approach??
@BarbHendersonconsulting
@BarbHendersonconsulting 27 күн бұрын
I think that would work!
@dwightcimino1040
@dwightcimino1040 28 күн бұрын
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.
@BarbHendersonconsulting
@BarbHendersonconsulting 28 күн бұрын
Glad I could help
@tabithahamby4693
@tabithahamby4693 29 күн бұрын
You just changed my life 😂✨
@BarbHendersonconsulting
@BarbHendersonconsulting 29 күн бұрын
happy to help!
@pravindilpake9294
@pravindilpake9294 29 күн бұрын
This video is still useful in 27/11/2024. thank you so much😊
@BarbHendersonconsulting
@BarbHendersonconsulting 29 күн бұрын
Glad to hear that!
@adamspencer1741
@adamspencer1741 29 күн бұрын
Can this be done on iPad?
@BarbHendersonconsulting
@BarbHendersonconsulting 29 күн бұрын
Macros as a rule, do not work on tablets
@Meme-oryLane
@Meme-oryLane Ай бұрын
Thanks a lot it really worked for me.
@BarbHendersonconsulting
@BarbHendersonconsulting Ай бұрын
Glad to hear that