information

Hi, I need prepare offer form. In Sheet 2 i have database with all products and full information about them in row. In sheet1 i have offer(proposal) form. So i trying to make such form, that you can select specific product in Sheet 2 using checkbox and that product with full information which...

Is there anyway i can populate a new page to show some kind of filtered information based on whether a series of cells are populated yes or no. I want to have a list of cells that each have the option "yes" or "no". I then want to be able to run a macro or some kind of automation where it...

Greetings everyone, I've recently started programming with VBA outside of UserForms and directly on the worksheets. I'm struggling however with populating a TextBox based on ListBox.Click. Let's say for instance my ListBox is filled with all the information from Worksheet 1, column A and I...

Hello all, I have very little experience with macros/VBA, and I need some help with extracting specific text from a large .txt file into excel. (I know similar things have been asked before but I have not been able to find code that I could use for my purpose.) The "txt" file I have contains...

I have some folks who need to consolidate information spread across 1000 of spreadsheets into one master sheet. I could write a vba solution for some of the workbooks but they are all in different formats and have different information. Therefore, they are copying and pasting the information...

Hi, Searching for help to automatically fill missing information in column E where cells in column D match: <colgroup><col><col></colgroup><tbody> Control Number Control 50071879 50071879 50071879 50071879 Critical Spares for Girth Gear 50071879 50071879 50071879...

Hi all! In a worksheet where there are several pages active in Page Break View, is it possible to deactivate any of them even though there is information on them? Thank you! Russ

OK I am trying to build a leave tracking for my organisation. I want the the tracking tab to obtain its information for the month from the leave planning tab. This information is entered as letters. The countifs function gives me an error, the countif means I have to copy and paste this formula...

So i have a question about "allow edit ranges". I Just learned how to use it but i wanted to know if there is a way to paste information in the cell. To be more clear, I have a B:B under the allow edit ranges as well as L:L. But I have others copied information and pasting in the same workbook...

Hi All, I have a dilemma. At workplace we are updating to Win10 and I have to transfer some data from OneNote to Excel. We have employee files setup like navigation menu. I searched forum but I am not even sure what I am looking for. It would be much easier for me to make website and input...

This macro has me stumped. I have a column of information in Workbook "A", Worksheet 1, Column "C" AND I have a column of information in Workbook "B", Worksheet 1, Column "D" which correspond with one another. I would like to read-in the cell.Value For each cell in Range("C:C") of workbook A...

I'm trying to list both Student and Faculty information using the Union operator. This is what I have so far: SELECT FacNo, FacFirstName, FacLastName From Faculty UNION Select StdNo, stdFirstName, stdLastName From Student; When I ran it, all that displayed was the Faculty information. Should I...

My present coding moves information completed on a UserForm to a Spreadsheet. Individuals may need to update the information submitted so if they submit another form, I require a search to happen by the PRI number and replace the old information with the new information. For example.... If the...

Hello everyone, Pretty much new here and in VBA. I am working on a internship project that just consumes too much of my time (please dont think I am trying to escape the task which I don't I am just looking for a better and efficient way of doing this monthly routine). On a monthly basis I get...

Hello! I have a worksheet where Columns A:Z are used. I would like to take all rows on sheet 1 where Column E has a value of "2" AND Column J has a value of "Example", and copy the information from the Entire Row to sheet 2. Row 1 on sheet 1 is just header information. I would also like this on...

I have 25 information cells, in a separate cell it will tell me which box to get my information from. I want a formula in another box to show the information from that cell. If cell A says 10, I want cell B to show the information in cell 10; if it says 25 in cell A then I want box B to show...

i am wanting to create quite a complex league table within a spreadsheet i have. The first part is that i want the user to be able to select which league table they want to show. i am planning on having 2 drop downs. the first drop down will contain two options. New and Used. once the user has...

Hi all, wondering if there is a way to extract all the information of a selected pivot table cell (powerpivot) with VBA and copy over to a new sheet. I would like to scroll down a pivot table, select cells, click the button (run code) and it will copy over the information to a new sheet and...

I have this as my VLookup formula: =VLOOKUP($B24,'Reference Tables'!$A$2:$B$100,2,FALSE) B24 ends up pulling the formula result of "4" as this cell is a formula itself which is this: =IFS(LEN('Q-Tools Data'!$A2)=12,LEFT('Q-Tools Data'!$A2,1),LEN('Q-Tools Data'!$A2)=13,LEFT('Q-Tools...