Hi! I encounter a problem that I cannot solve myself (even with the help of ChatGPT). I have two excel worksheets in the same file. Sheet1 is a giant table, Column B of this sheet are identification numbers. The rest of the columns are information that is associated to these ident-numbers.
Sheet2 entails two columns: A are also identification numbers and B are „Study-Numbers“.
I have headings in all first cells so data begins from A/B/C/D2.
What I want to do now is that excel searches through all ident-numbers in Sheet 1, if it finds overlap with an ident-number in sheet 2 I would like the Study-number from column B to be copied next to the study number in sheet 1 into column A.
For this I created a new column (column A) in sheet 1 next to the column with the ident-numbers.
This formula created chatGPT for me: =IFERROR(VLOOKUP(B2, 'Sheet2'!$A$2:$B$153, 2, FALSE), "")
A similar formula without the iferror and just =VLOOKUP… doesn’t work either. Sadly it only produces Error-messages that there is a problem with the formula.
I’ve been playing with it for ours and have not found a solution. Would be greatful for any help/troubleshooting!

Optimizing Email Dispatch through VBA

Automating email processes through Excel VBA can significantly enhance productivity, especially for those who regularly send out a multitude of emails. This technique allows for a streamlined approach to email distribution, leveraging Excel macros to interact directly with Outlook. The primary convenience lies in automating repetitive tasks, such as sending weekly reports or notifications to a broad audience. However, a common hurdle encountered by many involves customizing the macro to select a specific sending address within Outlook, especially when multiple accounts are configured.
This challenge arises from the need to personalize emails sent from specific accounts to ensure they align with the sender's identity or the email's purpose. The ability to automate the selection of a 'From' email address directly from Excel VBA not only saves time but also adds a layer of professionalism to the communication. Unfortunately, despite numerous tutorials, the integration of this feature often appears elusive, leading many to resort to manually selecting the sending address for each email. Addressing this issue not only optimizes the process but enhances the overall efficiency of email management.

Command	Description
CreateObject("Outlook.Application")	Initializes an instance of Outlook.
.CreateItem(0)	Creates a new email item.
.Attachments.Add	Adds an attachment to the email.
.Display	Displays the email before sending for review.
For Each...Next	Loops through a range of cells.

Enhancing Email Automation with VBA

Automating email tasks using Visual Basic for Applications (VBA) in conjunction with Microsoft Outlook offers a powerful way to enhance efficiency and accuracy in email communication. This approach is particularly beneficial for users who need to manage a large volume of emails or send personalized communications to multiple recipients regularly. The core of this automation lies in the ability to programmatically control Outlook from within Excel, enabling the sending of emails based on data contained in an Excel worksheet. This functionality can significantly streamline operations such as weekly newsletters, marketing campaigns, or status reports, by automating what would otherwise be a tedious and error-prone manual process.
The challenge, however, comes in personalizing the 'From' field when sending emails from different accounts configured in Outlook. This is a common requirement for users who manage multiple email identities for various roles or departments. The default behavior of VBA scripts is to use the primary Outlook account, which may not always be appropriate for every email sent. By modifying the VBA script to allow the selection of the 'From' address, users can ensure that each email is sent from the most suitable account, enhancing the email's relevance and credibility. Moreover, this customization can contribute to better organization and segmentation of email communications, leading to improved engagement and efficiency.

Integrating 'From' Email Selection in VBA Macros

Written in Visual Basic for Applications

Dim OutApp As Object Dim OutMail As Object Set OutApp = CreateObject("Outlook.Application") Set OutMail = OutApp.CreateItem(0) With OutMail .SentOnBehalfOfName = "your-email@example.com" .To = "recipient@example.com" .Subject = "Subject Here" .Body = "Email body here" .Display ' or .Send End With 

Advanced Techniques in VBA Email Automation

Mastering email automation through VBA in Excel opens up a world of efficiency and personalization for users who need to send out bulk communications but wish to maintain a personal touch. This is particularly important in scenarios where emails need to be tailored to individual recipients or sent from specific accounts to match the communication context. Advanced scripting in VBA allows users to dynamically select the 'From' email address in Outlook, circumventing the limitations of manual selection and the default account restrictions. This capability is crucial for users managing multiple departments, roles, or identities within their professional landscape.
Moreover, the integration of Excel and Outlook through VBA extends beyond just sending emails. It enables the automation of entire workflows, such as generating personalized email content based on Excel data, scheduling emails, and even handling responses. This level of automation ensures that communication is both consistent and efficient, reducing the potential for human error and freeing up valuable time for more strategic tasks. However, navigating this integration requires a nuanced understanding of both Excel VBA and Outlook's object model, highlighting the need for clear guidance and best practices in implementing these solutions effectively.

FAQs on VBA Email Automation

1. Question: Can I send emails through Excel VBA without Outlook?
2. Answer: While Excel VBA is typically used in conjunction with Outlook for email automation, alternative methods can involve SMTP servers or third-party email services APIs, although these require more complex setups.
3. Question: How do I automate sending emails from different Outlook accounts?
4. Answer: You can specify the 'SentOnBehalfOfName' property in your VBA script to send emails from different accounts configured in Outlook, provided you have the necessary permissions.
5. Question: Can attachments be added dynamically in VBA automated emails?
6. Answer: Yes, the '.Attachments.Add' method can be used within your VBA script to add attachments dynamically based on file paths specified in your Excel sheet.
7. Question: Is it possible to schedule emails using Excel VBA?
8. Answer: Direct scheduling is not supported through VBA, but you can script the creation of calendar appointments in Outlook with reminders to send emails, effectively scheduling them indirectly.
9. Question: How can I ensure my automated emails do not end up in the spam folder?
10. Answer: Ensure your emails are not overly promotional, include a clear unsubscribe link, and maintain a reputable sender score. Sending from recognized accounts and limiting the number of identical emails can also help.

Mastering VBA for Efficient Email Management

As we delve into the intricacies of automating email processes via Excel VBA, it becomes clear that this technology offers a potent tool for enhancing communication efficiency. The ability to customize the 'From' email address directly from Excel not only streamlines the email sending process but also opens up a realm of possibilities for personalization and professionalism in email communication. Despite the initial challenges in script modification and understanding the Outlook object model, the benefits far outweigh the efforts. Through careful implementation and continuous learning, users can significantly reduce manual email management tasks, ensuring that emails are sent timely, from the correct account, and with a personalized touch. This exploration underlines the importance of embracing VBA automation in modern business communications, advocating for its role in optimizing workflows and fostering more meaningful interactions in the digital age.
https://www.tempmail.us.com/en/vba/customizing-excel-vba-macros-for-outlook-email-selection

