noobie

Hi, I am fairly new to VBA and I need to quickly construct a simple userform for work. To put it simply, I have a list of items each with corresponding price (2 groups, one group is a subset of the other group of major items), I would like to construct a userform where the user can use a...

Hi all - I have the below code to copy a set of row data from one tab and paste/transpose when a Command Button is clicked on a second tab. How do I edit this so that every time the Command Button is clicked, the data is pasted to the right on the first blank row? Currently, when it's clicked...

Hi all - I've got the below code to copy column data when a Command Button is pressed and paste/transpose on a different tab. Each time the button is pressed, the data is pasted on the next subsequent row. Is there a way to paste/transpose the data but keep the original cell formatting where...

Hi everybody. I'm having issues with setting up multiple drop-down boxes to auto-complete with a set list of data values. I've got two tabs that have multiple drop-down boxes utilizing the same data values from a third tab. Because some of the drop-downs have multiple selections (Country for...

Hi everybody.. I'm looking for help to update the below code to transpose data from Column format to Row format. I have the below code (thanks Yongle for your help!) that copy values in a set of column cells when a button is pressed and pastes those values onto another tab. If the user...

Hi, I'm having trouble with the following question. Any help is very much appreciated. Write a loop that sums the first 10 terms for the two series below? ∞ Σ1/n n=1 ............................. ∞ Σ1/n^2 n=1

Hi Guys, I need a program that can read multiple columns from multiple spreadsheets and carries out an action if it matches. I believe though the problem is a bit too complex for vlookup! I need a vba macro that can read the a common column from two spreadsheets to see if they match. Then...

I can't seem to make an Append Query do what I want...any help will be appreciated! I need to append records to a table called "tbl_6A_POP" from a table called "tbl_Media_Code". tbl_Media_Code has 7 records ("1000" thu "6000" plus "6500" in a field called "Media_Code"). tbl_6A_POP already has...

I am trying to get my Excel sheet to search a specific column for text, if it finds the correct text I would like for it to search a second column for more specific text. If the text is found in both columns I would like the row it was found in to be copied to a specified sheet. I have a ton of...

So I'm super new to VBA :eeek: (hey but I'm learning!) The goal of the code that I'm writing is to create a simple database to track new corporate accounts and sales based on office location. (So nothing fancy). However, as the user fills out the user form, it only fills out the first now...

Hi fellow Excel users, I have only recently begun dabbling in the way of freezing cells in excel. I have this conondrum which is accordingly... and here I wish I could share some pictures with you, but only being able to share picture HYPERLINKS limits my availability. The conondrum is that I...

Hi, At work we have a Rota as people work on shift patterns and then I have to look at the rota and complete a separate spreadsheet basically translating the rota in numbers for a monthly total (in hours) This is extremely boring and time consuming and I have been trying to work out the right...

So I have a very simple problem, but when I search on how to do it, it seems the code I have been seeing are longer than it's suppose to be? So here's my problem Everyday Column A generates a different set of numbers. What I need is to count all the cell and input the total on the last cell...

I've been searching all forums related to my question for quite some time and I cant seent to find the answer. I have an undetermined amount of worksheets. All worksheets are formated exactly the same. Each worksheet has a list of questions (33 of them) with Yes, No and N/A answers as a drop...

i need help on 2 lines of code Sub sendemail(subject_line As String, mail_body As String) Dim olapp As Outlook.Application Set olapp = CreateObject("outlook.application") Dim olMail As Outlook.MailItem setolmail = olapp.CreateItem(olMailItem) olMail.To =...

I'm a new member to the site and need some help with a few things. I am relatively new to excel and thought that this might be a good place to start. I have made a set of pivot tables and want one slicer to control them both, I have tried using the pivot table connections option that is...

Pretty new to excel so bear with me. Have to complete a table that responds to different values. I have a basic formula that is: =B18/B16*60 and i want it to be able to change in response to another cell and look like =(B18/B16*60)*B19. However I want B19 to be left as zero without making the...

Hi everyone, I'm constantly updating a list of clients on excel manually, this takes a lot of time and is utterly, utterly dull. I was hoping some one could help me with a macro that would take care of this? (Would it be practical if I could just copy and paste a bunch of names into a...