main

Hi Everyone, Here i am trying to calculate the value based on the headers which are in the "sum" sheet and their names will only be A,B,C......, and my inputs are in "main" sheet but in my input those columns will be renamed as Sum of A,Sum of B,Sum of C..........., and my preferred output...

Hi all, I'm after some suggestions. I am currently putting a worksheet together at work that will show various bits of data. Some data is pulled onto the main sheet from a hidden sheet when I put their employee ID into a cell. If their telephone number is stored on the hidden sheet it will...

Hello everyone, I've been doing some research lately on this forums threads seeing if I can find a solution that is similar to the situation I'm in, but have found that while some come close, they weren't necessarily the fix I was looking for. I have a workbook where I'm forced to distribute...

Hi I've got a Sub which runs successfully until the point where a formula needs to be dragged down to the rest of the column. In short, data is copied from column H (cell 15 downwards) in the "Main Sheet" of a file called "Main Sheet" and pasted into cell DC15 of the same sheet. The code...

I have added a subform to the main form so I could have some controls on the main form and the datasheet view on the subform. When I first open the main form I can edit in the subform datasheet without a problem. But if I execute the combo box "cboJobNumber" from the main form to search for a...

I need some formulas to extract a certain part of the text from the main cell. I just can't think of a logical way to do that because using Left and Right will not work as the texts differ in lenght. https://ibb.co/cv3NQxx The columns B, C, D and E should give those small extracts from the...

I have a folder I’m importing monthly files from. I will have the main table be my “2019 Total Sales Data” table. However, I’m wanting to break that same data out by month (Jan, Feb, Mar.... tabs at the bottom). I know that I could just duplicate the main query 12 times (giving me 13 total...

I'm trying to use a =Sumproduct and getting a #VALUE error in Google Sheets. Here is the formula that I'm using. =sumproduct(--($B$102:$B$255=A14),(right($C$102:$C$255,2))="AT",A$102:$D$255) When I use that formula in my main table (positioned at E14), I get the error. When I place the...

I am having issues with this string of code: Sub Format_Workbook_Pt2() Sub ConvertTextToNumber() Sheets("All_Data").Select Range("C:C").Select Selection.TextToColumns _ Destination:=Range("A:A"), _ DataType:=xlDelimited End Sub End Sub I...

Hello! :) I have a large main macro. I would like for the very first thing it does is to call a custom msg box that will ask the user whether or not they wish to exit the macro, or if they wish to continue. If they wish to exit, I need to exit out of the custom msgbox sub AND also out of the...

Good afternoon - I am attempting to create a spreadsheet that will have 4 different summation columns to it. The amount of columns between the four main will vary depending on the amount of tabs in the workbook. The four main columns will be summing information from the feeder columns that are...

Good afternoon - I am attempting to create a spreadsheet that will have 4 different summation columns to it. The amount of columns between the four main will vary depending on the amount of tabs in the workbook. The four main columns will be summing information from the feeder columns that are...

So I have a main sheet where I enter all the data and it asks how many receipts I want printed The receipts are in another workbook. How do I update the receipt workbook with the new data entered in the main sheet automatically

i have 2 files Main.xlsm Database.xlsx What i want to do its on Main workbook open, open Database.xlsx and copy it to a sheet in Main called "exceptions" and then close Database.xlsx Im currently opening Database with: Workbooks.Open (ActiveWorkbook.Path & "\Database.xlsx") As its in the same...

Hi all, So I've started working with VBA a bit and have figured out what I'd like to do and that it is possible, I'm just not skilled enough to be able to write it from scratch. I've always found it easier for me to work with existing code and learn what everything does by modifying parts of it...

I cannot determine how to show my main toolbar. I can see my add-ins toolbar but not the original toolbar. Help is appreciated. I tried CRTL+F1 but all I get is a help screen. Thanks,

I have a workbook with 3-4 sheets. I havecreated a registration and a login userform. The registration userformconsists of a Reference number, Full Name, address, email, phone, etc. andallows each user to create a username and password for logging in later. Once registered, ALL of their...

Hi I have 2 payroll tables MAIN and MGMT. They both have dates and are linked to a common calendar table. I would like to know the first date you were paid from both tables. You could only show up on the MAIN or MGMT or both. Is this possible? thanks

Hi, Below is my macro, basically inside Do Loop are a set of macro that opens a file, copy a sheet to another excel file. all i want is if i dont have a file to upload to my new excel, i just want to return to my main file without being prompted by the Run Time error pop up. please help Sub...

Hello, I need help to update Main sheets from other Sheets Example Main Sheet <tbody> Emp ID Name Gross Salary Tax Net Salay </tbody> Sheet1(Jul-19) How will automatically Emp ID & Name updated in Main Sheet <tbody> Emp ID Name Gross Salary Tax Net Salary 01...