data selection

Hi guys, Is it possible to achieve the following in excel: I select cell A1, which has a specific reference number. This cell/number corresponds to B1:K1 data set. Similarly, A2 corresponds to B2:K2 data set, and so on. Separately, there is a formula in cell M1, which uses the data set based...

I have a long list of items names on A column, the items are for rental purposes, and in order to keep track of its rent history, the item returned will have a returned date on the R column, and have strikethrough. But then a new row of the returned item will be added to indicate that it's open...

Hi all, I've been trying to wrack my brain around trying to sort this code out. At the minute, the macro runs fine but it's based on a set range between B2:B15000 which is a lot! However, I wanted to make sure that the macro would cover everything. I was wondering if there was a way to make it...

I'm trying to write a formula that will perform a calculation based on several inputs that are selected on a "data input" tab in my workbook. I have a tab with many tables that are differentiated mainly by race and gender. I have drop-down lists that allow the user to select "Male" or "Female"...

Hi Team, I'm looking for the below requirement can anyone help on this... <colgroup><col><col><col span="2"></colgroup><tbody> Name Date Sales1 Sales2 Daniel 01/18/11 4,907.00 2,038.00 Daniel 12/23/11 3,527.00 2,985.00 Daniel 05/14/12 1,495.00 1,529.00 Daniel...

<colgroup><col><col><col></colgroup><tbody> Power (kW) Head (m) Mass Flow (kg/s) 51.58 30.00 206.1922 92.2492 30.00 401.8627 62.2747 30.00 243.2216 83.2188 30.00 325.0214 42.074 30.00 174.3451 36.3087 30.00 154.2164 48.1465 30.00 194.7579 31.211 30.00 135.9637 56.457 30.00...

Hey guys, I'm very new to vba, so I might be asking a stupid or obvious quesitons. However any help would be greatly appreciated. The task assigned to me is to format the data dump from a program to match excel entry format. I'm trying to keep only the first 10 characters in each entry...