grid

hi, i have attached a link to a source file that shows an example of what I'm aiming to do. Basically a 4 box grid exists. If a person in the list below is given a number between 1 and 4 a 'dot' shows up on the grid? thank...

Hi, Thanks in advance for looking to help me. I have 5 lists: Animals, Food, Places, Names and Drinks there are 20 things in each list. I need to populate a 5 x 5 grid with random selections from these lists - but there can be no duplicates. Column 1 on the 5x5 grid needs to pick from the...

I received an excel gantt chart to work with. It displays item #, task name, start date and end date. At the end is a gantt chart showing horizontal bar graphs. It had horizontal ghosted grid lines visible. Vertical grid lines were not visible. I began populating the sheet and decided to...

Picture this - I want to be able to create a (...non-VBA solution would be preferred...) table of X- and Y-coordinates based on user input for up to a 5x5 grid. The user enters the number of rows (say 2) and then the spacing between each. They do the same thing for number of columns (say 3) with...

Hi guys, I am working with a rota and there is a grid with all the data with names across Row 6 and the dates of the year down Column A. In the grid are all sorts of entries, with "Off", "Holiday" etc but all shifts are written in the form "7am-6pm". I am looking to clear all the cells of...

Hi there, I have a problem that I seek assistance with. I use a commercial database called Case Manager. It's a data centre for health and invoicing information on my clients. The database is set up in viewing grids that I can set up manually. I.e if I want to see the Worker First and last name...

Hi, I have spreadsheets that have multiple readings in. The data can be 500 readings across (columns) by 500 down (rows). Basically a large square of thickness readings. Sometimes it can be even larger. I want to be able to get a minimum reading quickly from say every 25x25 grid of data and...

Hi Everyone, I am currently looking for a way to have it so when a manager is working with an employee on their development plan they are able to have a quick way to plot multiple employees on to a 9 box grid with the click of a single macro. Both the performance and potential rating scale from...

Hi, can anyone help with User Form VBA? I have Data on Sheets 7, 8 & 9 that I want to copy into a grid on Sheet2 when the User Form meets a certain criteria I have built the User Form with the toolbox functions as follows CommandButton1 ComboBox1 with Sheet7 Sheet8 Sheet9 ListBox1 with 0 1...

Hi there I have a 9 box grid, each box has a value 1 to 9. I want each box to highlight its value if conditions are met in other cells. Example. 1. If 'A' <1.49 AND 'B' <1.49 then I want box 1 in the 9 box grid to show value '1'. 2. If 'A' >2.5 AND 'B' >2.5 then I want box 9 in the 9 box grid...

Greetings, guys. May I impose to ask for help on a personal project, please? I've got a small 5x7 grid of cells in a spreadsheet that I use to edit fonts for an OLED display. Basically, I put a null or a 1 value in each cell (the cell color changes to black for a 1) and I use the resulting...

Hello, I have been searching the internet , but unable to find the answer... I have a sharepoint list which displays perfectly in Standard view, if i try and switch to Datasheet view , I just get a blank grid. I have asked colleagues to try and they get the normal excel/access grid format...

if all 4 qtr is >= 100 then 20000 , if any 3 qtr > 100 and anl > 105 ach% , then 20000 after matching col1 and col2 with the grid <tbody> grid col1 AA A B C ANL XX 25000 20000 16500 13000 105 YY 20000 17000 14500 12000 110 data col1 col2 QTR1 QTR2 QTR3...

I have a grid and I know the costs of the item, in all of the four corners I want excel to calculate the mean averages & fill in the other cells

Hi, Do you have any solution for removing a grid from an area for example. From B16 : E16 to B20 : E20 Morten

I have a row of data with numbers say 101 thru 125 that goes from D5:T5. in the row beneath there will be a 3 letter acronyms in each cell below each number. They will be one of these..... FBI,FBA,CPA, or CPI. I need to go thru the grid and find all the cells with FBI and put the number it...

Hi everyone Im almost a newbie On Sheet1, I have a list of names in column A1 : A100. I would like to put these names into an array and on Sheet2, populate a grid at A1. I also need a message box to pop up to query the dimensions before populating the grid (5x5, 8x10, 8x12, etc) Im trying...

Dear Friends, I tried to make am excel sheet with a 3 x 3 Grid where If I put an integer in the cell " A1 ", for eg. 7, then the grid i.e. B1,C1,D1 & B2,C2,D2 & B3,C3,D3 will be filled in such a way that all the rows & colmuns in the grid will sum exactly as the number in the cell " A1 "...

Below is the link to the file I am trying to use (one Sheet is value-only) https://drive.google.com/open?id=1cdRPGcB48PHmPJu5C-FmNYhqoImoCuoZ I am trying to copy the first cell with a value on 'FBE Graph' Column B to 'FBE Graph' Cell I10 then copy 'FBE Graph' Cells I14:I32 to 'Summary'...

i have xy-direction values which i want to plot in Excel Chart with Graph Grid is it possible to draw something on Graph Chart? can it be Perfectly Matched with the Reference of cell? Iam eagerly waiting for this answer Thank you in Advance