I dont know who will read this, but i just have to get this off my chest.
TL:DR at bottom
A bit of a backstory: I am 19 right now. 11 days from 20. During my life, i have had it all. The best family behind me anyone could ever ask for. They raised me well, gave me all the support and love humanly possible.
I grew up in an eastern european smalltown, been always above average, and slightly autistic at least, lets admit it. The typical gifted white suburban kid syndrome: never ever ran into problems during my life, everything seemd straight forward, always knew what i shold do with my life. During my blunder years, i have developed some pretty bad traits: a never had to struggle in my life for anything. Every single thing was handed to me on a silver plate. I really am just the luckiest person alive: always done well mentally, academically, and socially. Read the book once before when the teacher said put away your books, aced every exam still, after elementary(8 years here), got accepted to one of the best middle school of my country.
Experienced all the perks of middle school and the freedom of doing whatever the fuck you want during the stupidest years of your life, 15-19. And i did. Of course, procrastinating and not giving a fuck have not lifted me above average as in elementary, but i was still in the middle of the group. Again: everything others sweated blood for, handed to me on a silver plate. Straight goals in my life, stable personality, many friends, altough i still had my innocent nerdy kid persona, which was challenged majorly during the primal environment of a middle school coeducated dorm, but was never particularly bullied, countless friends and family, support and appreciation for who i was, altough i was just being as stupid as a middleschooler is.
Then covid came, and it somehow turned everything around. Not so many friends, no such concrete stable confidence, still being a lazy fucker who somehow lucked his way through everything. also during this time, i kinda started falling off, got into weed, not jsut alcohol, started going out and socialising less, falling off, but i had a great time, thinking about those times fondly, altough not so dearly. Rocked my way through the end exams of middle school with some last minute studying, i mean i absolutely still pulled from my little finger what others couldn't with teeth, tears and blood: got accepted into university as a dentist, still feeling like i am the top of the word.
During the last true summer break of my life, i started doing food delivery. 11:30am till 22-23:00 pm sometimes. During this time, the penjamin really took off in my country, weed being illegal but alternatives, such as Hexahidrocannabinol (HHC) being legal, available in a pen, just like an Elfbar: no neet to sneak out, to talk with the plug(some of you know arranging a meeting with those fuckers isnt as easy as it seems at all lmao), just getting high while laying in my bed. During this time, my weed addiction spiralled out of control, i got high every single night, this being my "well deserved downtime": just existing in my own little world in my bed, for 2 months. Those 4 years really did turned my personality to someone who isn't fit for a course that puts "Dr." in front of your name, this wil be important later.
Before the university, there is a social event hosted for us juniors called "junior camp", where you really are supposed to meet new people, and lay the basis of your entire uvicersity social life. And i took the penjamin(like 4th one in 2 months) with me. Now for those of you who dont know, weed can be a nice social drug, taken with moderation. If you get "schwasted, wake n baked" every day, the devils lettuce really puts you into your own world. No ambitions, no will to progress, just existing in your own little world, being fine as fuck with things as it is. Still had the best memory of my life though: being high as fuck in a water park they organised for us, literally youngsters in their prime, like 1500 of us, just being ourselves in the biggest pool party of the country. What i spent it doing: weed and cigarette breaks, taking slides, which literally felt like descending to hell, and walking around, aimlessly, not giving a fuck about the 1,5k people who came here to meet me and socialise, barely communicating with them, floating in my own world. This, and watching tje closing firework while being high are the best memories of my life until this day, guys if you can, take water slides and watch fireworks while being high, its definitely worth it.
And then came the first oath to myself that I've broken since then: that i will do a conversion of Paul, really focusing on the most important thing in my life: becoming a dentist, which is, besides helping people, is a ticket on first class to upper middle class, for someone from a bloodline of the poorest eastern european easants you can imagine. It takes 4 generations to break out of poverty, and i am the 4th. All the blood and sweat of my ancestors who worked their asses out, slaving away for the communist, them capitalist system, only for their kids to someday, amybe havve the chance i do hae right, now, and I am currently fucking up.
Now for those of you who dont know, university really is the most liberal form of education on the planet: you finally get your own timetable, the only mandatory attendance being the "practices", which you could just get through without putting anything on the table, and the lectures where they actually teach you university shit, not having a mandatory attendance, so who gives a fuck?
This gets us to the University: the first 2 weeks, i was being the typical student: al the lectures, learning from day to day, putting myself there in possibly the most alien environment i have ever been during my life. And turns out, i wasn't ready for the maturity and devotion a serious practice like dentistry takes. Man, i will literally be healing other people, everyones been to the dentist, and to get there, standing above your open mouth: Thats not something what is handed on a silver plate. No matter how smart, gifted, or special you think you are: this will only be achieved with tooth and nails. And i wasn't ready, not the slightest.
This is the point where i really started descending to the level of a fast food worker(no offence, which i was too): the first 3 months can be described with one word: Weed. no studying at all, just smoking that shit, feeling the buzz, it got to the point where i couldnt fall asleep without being hihg. Quite literally, i couldn'T imagine laying in bed, just...laying. IN november, i had it all came down on me, had a small breakdown, took the second oath i have broken: that i will change. This was the 11th of November, 2023
I cut back on weed, started attending lectures, realised that i have no fucking idea what the fuck are they talking about, so whats the point of attending? 3 more weks, sometimes begging to 5-6 different plugs, just to get my dose. Then came the so-called "exam period": where they excpt you to account for what you have "learned" during the "period of diligence". Of course, you can ace all your exams in literally 2 weeks, but for me, i was at diggind the foundation, while others were building the roof, already.
3rd oath: i will put my best, really gonna study my ass off for this one, having no plans whatsoever, just getting through somehow, like i always did. I think this is the time where i have made the first real steps towards maturity: admitting my parents that i havent done shit, and the chance of failure is around 90%. They gave me the encouragement i needed, realy got back on track, and pulled my first half year. So much so, that i got a study scholarship: 13k HUF, 36 USD/month, lower middle class scholarship, but still, that meant im in the top 10 percent of students. Yet again, by partying all yer, doing everything in the last moments.
4th oath: after these few weeks of hell, i will really put myself there, study as the year goes along, being ready and up-to*date with everything. Like the adult i am
For 1 week, this really worked out. studies for hours every day, being with my "new friends": fellow dental students, whom i had a really good start with, but now, arent really close pals. They have had a complete change, a real 180 in their life: being out in a new environment, gangs and friend groups really started forming, and i was there sometimes, having a blast with them, but you know: not really a part of the gang, just the chill, stoner, pretty stupid streets dude, never being up to date, never really giving a serious fuck about them, still smoking weed and drinking with my old middleschool friends. They naturally started inviting me less and less, and slowly fell into the group of a workplace friend, who you really dont just meet after work, you know. Now this might just be my insecurity speaking, i literally have a 2 week vacation fixated with them to the beaches of Croatia, but yeah, just a chill dude whos around sometimes, not *the gang*
And then came the wrost 6 weeks of my life. During my all afternoon studying sessions, i started noticing a slight tingling in my legs and feet, and my visual snow, which ive always had for some degree, starting putting itself into second gear. I even jokingly told one of my friends who happened to study with me: "Man, i might have gotten some real nerve damage from all the weed and fake penjamins, a-ha-ha".
During the next few days, hell unfolded: imagine the worst kind of buzzing, not the gentle weed buzzingm but a genuinely alarming one, an impending sense of doom, and pretty serious unvellness: during an anatomy lecture about the cranial nerves. Figured a snus might help: stuffed a Killa cold mint(european snus is generally stronger than Zyn, this particular one being 4times as strong as the stongrst Zyn, and its still pretty mid in eastern europe lmao). Hell broke loose. If you are familiar with trip reports, i have went trhough something very similar to a bad trip, almost had to run out of the lecture, in front of the teacher and 60 of my classmates beceuse i genuinely thought im gonna die. Went out after surbibing the lecture, ambling around for 2 hours, walking to a pharmacy 45 minutes away and back, speaking with my parents, being in a complete panic which just made things worse.
This went on for a week, then i got to the doctor. The anatomy practice was always the low point: the best teacher of the institute explaining how a human body works, and i was shaking in a corner, not falling into the deepest panic attack i have ever had was taking up all my energy. Drumming with my leg,s counting the tiles on the floor again and again, not paying attention about some of the most important words ever said to me in my life. Went to the doctor that friday finally, and got good words that i am really studying anatomy, i must have known that the innervation of the top of the limbs and and the feet are completely different, so my CNS works just fine, but im describing the most common symptoms of stress induced anxiety. Also told him about my ever worsening visual snow: imagine those old TV-s who had no signal, and displayed what we called "ant football". That is my life, especially when i look at the sky, which was a thing i admired dearly: The giant cloud, not abstructed by any mountain, flowing, and ever changing, still are the most beautiful thing for me, compared with the mind.blowing sunsets we have here, in the great plains. Being robbed of that put me even deeper. The 75mg pregabalin i got described, once a day and night, havent done anything at all. INstead, they amplified my brain fog, the tingling and buzzling, and the feeling of looming dread. I havent known this at the time, so sometimes i took my daily two before the anatomy sessions, which made them truly like hell. Having to walk out multiple times in a span of 1,5 hours of the lesson, just to simply breathe. If someone closed the door of the dissecting room, all hell broke loose, i couldn't breathe. I was bumping into people on the way there and back, being so disoriented due to basically being drugged. Talked about my mother about this, she went through literally the same hell, while attempting university, just like his brother, my Godfather, who was a border guard during the East-German refugee crysis, having to shoot live munition centimeters in front of the feet of pregnant women during the fall of the iron courtain. And this was a true and horrific mental breakdown, a literal *Idegösszeomlás*, akai burnout
So long story short: missed the most crucial 8 weeks of the semester, where we were told in the beginning: if you miss a week, you are done for. The last parts of the period of diligence were spent studying like hell, with my symptoms greatly improvving: attended parties with the dentist gang, smoked weed again, and just laid the foundations for the period of exams, actually studying like hell, like i always wanted to, AND I STILL ACED IT, but with the looming over me the sword of damocles.
Now thinking back, i could've made it. I really cold have. I still can. I completed every single subject i could in the diligence period, cell biology being the hardest, I barely passed that subject with a "2", basically a B-, this will be very important later. The last exam date is at the 7th of july, but with 6 weeks for only the anatomy, and basically the chemistry of 5 years, thats should be enough, eh? Yeaahh, yet another broken oath, spent a week doing nothing, weed, youtube, and old friends, while everyone leraned their asses off. Started learning too, and i took it seriously. But any students, you know how it is:

