excel table

I have tried the following code to apply Table Style within the same Workbook, and it works fine: ActiveSheet.ListObjects(ActiveCell.ListObject.Name).TableStyle = "Table Style 1" However, when I am trying to apply the same style to a table in a different Workbook, it's not working. This is the...

Hi I am trying to add icons and colours to a table column based on values in adjacent columns. I am trying to do this with VBA as that seems the only way to do it. Basically In the table below, I want the column MilestoneA to be colored as per the column MilestoneA-RAG values and also contain...

Hi Guys, I have an Excel table with some formula columns. In that columns, the value of some cells is calculated by formula and some rigid contents as text. I want to update the base formula for the new lines. For the current cells I am doing a is formula test and update them manually, but for...

I have to edit a table containing my product items in such a way it only shows boundaries till the values i have entered . E.g I have set max no of rows i.e items as 10 for my invoice table and given them boundaries . Now it is not necessary that in every bill I have all the items ,for the...

I have an excel table that is built from data referenced data from other tables. i.e. sheet 1 table 1 =a1 =a2 sheet 2 table 2 bob jan if i add "stu" to the bottom of table 2 it expands but table 1 doesn't pic up the reference. Is there a way to automate that so i don't have to expand table 1...

Hello. I'm working with a workbook that connects to an external data source (table in excel) when opened. Most of the data from the external table consists of 6 numerical digits. However, some cells have alphanumeric cells which is the 6 digits followed by a single letter. The data connection...

I have an Excel table, where for a few different columns I have conditional formatting turning some cells to appear in bold red text. If I only did this on one column, I could then run a filter on the color, and it would eliminate the records that don't have that color-- but it only works on...

I have an excel spreadsheet (Excel 2010) that has 3 columns, and approximately 59,900 rows. It's been sorted and duplicates (all 3 columns) removed. I would like to use the Microsoft Fuzzy Lookup tool to match one or more columns to one or more columns in another worksheet. The other...

Hello you Wonderful People, Can somebody please tell me (the VBA) how I could remove/hide some of the filter/sort arrows in the header of an excel table while keeping others - so users would still be able to sort the whole data range within the table using only the visible arrows? My table...

Hello, I am trying to create this spreadsheet and am stuck with multiple conditions in a data validation list. The Excel attachment is pretty self-explanatory. I am unsure of how to implement this correctly. https://db.tt/EUsu5gcX - Dropbox direct Excel file download -Edit - Forgot to...

Hi Excuse my ignorance. Not really great with VBA... hoping someone who is might be able to help me. I have a macro that is in an existing workbook, which allows the user to select an excel file for import and then refreshes the data table that exists in the workbook. There are pivot charts...

I'm trying to map out pathways within my data set. I have 2 stages of what can happen and where so I'm running a countif function that looks at location 1, what happened at location 1, location 2, what happened at location 2. I have 5 variables on location and 10 on what happens with over...

How to design an excel table that auto-sorts while updating? If VBA is the only option, please post the code! Thanks.

The below macro takes data from the "OUTPUT_SPEC_PHARMACIES" tab and inserts it into a table on the "Pharmacy_Breakdown" tab. The table itself updates automatically if any new data is entered or deleted in the "OUTPUT_SPEC_PHARMACIES" tab. However, if data is deleted, the formatting of the table...

Excel 2010 & Win 7 I created Excel Table from Range of Cells. Table has 10 FieldsTextbox_Company, Textbox_SalespersonName, Textbox_SalespersonNumber, Textbox_Email and so forth. And currently has 100 Rows. To update this Table, I prefer designing my own Userform rather than use Excel...

I am trying to select data in an SQL Table that matches a list (or Table of part numbers I have in Excel 2007. The connection to the SQL database works but gives me the database field heading with no result. I can get a good result if I just use the SELECT query to be equal to a variable set...

Name amount ($) different amount ($) Name amount ($) different amount ($) Name amount ($) different amount ($) I have data that looks like the table above. I need to put it all in one horizontal row so it looks like this: Name amount ($)...

Hello. I am stuck with an Autofit problem in an Excel table: autofit makes some rows higher even if there are no rows that would have any text that is wrapped in the table. I am trying to make it so the user can click on a button to make everything format properly. The code below gives the...

in a simple example I want to convert a table like: SKU DESC Jan-12 Feb-12 Mar-12 123 prod1 10 42 34 345 prod2 90 10 39 Into database format like below, so that I can do data analysis with pivot table. SKU DESC MONTH QTY 123 prod1...

i have an Excel table - Table1, with quantities of different ingredients used by batch for different products. the products are the column headings and the ingredients are the rows. I have created another table - Table 2, with quantities to be made for each product in the top row. by...