grid

Hello All, I want to do my excel file comes in user form as in Grid view control. Can anyone help me to do such activity? I have tried but I faced the issue. Below code, I have done. Private Sub UserForm_Activate() UserForm1.ListBox1.ColumnCount = 14 UserForm1.ListBox1.RowSource =...

I have a list of x and y values for a 600x600 coordinate plane. I want the plane divided up into 9 equal grids (200x200). Is there a formula to return which grid the x,y coordinate exists in? As of now, I think I can do it using several IF AND formulas in multiple cells. (ie. IF (A2>0 AND...

Hello, I am trying to get at some cross buying behavior from a large data set that I have. Here is simple, example of the Pivot Table I have put together so far: <tbody> Brand A Brand B Brand C Brand D John 1 2 Mark 1 Amy 1 1 </tbody> Essentially I am trying to put together a...

Hi, I'm trying to create an interactive databook. I'm needing to represent the percentage ranges below with the grid number associated with them - and then to have the combination of the two numbers that represent a point on the grid with a corresponding colour. The objective of the databook is...

Any one can help me create a vba function with excel IF, INDEX, MATCH function as follows ; =IF(INDEX(Grid!$B$3:$G$6,MATCH('Sal-Data'!$A2,Grid!$A$3:$A$6,0),MATCH('Sal-Data'!$B2+1,Grid!$B$2:$G$2,0))=0,$B2,$B2+1) You can call function as NGrid. Function NGrid (....... ) code ........... '...

Hi, I'm searching a free grid control to display some database date in Excel VBA form. I've tried Spreadsheet11 but i get some errors if i want to run VBA on other system (with all the controls proper registered). To many problems... I give up. So, I want to ask you if is possible to find a...

Hello, I use a gantt-like grid I created in Excel to schedule our production team. What I'm trying to do is to lookup the job that is listed on the grid and populate the table with the employee name and date so that I can print off a schedule for each employee. The left column has the name of...

Hello, I have a simple grid where the rows are people and columns are weeks. There are formulas in the grid that count how many audits a given person has done in a given week and I've conditionally formatted the cells to turn green when the cell is >= 1. I've been asked specifically to put a...

Afternoon all stuck again if some can help me out, I have a userform with several text boxes on it ie a 7 x 3 grid I want to be able to populate the contents depending upon a variable for example if I have var = 3 string1 = "part1" string2 = "part2" so this would populate row 3 on my grid...

Hi I have a computer and when I open excel file, sheet does not have grid lines. I went to View tab and Grid View box is checked. When I high light a group of cells using the mouse I barely see the grid lines in this highlighted area. What could be the issue? I created boarder no problems but I...

Hi All, I am trying to create a Macro that would show all of the possible combinations of Red and Green. Blue would stay the same. (0) It should end being a grid of 256 x 256 or 65,536 I tried the code below and I get the first column, but the next step just goes across row 1. Please help...

I'm an after-school educational assistant working with young kids with a focus on math. If I can figure out how to get this to work in Excel (Using the 2016 version), I'll be using these puzzles on a yearly basis (switching from addition/subtraction to multiplication/division ect.) Anyway, the...

Here's the scenario: You have 1,2,3,...N tasks to do sequentially, all which take a range of time to complete (column constraint), but you're only allowed to set aside a certain amount of time on each of M days (row constraint) to complete these tasks. Example: You have a 5 chapter book to...

I'm trying to look up rates based off of weight and miles. <tbody> Weight Miles 500 1000 1500 2000 250 4.5 6.5 8.5 10.5 500 7.5 9.5 11.5 13.5 750 12.5 14.5 16.5 18.5 </tbody> I have a cell where I type in the weight and another cell where I type in the miles. I want the 3rd...

<tbody> 13 3/11/2016 14 4/11/2016 15 5/11/2016 16 6/11/2016 17 7/11/2016 12 2/11/2016 3 24/10/2016 4 25/10/2016 5 26/10/2016 18 8/1111/2016 11 1/11/2016 2 23/10/2016 1 22/10/2016 6 27/10/2016 19 9/11/2016 10 31/10/2016 9 30/10/2016 8 29/10/2016 7 28/10/2016 20...

For a table like this; <tbody> Width Drop 1000 1200 1400 1600 1800 2000 1000 £5 £10 £15 £20 £25 £30 1500 £10 £15 £20 £25 £30 £35 2000 £15 £20 £25 £30 £35 £40 </tbody> How could I type in a width x drop and return a price eg: Width Drop Price 1050 1300 £15

Hi everyone, I am a locksmith and i am working on a new database for my lockshop to catalog our keys and our bitting system. I want to create a dashboard to find the bittings for our keys much easier. When we create the key systems we use grids. On the vertical access would be cuts 1 and 2...

Hi All, First time poster and am really stuck on getting a solution for the following: I have an excel sheet that needs exporting into MYSQL. This sheet contains a grid with the rows being components and columns being products. Column A holds the component name with columns b onwards using row...

I found this great, simple, code online that inserts images into a spreadsheet. The only problem is that the code inserts the images down a column or across a row. I'd like to insert images in a grid (2x2 or 3x3 per page for example) so that when I print it creates a nice report. I have...

Hello All - This is my first post. I'm in way over my head on a project and came across this forum in my search for a clue. I have a couple of lists of locations (MSAs and airports) with lat/lon and a getdist VB script. I'm able to calculate the distances (miles) one column at a time but I'd...