alarm set at 7:30 am.
10 minutes of snooze, every single day, the next time i wake up more rested than i should have been after 10 minutes, i check the clock, 8:50AM.
Awesome, get out of bed and shower. Check the time again: 11AM.
Cool, the whole day ahead of me. Just a siiiingle youtube video, while i pass the morning fatigue and the rapid morning hearthbeat of 5 years of chainsmoking, yet another amazing dedication of my life.
Then its 12AM, time to dinner! Post dinner fatigue is exactly a 30min video, 12:30PM, imma begin studying.
Next time i look at the clok, its 14:27. I really lock in until 6pm, then my parents cone home. I talk with them for what feels like 20-25 minutes.
Look at the clock again. 20:21PM. How the fuck did the whole fucking day passed again? i truly lock in for the rest of the day
23:35, i can't anymore. Starting to watch trash streams on youtube, braincells dying every second
Time spent with studying: 2-3 hours.
Every. Single. Fucking. Day.

Then i got the worst news i have ever gotten
Decided to check into the E-uni managament system of my country. "You have an offered grade, you can accept it *here*. Click link. "you can't accept, you have an exam applification of this subject". So this was the first semester where they made the application to the different exams at different dates open at March instead of the end of May, so students can "pre-plan their whole semester", the backstory of this is some uni drama equal in lenght of this post *hungarian text-* (Akinek esetleg volt dolga a Debreceni Egyetem Anatómiai-, Szövet-, és Fejlődéstani intézetével, az pontosan tudja miről beszélek lmao, a többiek úgysem értenék, H***igeci),
So, remember about my offered grade about cell biology? Wel, you have to accept it, because it LITERALLY MEANS THEY OFFERED IT AND YOU CAN DECLINE IT, this is stragiht up ez shit, of course who was the hero, who forgot to do this 5 seconds thing? My pretty faced self. All the while having an exam booked for the 28th of may, which obviously had passed, and i jsut realized this now, because the university e-administration site, which you should check every day for like 10 times, havent been opened by me for a month. And in my country, no matter what grade you get offered, if you take an exam and dont attend, thats automatically a failure overwriting literally any grade you had before. And i really put in the work. Really did got the offered grade, which means 55% on 2 intersemester exams, which both of them are hell. And all undone because im too fucking lazy and stupid to open a fucking website. Because i havent declined the offered grade, and this is the first year they implemented the early exam booking, i still have hope that the email i have written towards Students affairs will have an effect, and i will be able to accept the offered grade. We are talking about a subject where if you do have to take the exam, there is a 90% failure rate. 90. fucking. percent. I have 1 month to learn the Central Nervous System(at least i know that mostly by now), and the complete human body as it is from the shoulders upwards, embriology, histology of the semester, and 1 ENTIRE YEAR of university level chenistry. Im fucked already as it is, cell biology by itself would take 3 weeks of no life learning JUST TO HAVE A CHANCE, which i have completed, and willingly, and ignorantly have thrown away.
What happens if i fail? Well, the state pays 12 active and 3 passive semester. The course is 10 semesters, so i can passivate and then retry, and still have a chance like this once more, before falling out of State Sponsored Scholarship. A semester is 1,3 million HUF, 5 months on minimum wage if you dont eat, sleep, and save 100%. PER SEMESTER. So the world wont collapse, buti would lose everyone i met during university, dropping to a class of strangers, being the failed kid, so laying the path from the best kinda uni life to the worst, in terms of connections and social life. My family knows about my mental health, even my conserative KGB grandparents are very supportive, but i wouldn't be able to stand the shame myseelf.
Had an eye watering hours long convo with a genuine friend about my life, and that made me realise im still aint shit, things reall have to change. this is why im typing this, mainly for my own self. As the first page of a diary im planning on starting, to never forget the feeling of being in the literal bottom right now. I dont except anyone to read this, idk why im even posting this, i dont even except any advice, but ofc if you have made it this far, thank you for dwelving into the life of a hungarian smalltown trash, hope you can learn
Not gonna reread this fucking yapping, sry for the typos and language, english isn't my first one
So this was it guys, my Magnum Opus of literature, the biggest yapping session of my life so far. Still spent 1,5 hours typing this even on my pc, instead of studdying, on 1,5mg alprazolam(xanax benzo), about to smoke a jo. Yet another broken oath
TL:DR: Failed to mature up for a hardcore branch of university, and a silly mistake will destroy my entire semester, and im still not studying, typing this

Saturday, June 01 - Friday, June 07, 2024

Top 5 Posts

score	comments	title & link
14	16 comments	[ProTip] TIL: Application.DisplayAlerts is weird!
9	8 comments	[Show & Tell] Getting the outside IP address without connecting to a 3rd party service
6	16 comments	[Unsolved] VBA SendKeys too fast/slow problem
5	13 comments	[Solved] VBA that let's me change fill color based on hexcode in cell value?
4	14 comments	[Solved] Question regarding implements & interface

 

Top 5 Comments

