choose

Hi everybody, I'm looking for a code, where I can specify who to send an email to and choose an attachment for it. I have to send every month 20 excel files to the same 20 recipients but always different excel files for the ongoing month. That is why I would like to create a button for each...

So I have had this idea regarding Excel and never have the time to complete it. I figured I would share the idea should someone have the time to. Think of the Game of Life board game. In which I can have my 16-20 use to understand money. First it would give the option of College or Career. If...

Is there a way to make a perfect circle with numbers in excel? Lets say if I choose 40 numbers, from 1 - 40 numbers will be arranged in a perfect circle in an excel sheet. I mean the distances between numbers should be same and all. and if I choose 60 numbers, it will be a little bigger circle...

How do I use vba to look down a column of dates and if any dates = a Friday choose that date, if not choose most recent date.

I have a table with 8 columns and I am trying to create a drop down menu that will return an integer from locums A,C,E,G when I choose text from columns B,D,F,H respectfully. If I choose: Text 1 (from column B) It returns: "1" If Text 3 (From column D) Returns: "5" Is there a way to use IFS()...

hi everyone, need little help here i have 2 dropdwon list, each list represents the name of my sheets. i want to sum value at the same cell of my sheets by choose it with my dropdownlist. so, when i choose sheet #1 and sheet #3 it will sum value at cell A1 from sheet #1 , sheet #2 , and...

hi want to choose rows between 2 variables. get syntax error Rows(r1:d2).Select

Hello all, Just registered but been using the forum as a major help resource but now I need help :confused: Setup: First of all, I'm relatively new to VBE but done quite a bit. I've built a UserForm utilizing a Combobox (ComboBox1) to choose one of 12 worksheets (Months) to enter the values...

This is probably not possible, I am on a Mac with multiple versions of MS Excel (including the latest version). I am trying to move the content of cells up into the blank cells based on a range of selection. I know I can select a range and then press F5 and choose "Special..." and choose the...

Hello, I am hopeful someone will be able to help me with the problem outlined below. I have 2 tables. One table has sales reps and the number of hours in a week they work. <tbody> Rep Weekly Hours Capacity How many hours left? John 38 2 Mary 37 3 Sue 39 1 Bob 40 0 </tbody> My...

Hi I have more than 10 different list with different categories for example I have a cosmetic shop with different Goods and colors powder 4 colors 206-207-208-209 lipstick 8 colors 301-302-...-308 foundation 6 colors 501-501-...-506 and I have more than 20 goods my question is how can I...

Hi Everyone, I need a macro to do the following when run a message box pops up saying "please choose the file you wish to import" then in some way give them the option to choose from the files in this folder: "F:\My Docs1\Monthly Data" When they choose the file open it copy sheet1 and past it...

Hi guys! I've been searchig for hours and cannot get answer how to do it.. I like VBA that ask me to choose folder and than Imports all contents of all TXT files to one sheet. best regards W.

Hello, I am trying to create a spreadsheet for people who are not that familiar with excel, if at all. I am trying to create a macro that would give them a list of available selections in the filter to choose from and then action their selection. Anyone have any suggestions? THANKS in...

Hi. I've found some macros that nearly do what I want, but my non-existent vba knowledge means I cannot edit them to do what I want. I have a worksheet that I want to duplicate onto new sheets and I want the tabs to be named after sequential dates. eg tab 1 would be "template", tab 2 would be...

We are using Excel for training documentation. When the person being trained completes a training session, he/she will print out the sheet for documentation that they have had the training referenced in the sheet. The person responsible for training, then files the sheet away for future...

https://imgur.com/5GlXgm2 Assuming I have my list of cars in column A. I choose a certain type of cars in column C, would it then be possible to generate a list of the remaining cars in column E, which I did not choose? I found something like this...

Hi there, I am stuck and maybe VLOOKUP is not the way to go at all but here is what I am trying to do. I have a column where uses paste data ex: HP LaserJet 4014n Printer I want to update this data with the Correct Product name from a different tab in the sheet. Table_Array 'Price List Jan...

Hi all, I have been having a play around with the 3D Maps function in Excel and it is doing what I want it to in terms of visualisation. It is feeding from a table which will update with different values depending on a location that I choose from a drop-down box. All of this is done on a...

Hello All, I wanna add six numbers in a column. There will be a maximum of nine numbers to choose what to add from. Before, I used the =Sum(Small(..... Function. But now I want to add them by taking the first four numbers then look for the two smallest numbers from the remaining five...