score	comment
9	RotianQaNWX said In VBA IsEmpty is a function that returns a boolean, not a method assigned to any particular object. Therefore you should use it as: If IsEmpty(Sheets("name").Range(testCell).value...
8	otictac35 said Hi! Look up PyAutoGui for Python. It's fairly easy to learn and I think does exactly what you want.
8	sslinky84 said You mean like perform the actions in parallel? No. VBA has no async processing. If you're talking about forty worksheets shadowing what you do in one of them, it's possible, I suppose. But is there a...
7	Day_Bow_Bow said The first answer on your linked post just needs some slight tweaks to get what you request. First, I think you need to understand the Worksheet_Change that it uses. It is added directly to the works...
7	sslinky84 said Don't use `SendKeys`. You'll spend years fiddling with it to get it right and then it'll only work most of the time. You're better off figuring out how to do it with browser automation (i...

 

Hello!
I'm new to excel and through YouTube I've figured out how to automatically update data in another excel worksheet. Found an excellent video which showed three ways to do it (sheet cell reference, excel tables and power query) and found power query to be the easiest to handle.
However, when I follow any of these three methods, I can only update my data through the original data table. I also want to be able to do it the other way around, i.e. make changes in my linked data sheet so that it automatically updates the original, larger, data sheet.
Is that even a possibility? How do I go about doing that?

I'm using the sort function to sort a range of cells, some of these cells includes hyperlinks to different worksheets. After I have used the the sort function, the hyperlinks are gone, how can I keep the hyperlinks. The hyperlinks I have used is the "place in the document" so I'm referring to another place in my excel document.

https://preview.redd.it/lkj25x50f65d1.png?width=3380&format=png&auto=webp&s=efd1d9af528f36ad8d0f4ba6e3ad03b8caf51b9b
The problem is in the highlighted yellow line of code. Anyone know what to do?

hello, i need help with applying this formula down the N column without it touching all the cells containing the word ‘price’. any help is appreciated! my worksheet

I am using the following formula to search across multiple worksheets in the C column to find the number of times specific value appears.

=SUMPRODUCT(COUNTIF(INDIRECT("'"&P7:P13&"'!C:C"),C10))

P7:P13 is the list of worksheets, I will be expanding this as new worksheets are added.
When I use the formula I end up with #REF! error.
Now if I remove the range P7:P13 and set it to a single cell in the range it works.
I am not sure what I need to do to remove this error.
Thank you for your help.

I am entering text data from different sources, both written and oral, onto multiple worksheets. Each subject worksheet will contain information from more than one source. Does anyone have suggestions about how to "label" the source of the information in a cell? Looking to capture this reference information so that if future/other users have questions about the content in a cell, they can seek out the source: interview with X, Document Y, Study Z... "Labels" could be colors, fields, anything with a legend so that people can identify the source.
TIA

I've been wracking my brain on this for ages now and still can't figure it out.
This is a personal project of mine that I am creating partially for practical benefit, partially as a skills test for my Excel capabilities, and partially so I can share with family, friends, and maybe the public as a useful tool.
I'm building a custom loan amortization table so I can track various loans of mine, primarily my car loans and student loans. Both are rendered inaccurate because the PPMT, IPMT, PMT, etc. functions only account for interest accruing monthly, so my numbers are off. Here is a picture of my current spreadsheet:
The blank spreadsheet
The idea is that once i finish, the sheet will be protected so that only the values highlighted in yellow are unlocked and editable. All of the non-yellow cells use IFERROR and ISBLANK functions to ensure they remain blanked out until the data in the yellow highlighted cells is input. The table has 360 rows in total, but only the rows necessary will be filled in with numbers. For example, this is the function to denote the payment number for Payment two until the loan is paid off:

=IFERROR(IF($B10=Num_Payments,"",$B10+1),"") 

That button that says Reset Inputs is a form control button tied to a custom macro that clears the values in the yellow highlighted cells and replaces the Autopay Discount value with 0.00%. My code is here:

Sub Reset_Table() ' Clear_Inputs Macro ' This Macro clears all of the available inputs for the loan amortization table. ActiveSheet.Unprotect Range("E3:E7,H3:H7").Select Selection.ClearContents Range("E7").Value = 0 ActiveSheet.Protect End Sub 

I'm not very good at VBA coding, but I tried to make it as simple as possible.
On to the issue at hand:
I currently am using basic PMT, IPMT, PPMT, CUMIPMT, and CUMPRINC functions to calculate the actual values in the table, but as stated earlier, these are insufficient when interest is compounding daily. I have tried to make custom functions to replace these, but as said, my VBA knowledge is minimal.
My attempt at making a payment function for compounding interest is as follows:

Function COMPMT(rate, nper, pv, compounds, years) ' Calculates payments with compounding interest. COMPMT = (pv * ((1 + (rate / compounds)) ^ (years * compounds))) / nper End Function 

Within the function, the arguments are as follows:

• rate is the annual interest rate, or APR. Within this worksheet, I would reference cell H4.
• nper is the total number of payment periods for the loan.
• pv is the amount borrowed
• compounds refers to the number of times interest compounds on the loan in a given year. I've built a separate table on another worksheet that will eventually be hidden. This switches the input given in cell E6 for a numerical value that will be used in the function.
• years refers to total number of years the loan will be active for.

I've tested this function a little bit and it appears to be working, so now I need to move onto functions for Interest, Principal, Cumulative Interest, and Cumulative Principle. Under normal circumstances with a constant monthly payment, the proportion of that payment that is paid toward interest decreases over time while the proportion paid toward the principle increases over time. I am unsure of how to replicate this in my function.
Currently, I have the following for a compounding interest function:

Function COMIPMT(rate, nper, pv, compounds, years) ' This function is used to tabulate compounding interest. COMIPMT = ((pv * ((1 + (rate / compounds)) ^ (years * compounds))) - pv) / nper End Function 

As you can see, it's literally the same as the payment function, just subtracts the pv from the value before dividing it into the number of payments. This, of course, doesn't perform the ancillary function of showing the change in payment proportion like I want it to. I'm not even certain if that same phenomenon occurs when interest compounds daily, but please enlighten me.
Once I get this done, I will need to build another function to calculate the same thing for principle payments and for the cumulative payments.
I want these functions to work in a way that it can accept the number of interest compounds per year as an argument so the functions have more flexibility and can be used in broad contexts. For example, if one uses 12 as the input for the compounds argument, the output should be identical to the preexisting PMT function.
Lastly, standard Excel functions have pop-ups and dialogue boxes to help ensure we are entering inputs correctly. Is there a way to replicate this functionality within these custom functions? I often forget what order I've placed arguments in within the custom functions.

Hello all,
I receive a paycheck every 2 weeks, so have "26 paydays" and run a "13 month" budget. My mortgage company will not accept bi-weekly payments so I have 2 extra payments per year. I can add extra principal to my mortgage payment each month. Instead of going in and paying 2 extra times a year, I want to find out how much I can add to my mortgage with the extra paychecks and have close to $0 at a certain date (Jan 1st, 2041). I currently pay $1676.63 per month to my mortgage with an extra $73.37 to principal payment to round out to $1750 a month, so I have $1750 extra at the end of the year.
As of now, I have $1803.80 extra ready to add to the $1750 per year.
https://docs.google.com/spreadsheets/d/1TEgCK5RQbEpBAMT98rHkpjzPhDdl-Fyb5vPHX5o5yL4/edit?usp=sharing
"Amortization Schedule" sheet is a work in progress to see if the payments would be close to my retirement date.
"Paychecks" sheet is the actual dates I get the extra paycheck.
"Sheet6" sheet is the worksheet I am trying to figure out.

• G2 is total amount in dollar value of extra payments.
• H2 is total count of extra payments, this could be deleted I believe.
• I2 is Total divided by end goal of January 1st 2041. I think this is where my issue is.
• J2 is the extra principal I already pay
• K2 is the total of I2 and J2 that goes into the Amortization sheet to find if I am close to my retirement date goal.
• C162 is where I start to go negative and am wondering how I can not go negative in any cell.

Thank you.

I have a worksheet that I use to display data for various jobs and the data on that sheet changes as you change the job in the dropdown located in cell C6. I have a script that I wanted to more or less "permanently" record the numbers displayed on a different worksheet just for faster recall instead of it having to perform the multiple calculations each time. When it seemed to take forever to execute the script, I resorted to just have the numbers "permanently" stored on the same worksheet, thinking and believing the issue had to be something about recording those numbers elesewhere. The script still takes a good 3 minutes to execute, so I should be clear about this, the script does what it was intended to do but I cant believe a simple script like this takes 3 minutes to execute. In trying to streamline as much as possible, I have it extract the number from cell C6 since all those will be unique and I use that as the row number to place the data in. Then it is just a matter of taking what is in K17, K23, and K25 and recording those numbers, along with what is in C6 in the range O:R. So for example, if the number extracted from C6 was 16, then O16 would equal the full value of what was in C6, P16 would equal what is in K17, Q16 would equal what is in K23, and R16 would equal what is in K25. Should be simple, right? And like I said, it does work, but why would it take 3 minutes to execute that script? Is there something else I could do so then when executed it was done instantly? I have included the script below:
function onOpen() { var ui = SpreadsheetApp.getUi(); ui.createMenu('Custom Menu') .addItem('Record Values', 'recordValues') .addToUi();} function recordValues() { var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); try { // Retrieve values individually var c6Value = sheet.getRange('C6').getValue(); var k17Value = sheet.getRange('K17').getValue(); var k23Value = sheet.getRange('K23').getValue(); var k25Value = sheet.getRange('K25').getValue(); // Extract row number from C6 value var rowNumber = parseInt(c6Value.match(/^\d+/)[0], 10); // Ensure valid row number if (rowNumber > 0 && rowNumber <= sheet.getMaxRows()) { var range = sheet.getRange(rowNumber, 15, 1, 4); // Set values in the determined row range.setValues([[c6Value, k17Value, k23Value, k25Value]]); SpreadsheetApp.getUi().alert('Data saved successfully!'); } else { SpreadsheetApp.getUi().alert('Invalid row number extracted from C6 value.'); } } catch (e) { SpreadsheetApp.getUi().alert('An error occurred: ' + e.message); } }

Hi! I am making a personal financing sheet, and I want to automize the data analysis a bit, and I figured a lot of it out, but the final touch is not something I have ever thought of doing, which is incrementing a formula's reference value. Please help, I would really appreciate the help! Thank you in advanced
My Excel Doc
My formula that I need to increment "$B7" and "$D7" in is '= SUMIFS((Table3[[Amount]:[Amount]]),(Table3[[Category]:[Category]]),E14,(Table3[[Date Entered]:[Date Entered]]),">="&Sheet3!$B7,(Table3[[Date Entered]:[Date Entered]]),"<"&Sheet3!$D7)
Edit: SOLVED!! I asked ChatGPT again and figured out the correct configuration of words to ask it!

Sub NewestAttempt() Dim ws As Worksheet Dim cell As Range Dim formula As String Dim newFormula As String Dim oldBRef As String Dim newBRef As String Dim oldDRef As String Dim newDRef As String Dim oldBRow As Long Dim newBRow As Long Dim oldDRow As Long Dim newDRow As Long Dim bPattern As String Dim dPattern As String Dim regex As Object Dim matches As Object ' Set the worksheet Set ws = ThisWorkbook.Sheets("Sheet2") ' Set the target cell (for example, B2) Set cell = ws.Range("E7") ' Check if the cell contains a formula If cell.HasFormula Then ' Get the formula formula = cell.formula ' Define the reference patterns for B and D columns bPattern = "Sheet3!\$B(\d+)" dPattern = "Sheet3!\$D(\d+)" ' Create the regex object Set regex = CreateObject("VBScript.RegExp") regex.Global = False regex.IgnoreCase = True ' Process B column reference regex.Pattern = bPattern If regex.Test(formula) Then Set matches = regex.Execute(formula) oldBRow = CLng(matches(0).SubMatches(0)) newBRow = oldBRow + 1 oldBRef = "Sheet3!$B" & oldBRow newBRef = "Sheet3!$B" & newBRow formula = Replace(formula, oldBRef, newBRef) End If ' Process D column reference regex.Pattern = dPattern If regex.Test(formula) Then Set matches = regex.Execute(formula) oldDRow = CLng(matches(0).SubMatches(0)) newDRow = oldDRow + 1 oldDRef = "Sheet3!$D" & oldDRow newDRef = "Sheet3!$D" & newDRow formula = Replace(formula, oldDRef, newDRef) End If ' Set the new formula cell.formula = formula End If End Sub 

In 2019, I was, err… assaulted and I had a son (underage pregnancy). I hid my pregnancy all throughout so my father I live with wouldn’t know about it. My female friend who wanted kids agreed to take my son and say he was hers, but we stayed connected still as discreetly as possible.
I was born and grew up and still live in an abusive household, I couldn’t let my father know about my son so he wouldn’t have to be part of this family. We manage to see each other when I come to their place very safely when possible. He loves me, he knows me, I love him too, he’s a good kid, he’s adorable… Fast forward to the AITA.
He wanted to spend the day(mother's day last week) with me (ah yes : he knows) It was arranged that I would, by coming to their house. But that day, I couldn’t leave because my leg was hurt. My father made sure I couldn’t and shouldn’t leave the house, and I fear he would know. So since I couldn’t come, they came to see me! I had made it absolutely clear how they shouldn’t do this! Without even warning, they were coming over! Had they, I would have said no because it is dangerous.

My friend said it was okay because my dad just wouldn’t learn about our linkage/relation and just pass them as a friend and her son

But it’s much more than that, my dad can be dangerous to even my friends and me. It had already happened once, in elementary school. My girl-friend from kindergarten I told to not to call my house (it was in the ’00s, no cell phones back then for us; if you tried to call someone the parents might answer), after a long relationship of several years of her listening and not calling again, we saw each other at school every day, I learned the teacher had decided I would skip a grade… So we wouldn’t be together anymore. We learned that at the end of the year, so we parted. She decided to break her promise and called my house. She had the number because usually I call her because she made it clear that I could. Only I wasn’t there… and my father answered… I don’t know exactly what he told her but I never saw her again.

He made it clear and outright told me since my birth, really, that if I didn’t comply to what he wanted me to do, he would pass me as crazy

If I did anything to displease him ever unknowingly, it would be easy for him; he raised me, after all. He would pass me as bad to have tutelage over me ever + sympathy from other people. And it worked! Not sure what he said but he ended a half dozen years’ relationship in a few words… Because she believed him instead of me after a half dozen years of a relationship!
I know my father is good with words, I know he is manipulative (it even worked on me to an extent; but set someone on fire a few times and weirdly they’re not as inclined to believe you anymore; Not the ever-towering-above-me fear of ‘I’ll pass you as crazy if you do one thing I don’t like,’ though! That!! That is real!! He can completely do it! He has all the power, the will, the means…)
And I don’t want that for my son! He has to stay away from him!
If one word from my father is enough to turn my friends of years against me, they absolutely can’t meet! Not because I have something to hide, I don’t. Because it has always worked, no amount of innocence on my part can protect me from lies. I do not trust them to believe me. No one ever has but I’m also really scared if he learns of the parentage; how would he, considering? If my father could make my friend talk, she would outright tell him.
In the end, I ended up not shooing them away, because I couldn’t and for fear of seeming ever more guilty (the amount of things in my life I’ve done to avoid not being wrongly accused of something I didn’t commit…)
I need to be able to trust them. Trust them when they say they’ll never pull this stunt after I’ve made them swear again they would not and they told me yes. I didn’t mean to make them feel bad or unwelcome.

As the title says- I’m looking for a subreddit for teachers who personally ADHD, or at least some tips/tricks from those who’ve found success at their job with systems that work!
I’ll start my 13th year in upper elementary math next fall, and I still haven’t nailed down routines and systems that work. I cannot do another year of controlled chaos.
A bit of background on my school- my admin runs a tight ship for students. I feel very comfortable speaking with admin about concerns and feel heard. Our students are taught the same school wide expectations each year, and we generally don’t have too many issues with students acting up in class.
This is where I struggle in MY classroom, particularly the lack of executive functioning of my ADHD. I am only diagnosed as inattentive. I am medicated, have spoken with my doc about dosage. I teach upper elementary math/science.
It’s me, hi, I’m the problem, it’s me.

1. Keeping up with grading- I only have 40 students, but we do a lot of work in class, and usually 4 grades a week from work. But 160 pages is so much for my brain. And that’s just in math- so while test there’s a right/wrong answer, I try to really review their work and see where they’ve made a mistake. I can hyper focus on this and it turns into a full pages lesson on their worksheet. How do I stop this? Then there’s science with writing pieces and labs 🫠 Which leads me to my next struggle-
   
2. Efficient small group time. My schedule allows for built in small group time. I can get easily distracted by chitchat, kids sharpening pencils, working in partners, etc. so I feel like a lot of my time devoted to small group is constantly interrupted because, SQUIRREL. 🤦‍♀️
   
3. Then on to my next point- classroom routines/systems. Should I provide sharpened pencils so they don’t sharpen them throughout class- this seems like a lost battle to me because there are always a few who work their pencils to a nub 🤦‍♀️ and more than likely it’s one more thing to remember to do at the end of the day. Easy to follow discipline steps so it doesn’t constantly knock my brain off the lesson at hand? I do have bell work, then number talks, then whole group->guided practice->partnegroup work-> independent/small group. This of course can change if something comes up….
   
4. Keeping my room organized and picked up. The struggle is reeeeeeaaaalllllll for my brain to process this.
   

I’m on summer break, but I can’t get this out of my head until I “solve” it.
What’s teacher to do?

I have a workbook with vba code that is sent to a lot of different people to use. One of the main features is that it automatically creates new worksheets with the name a user enters into a cell.
There have been a lot of reports where it suddenly starts crashing the second it opens. The crash appears to occur once the program tries to compile the code on open (there is some on workbook open code). It will continue to crash unless I go in and fix it.
The fix is to open the workbook with macros blocked, go to view code and then select compile. Save and exit. Turn macros back on and reopen it and it will be working again.
I already tried having everyone download a registry fix but that hasn't solved it. I read somewhere that the compiler can get stuck when new sheets are created. Does anyone know if there is a fix to prevent the compiler from getting stuck and crashing the entire file?

I have a table that automatically updates data from another workbook.
Then when I have to send said data per email to a client, I copy the entire row(s) to another worksheet which has a preset format to write the email with VBA.
I'd like to automatically add a time stamp to the last cell(s) in the row(s) that I copied so that I can now if and when the data has been emailed.

The Union Public Service Commission has released NDA Syllabus 2024 PDF through the official notification. Candidates should check UPSC NDA 1, 2 Syllabus to understand the topics that must be studied for the upcoming NDA Exam. The UPSC NDA syllabus 2024 is divided into two subjects, i.e. Mathematics and General Ability Test.
The NDA 2024 Syllabus includes objective-type questions only. Along with the syllabus, candidates must check the NDA Exam Pattern 2024 to understand the exam requirements and format. Scroll down the page to check the NDA Syllabus 2024 in Hindi and English, the NDA exam pattern, the marking scheme, etc, here.

NDA Syllabus 2024

The UPSC NDA Syllabus 2024 for the written exam is divided into two papers, i.e. Mathematics and General Ability Test. Candidates should be familiar with the NDA 2024 syllabus to understand the topics and sub-topics that can be asked in the exam. They should begin the preparation after understanding the NDA 2 Syllabus 2024, as it will help them align their approach with requirements. Check the detailed NDA Syllabus 2024 PDF in English and Hindi here.
Candidates should check the UPSC NDA Syllabus and Exam Pattern before commencing the preparation. The official syllabus has been detailed in the NDA Notification 2024 .

NDA Syllabus 2024 Important Topics

The NDA Syllabus 2024 PDF is divided into two subjects: Mathematics and General Ability Test. Moreover, the NDA General Ability Test syllabus is divided into two sub-parts: English and General Knowledge. The NDA Syllabus 2024 PDF Download in English covers various subjects, such as physics, chemistry, general science, social studies, geography, and current events. Check the detailed NDA Syllabus 2024 for all the subjects below.

NDA Syllabus 2024 for Mathematics

The NDA Mathematics Syllabus 2024 comprises various sections, i.e. Algebra, Matrices, Trigonometry, Analytical Geometry, Differential Calculus, Integral Calculus, Vector Algebra, and Statistics and Probability. The detailed NDA Syllabus 2024 for Mathematics is shared below for reference purposes.
NDA Syllabus for AlgebraConcept of set, operations on sets, Venn diagrams. De Morgan laws, Cartesian product, relation, equivalence relation. Representation of real numbers on a line. Complex numbers—basic properties, modulus, argument, cube roots of unity. Binary system of numbers. Conversion of a number in decimal system to binary system and vice-versa. Arithmetic, Geometric and Harmonic progressions. Quadratic equations with real coefficients. Solution of linear inequations of two variables by graphs. Permutation and Combination. Binomial theorem and its applications. Logarithms and their applications. NDA Syllabus for Matrices and DeterminantsTypes of matrices, operations on matrices. Determinant of a matrix, basic properties of determinants. Adjoint and inverse of a square matrix, Applications-Solution of a system of linear equations in two or three unknowns by Cramer’s rule and by Matrix Method. NDA Syllabus for TrigonometryAngles and their measures in degrees and in radians. Trigonometrical ratios. Trigonometric identities Sum and difference formulae. Multiple and Sub-multiple angles. Inverse trigonometric functions. Applications-Height and distance, properties of triangles. NDA Syllabus for Analytical Geometry of Two and Three DimensionRectangular Cartesian Coordinate system. Distance formula. Equation of a line in various forms. The angle between two lines. Distance of a point from a line. Equation of a circle in standard and in general form. Standard forms of parabola, ellipse, and hyperbola. Eccentricity and axis of a conic. Point in a three-dimensional space, the distance between two points. Direction Cosines and direction ratios. Equation two points. Direction Cosines and direction ratios. Equation of a plane and a line in various forms. The angle between two lines and the angle between two planes. Equation of a sphere. NDA Syllabus for Differential CalculusConcept of a real-valued function–domain, range, and graph of a function. Composite functions, one-to-one, onto, and inverse functions. The notion of limit, Standard limits—examples. Continuity of functions—examples, algebraic operations on continuous functions. Derivative of function at a point, geometrical and physical interpretation of a derivative—applications. Derivatives of sum, product, and quotient of functions, derivative of a function with respect to another function, derivative of a composite function. Second-order derivatives. Increasing and decreasing functions. Application of derivatives in problems of maxima and minima NDA Syllabus for Integral Calculus and Differential EquationsIntegration as inverse of differentiation, integration by substitution and by parts, standard integrals involving algebraic expressions, trigonometric, exponential and hyperbolic functions. Evaluation of definite integrals—determination of areas of plane regions bounded by curves—applications. Definition of order and degree of a differential equation, formation of a differential equation by examples. A general and particular solution of differential equations, solution of the first order and first-degree differential equations of various types—examples. Application in problems of growth and decay NDA Syllabus for Vector AlgebraVectors in two and three dimensions, magnitude and direction of a vector. Unit and null vectors, addition of vectors, scalar multiplication of a vector, scalar product or dot product of two vectors. Vector product or cross product of two vectors. Application work done by a force and moment of a force and in geometrical problems NDA Syllabus for Statistics and ProbabilityStatistics Classification of data, Frequency distribution, cumulative frequency distribution—examples. Graphical representation—Histogram, Pie Chart, frequency polygon— examples. Measures of Central tendency—Mean, median and mode. Variance and standard deviation—determination and comparison. Correlation and regression. Probability Random experiment, outcomes and associated sample space, events, mutually exclusive and exhaustive events, impossible and certain events. Union and Intersection of events. Complementary, elementary and composite events. Definition of probability—classical and statistical—examples. Elementary theorems on probability—simple problems. Conditional probability, Bayes’ theorem—simple problems. Random variable as function on a sample space. Binomial distribution, examples of random experiments giving rise to Binominal distribution

NDA Syllabus 2024 for General Ability Test

The NDA General Ability Test Syllabus 2024 is divided into two parts: English and General Knowledge. The NDA question paper in English will be designed to assess the candidate’s understanding of English and workmanlike use of words. The NDA English syllabus covers various aspects, such as Grammar and usage, vocabulary, comprehension, and cohesion in extended text, to assess the candidate’s proficiency in English.
The NDA General Knowledge syllabus will broadly cover the subjects, i.e. Physics, Chemistry, General Science, Social Studies, Geography and Current Events. Check the detailed NDA Syllabus 2024 for the General Ability Test shared below for reference.
NDA GAT Syllabus 2024 NDA Syllabus for EnglishSpotting Errors Comprehension Selecting Words Synonyms Antonyms Sentence Improvements Ordering of Words in a Sentence, etc. NDA Syllabus for PhysicsPhysical Properties and States of Matter, Mass, Weight, Volume, Density and Specific Gravity, the Principle of Archimedes, and the Pressure Barometer. Motion of objects, Velocity and Acceleration, Newton’s Laws of Motion, Force and Momentum, Parallelogram of Forces, Stability and Equilibrium of bodies, Gravitation, elementary ideas of work, Power and Energy. Effects of Heat, Measurement of Temperature and Heat, change of State and Latent Heat, Modes of transference of Heat. Sound waves and their properties, Simple musical instruments. Rectilinear propagation of Light, Reflection and refraction. Spherical mirrors and Lenses, Human Eye. Natural and Artificial Magnets, Properties of a Magnet, Earth as a Magnet. Static and Current Electricity, conductors and Nonconductors, Ohm’s Law, Simple Electrical Circuits, Heating, Lighting and Magnetic effects of Current, Measurement of Electrical Power, Primary and Secondary Cells, Use of X-Rays. General Principles in the working of the following: Simple Pendulum, Simple Pulleys, Siphon, Levers, Balloon, Pumps, Hydrometer, Pressure Cooker, Thermos Flask, Gramophone, Telegraphs, Telephone, Periscope, Telescope, Microscope, Mariner’s Compass; Lightening Conductors, Safety Fuses. NDA Syllabus for ChemistryPhysical and Chemical changes. Elements, Mixtures and Compounds, Symbols, Formulae and simple Chemical Equations, Law of Chemical Combination (excluding problems). Properties of Air and Water Preparation and Properties of Hydrogen, Oxygen, Nitrogen and carbon dioxide, Oxidation and Reduction. Acids, bases and salts. Carbon—different forms. Fertilizers—Natural and Artificial. Material used in the preparation of substances like Soap, Glass, Ink, Paper, Cement, Paints, Safety Matches and Gun-Powder. Elementary ideas about the structure of Atom, Atomic Equivalent and Molecular Weights, Valency NDA Syllabus for General ScienceThe difference between living and nonliving things. The basis of Life—cells, Protoplasms, and Tissues. Growth and Reproduction in Plants and Animals. Elementary knowledge of Human Body and its vital organs. Common Epidemics, their causes and prevention. Food is a source of Energy for man. Its constituents include a balanced Diet. The Solar System includes meteors, comets, and Eclipses. Eminent Scientists have achieved many achievements. NDA Syllabus for History, Freedom Movement etc.A broad survey of Indian History, with emphasis on Culture and Civilisation. Freedom Movement in India. Elementary study of Indian Constitution and Administration. Elementary knowledge of Five Year Plans of India. Panchayati Raj, Co-operatives and Community Development. Bhoodan, Sarvodaya, National Integration and Welfare State, Basic Teachings of Mahatma Gandhi. Forces shaping the modern world; Renaissance, Exploration and Discovery; War of American Independence. French Revolution, Industrial Revolution and Russian Revolution. Impact of Science and Technology on Society. Concept of one World, United Nations, Panchsheel, Democracy, Socialism and Communism. Role of India in the present world. NDA Syllabus for GeographyThe Earth, its shape and size. Lattitudes and Longitudes, Concept of time. International Date Line. Movements of Earth and their effects. Origin of Earth. Rocks and their classification; Weathering—Mechanical and Chemical, Earthquakes and Volcanoes. Ocean Currents and Tides Atmosphere and its composition; Temperature and Atmospheric Pressure, Planetary Winds, Cyclones and Anti-cyclones; Humidity; Condensation and Precipitation; Types of Climate, Major Natural regions of the World. Regional Geography of India—Climate, Natural vegetation. Mineral and Power resources; location and distribution of agricultural and Industrial activities. Important Sea ports and main sea, land and air routes of India. Main items of Imports and Exports of India. NDA Syllabus for Current EventsKnowledge of Important events that have happened in India in recent years. Current important world events. Prominent personalities—both Indian and International including those connected with cultural activities and sports
NDA GAT Syllabus 2024 SubjectNDA Important Topics NDA Syllabus for EnglishSpotting Errors Comprehension Selecting Words Synonyms Antonyms Sentence Improvements Ordering of Words in a Sentence, etc. NDA Syllabus for PhysicsPhysical Properties and States of Matter, Mass, Weight, Volume, Density and Specific Gravity, the Principle of Archimedes, and the Pressure Barometer. Motion of objects, Velocity and Acceleration, Newton’s Laws of Motion, Force and Momentum, Parallelogram of Forces, Stability and Equilibrium of bodies, Gravitation, elementary ideas of work, Power and Energy. Effects of Heat, Measurement of Temperature and Heat, change of State and Latent Heat, Modes of transference of Heat. Sound waves and their properties, Simple musical instruments. Rectilinear propagation of Light, Reflection and refraction. Spherical mirrors and Lenses, Human Eye. Natural and Artificial Magnets, Properties of a Magnet, Earth as a Magnet. Static and Current Electricity, conductors and Nonconductors, Ohm’s Law, Simple Electrical Circuits, Heating, Lighting and Magnetic effects of Current, Measurement of Electrical Power, Primary and Secondary Cells, Use of X-Rays. General Principles in the working of the following: Simple Pendulum, Simple Pulleys, Siphon, Levers, Balloon, Pumps, Hydrometer, Pressure Cooker, Thermos Flask, Gramophone, Telegraphs, Telephone, Periscope, Telescope, Microscope, Mariner’s Compass; Lightening Conductors, Safety Fuses. NDA Syllabus for ChemistryPhysical and Chemical changes. Elements, Mixtures and Compounds, Symbols, Formulae and simple Chemical Equations, Law of Chemical Combination (excluding problems). Properties of Air and Water Preparation and Properties of Hydrogen, Oxygen, Nitrogen and carbon dioxide, Oxidation and Reduction. Acids, bases and salts. Carbon—different forms. Fertilizers—Natural and Artificial. Material used in the preparation of substances like Soap, Glass, Ink, Paper, Cement, Paints, Safety Matches and Gun-Powder. Elementary ideas about the structure of Atom, Atomic Equivalent and Molecular Weights, Valency NDA Syllabus for General ScienceThe difference between living and nonliving things. The basis of Life—cells, Protoplasms, and Tissues. Growth and Reproduction in Plants and Animals. Elementary knowledge of Human Body and its vital organs. Common Epidemics, their causes and prevention. Food is a source of Energy for man. Its constituents include a balanced Diet. The Solar System includes meteors, comets, and Eclipses. Eminent Scientists have achieved many achievements. NDA Syllabus for History, Freedom Movement etc.A broad survey of Indian History, with emphasis on Culture and Civilisation. Freedom Movement in India. Elementary study of Indian Constitution and Administration. Elementary knowledge of Five Year Plans of India. Panchayati Raj, Co-operatives and Community Development. Bhoodan, Sarvodaya, National Integration and Welfare State, Basic Teachings of Mahatma Gandhi. Forces shaping the modern world; Renaissance, Exploration and Discovery; War of American Independence. French Revolution, Industrial Revolution and Russian Revolution. Impact of Science and Technology on Society. Concept of one World, United Nations, Panchsheel, Democracy, Socialism and Communism. Role of India in the present world. NDA Syllabus for GeographyThe Earth, its shape and size. Lattitudes and Longitudes, Concept of time. International Date Line. Movements of Earth and their effects. Origin of Earth. Rocks and their classification; Weathering—Mechanical and Chemical, Earthquakes and Volcanoes. Ocean Currents and Tides Atmosphere and its composition; Temperature and Atmospheric Pressure, Planetary Winds, Cyclones and Anti-cyclones; Humidity; Condensation and Precipitation; Types of Climate, Major Natural regions of the World. Regional Geography of India—Climate, Natural vegetation. Mineral and Power resources; location and distribution of agricultural and Industrial activities. Important Sea ports and main sea, land and air routes of India. Main items of Imports and Exports of India. NDA Syllabus for Current EventsKnowledge of Important events that have happened in India in recent years. Current important world events. Prominent personalities—both Indian and International including those connected with cultural activities and sports
The NDA General Ability Test Syllabus 2024 is divided into two parts: English and General Knowledge. The NDA question paper in English will be designed to assess the candidate’s understanding of English and workmanlike use of words. The NDA English syllabus covers various aspects, such as Grammar and usage, vocabulary, comprehension, and cohesion in extended text, to assess the candidate’s proficiency in English.
The NDA General Knowledge syllabus will broadly cover the subjects, i.e. Physics, Chemistry, General Science, Social Studies, Geography and Current Events. Check the detailed NDA Syllabus 2024 for the General Ability Test shared below for reference.
NDA GAT Syllabus 2024 SubjectNDA Important Topics NDA Syllabus for EnglishSpotting Errors Comprehension Selecting Words Synonyms Antonyms Sentence Improvements Ordering of Words in a Sentence, etc. NDA Syllabus for PhysicsPhysical Properties and States of Matter, Mass, Weight, Volume, Density and Specific Gravity, the Principle of Archimedes, and the Pressure Barometer. Motion of objects, Velocity and Acceleration, Newton’s Laws of Motion, Force and Momentum, Parallelogram of Forces, Stability and Equilibrium of bodies, Gravitation, elementary ideas of work, Power and Energy. Effects of Heat, Measurement of Temperature and Heat, change of State and Latent Heat, Modes of transference of Heat. Sound waves and their properties, Simple musical instruments. Rectilinear propagation of Light, Reflection and refraction. Spherical mirrors and Lenses, Human Eye. Natural and Artificial Magnets, Properties of a Magnet, Earth as a Magnet. Static and Current Electricity, conductors and Nonconductors, Ohm’s Law, Simple Electrical Circuits, Heating, Lighting and Magnetic effects of Current, Measurement of Electrical Power, Primary and Secondary Cells, Use of X-Rays. General Principles in the working of the following: Simple Pendulum, Simple Pulleys, Siphon, Levers, Balloon, Pumps, Hydrometer, Pressure Cooker, Thermos Flask, Gramophone, Telegraphs, Telephone, Periscope, Telescope, Microscope, Mariner’s Compass; Lightening Conductors, Safety Fuses. NDA Syllabus for ChemistryPhysical and Chemical changes. Elements, Mixtures and Compounds, Symbols, Formulae and simple Chemical Equations, Law of Chemical Combination (excluding problems). Properties of Air and Water Preparation and Properties of Hydrogen, Oxygen, Nitrogen and carbon dioxide, Oxidation and Reduction. Acids, bases and salts. Carbon—different forms. Fertilizers—Natural and Artificial. Material used in the preparation of substances like Soap, Glass, Ink, Paper, Cement, Paints, Safety Matches and Gun-Powder. Elementary ideas about the structure of Atom, Atomic Equivalent and Molecular Weights, Valency NDA Syllabus for General ScienceThe difference between living and nonliving things. The basis of Life—cells, Protoplasms, and Tissues. Growth and Reproduction in Plants and Animals. Elementary knowledge of Human Body and its vital organs. Common Epidemics, their causes and prevention. Food is a source of Energy for man. Its constituents include a balanced Diet. The Solar System includes meteors, comets, and Eclipses. Eminent Scientists have achieved many achievements. NDA Syllabus for History, Freedom Movement etc.A broad survey of Indian History, with emphasis on Culture and Civilisation. Freedom Movement in India. Elementary study of Indian Constitution and Administration. Elementary knowledge of Five Year Plans of India. Panchayati Raj, Co-operatives and Community Development. Bhoodan, Sarvodaya, National Integration and Welfare State, Basic Teachings of Mahatma Gandhi. Forces shaping the modern world; Renaissance, Exploration and Discovery; War of American Independence. French Revolution, Industrial Revolution and Russian Revolution. Impact of Science and Technology on Society. Concept of one World, United Nations, Panchsheel, Democracy, Socialism and Communism. Role of India in the present world. NDA Syllabus for GeographyThe Earth, its shape and size. Lattitudes and Longitudes, Concept of time. International Date Line. Movements of Earth and their effects. Origin of Earth. Rocks and their classification; Weathering—Mechanical and Chemical, Earthquakes and Volcanoes. Ocean Currents and Tides Atmosphere and its composition; Temperature and Atmospheric Pressure, Planetary Winds, Cyclones and Anti-cyclones; Humidity; Condensation and Precipitation; Types of Climate, Major Natural regions of the World. Regional Geography of India—Climate, Natural vegetation. Mineral and Power resources; location and distribution of agricultural and Industrial activities. Important Sea ports and main sea, land and air routes of India. Main items of Imports and Exports of India. NDA Syllabus for Current EventsKnowledge of Important events that have happened in India in recent years. Current important world events. Prominent personalities—both Indian and International including those connected with cultural activities and sports

.

Goal Organizes header information efficiently, for easy access and manipulation within the code, regardless of columns appearing in a different order.
Strategy Using a class module HeaderInfo to store information about each header, such as its name, column letter, and column number. The InitializeHeaders subroutine in the class module initializes this information for each header in an array passed from the main module. The main module calls this subroutine for each worksheet to populate a collection called HeaderInfos. This collection stores instances of the HeaderInfo class for access to header information by name. The GetColumnInfo subroutine within the HeaderInfo class finds the column letter and number for a given header name in a specified worksheet.
Issue

1. Compile Error: ByRef Argument type mismatch

Assistance I'd be extremely appreciative if someone could provide a the working code. Or if that's too much work, guide me in the right direction. (I have little understanding of all this though)
Note I've intentionally forgone parts of the code related to other actions to shorten the code to save everyone time. However, I haven't been able to test this exact redacted version.
Standard Module

'Declarations: Option Explicit 'prevents using unnamed Public HeaderArray As Variant Public HeaderInfos As Collection Dim HeaderInfo As HeaderInfo Dim TargetDirectory As String Dim TargetBook As String Dim TargetFilePath As String Dim targetworkbook As Workbook Dim ws As Worksheet Dim wb As Workbook Dim LastCol As Long Dim LastCol_L As String Dim FLastCol As Long Dim FlastColLetter As String Dim lastrow As Long Dim AddHeaders As Variant Dim HeaderExists As Boolean Dim ColumnHeader As String Dim Cell As Range Dim y As Integer Dim c As Integer Dim columnnumber As Integer Dim columnletter As String Dim header As Variant Sub Reformat() Application.DisplayAlerts = False Set HeaderInfos = New Collection TargetDirectory = ActiveWorkbook.Path TargetBook = ActiveWorkbook.Name TargetFilePath = TargetDirectory & "\" & TargetBook Set targetworkbook = Workbooks.Open(TargetFilePath) 'Rename sheet to string variable (for date) Dim MonthName As String Dim NewSheetName As String MonthName = Format(DateSerial(Year(Date), Month(Date) - 1, 1), "mmmm yyyy") NewSheetName = "AUA " & MonthName Dim AUASheet As Worksheet Dim sheetExists As Boolean sheetExists = False For Each AUASheet In ActiveWorkbook.Worksheets If AUASheet.Name = NewSheetName Then sheetExists = True Exit For End If Next AUASheet If Not sheetExists And ActiveSheet.Name <> NewSheetName Then Dim originalName As String originalName = ActiveSheet.Name On Error Resume Next ActiveSheet.Name = NewSheetName If Err.Number <> 0 Then MsgBox "An error has occured. Name taken" ActiveSheet.Name = originalName End If On Error GoTo 0 End If targetworkbook.Sheets(NewSheetName).Activate Set ws = targetworkbook.Worksheets(NewSheetName) 'Find last column (Before the Addition of extra header columns) LastCol = ws.Cells(1, ws.Columns.count).End(xlToLeft).Column 'Add Additional Column Headers after last column AddHeaders = Array("Type of Product", "Prefix", "Category ") LastCol_L = Split(Cells(1, LastCol).Address, "$")(1) For Each header In AddHeaders HeaderExists = False For Each Cell In Range("A1:" & LastCol_L & "1") If Cell.value = header Then HeaderExists = True Exit For End If Next Cell If Not HeaderExists Then Cells(1, LastCol + 1).value = header LastCol = LastCol + 1 End If Next header 'Find new last column after additional header columns included FLastCol = ws.Cells(1, ws.Columns.count).End(xlToLeft).Column FlastColLetter = Split(ws.Cells(1, FLastCol).Address, "$")(1) HeaderArray = Array("% Header 1", "abc 123", "Product Type", "test") 'demo only Debug.Print TypeName(HeaderArray) 'Call InitializeHeaders Dim HeaderInfoInstance As HeaderInfo Set HeaderInfoInstance = New HeaderInfo HeaderInfoInstance.InitializeHeaders ws, HeaderArray 'This is where my error starts (I think) 'Testing On Error Resume Next Debug.Print "Added: " & HeaderInfo.HeaderName & " ColLetter: " & HeaderInfo.HeaderColLetter & " ColNumber: " & HeaderInfo.HeaderColNumber Debug.Print ws.Range(HeaderInfos("IACode").HeaderColLetter & "2:" & HeaderInfos("IACode").HeaderColLetter & "10").Address Debug.Print ws.Range(HeaderInfos("TotalAssets").HeaderColLetter & "2:" & HeaderInfos("TotalAssets").HeaderColLetter & "10").Address On Error GoTo 0 'Find last row lastrow = ws.Cells(ws.Rows.count, "H").End(xlUp).Row ActiveWorkbook.Save ErrorHandler: MsgBox "An error has occured: " & Err.Description, vbCritical End Sub 

Class Module named: HeaderInfo

Option Explicit Public HeaderName As String Public HeaderColLetter As String Public HeaderColNumber As Long Public Sub Initialize(HeaderName As String) Me.HeaderName = Replace(Replace(HeaderName, " ", ""), "%", "Percent") Me.HeaderColLetter = Me.HeaderName & "_Col" Me.HeaderColNumber = Me.HeaderName & "_ColNum" Debug.Print "HeaderName: " & Me.HeaderName Debug.Print "ColLetter: " & Me.HeaderColLetter Debug.Print "ColNumber: " & Me.HeaderColNumber End Sub Public Sub GetColumnInfo(ColumnHeader As String, ws As Worksheet) Dim ColumnHeaderRange As Range Dim FoundColumnHeader As Range Dim FLastCol As Long FLastCol = ws.Cells(1, ws.Columns.count).End(xlToLeft).Column Set ColumnHeaderRange = ws.Range("A1:" & ws.Cells(1, FLastCol).Address) Set FoundColumnHeader = ColumnHeaderRange.Find(ColumnHeader, LookIn:=xlValues) If Not FoundColumnHeader Is Nothing Then Me.HeaderColNumber = FoundColumnHeader.Column Me.HeaderColLetter = Split(FoundColumnHeader.Address(True, False), "$")(1) Else Me.HeaderColNumber = -1 Me.HeaderColLetter = "" End If Set ColumnHeaderRange = Nothing Set FoundColumnHeader = Nothing End Sub Sub InitializeHeaders(ws As Worksheet, HeaderArray As Variant) Dim c As Integer If IsArray(HeaderArray) Then For c = LBound(HeaderArray) To UBound(HeaderArray) Me.Initialize HeaderArray(c) Me.GetColumnInfo HeaderArray(c), ws Debug.Print HeaderArray(c) Next c Else MsgBox "HeaderArray is not an array." End If 'Test Debug.Print "Added: " & HeaderInfo.HeaderName & " ColLetter: " & HeaderInfo.HeaderColLetter & " ColNumber: " & HeaderInfo.HeaderColNumber End Sub 

Thank you everyone!

Hi everyone! Just wanted some friendly advice. I currently am working as an elementary school teacher and realized I don't want to teach as a career. I found it not as fulfilling as I had wanted it to be and am no longer happy with where I am. I haven't done much volunteering due to burnout from teaching, but I hope to get more hours completed now that summer break is starting. I also intend to do some shadowing hours as well. I've also been looking into medical scribe postitions to get some clinical experience.
I had always been interested in medicine but was always worried I was never smart enough for it and that it's too late (I'm 25). While in undergrad I had considered nursing and started that path. I took Gen Chem 1 and 2 both with labs. I completed Physics 1 with lab and Biology of Cells and Organisms and Biology of Populations and Communities also both with labs. I excelled in these classes and completed them with very high A's. I had done two years of Engineering prior to switching my major to Psychology with a minor in Math. I graduated with a GPA of 3.54. I also did research for 2 years and was published for helping the lab I worked in.
Now here's the kicker, I graduated in December 2021 and I would be on my 3rd/4th gap year (by the time I finish applying). Since I have some pre-med courses under my belt would it be better for me to do a DIY or just start over in a formal post-bacc program considering the very long gap? Im worried formal programs would reject me because of the classes I took a while back.
Any advice would be appreciated. Thank you! :)