table design

Hi! I'm using the popular VBA code for range-to-Email functionality. My emailed range includes table with header + a few extra rows below, all belonging to "MyRange". I want to improve the visuals of the emailed range and enabled "Banded rows" under "Table Design". I also considered a different...

We know that in case of MS Word, it lacks the concept of cells as a means to store data. So in that case if one were to add a Table it would be somewhat a free floating shape. However that is not the case of Excel, wherein if we insert a table it stores the data in cells. The problem with that...

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...

Hello, I need to transform a table like table 1 in a table 2. I need to do this in a very repetitive way. Each calculation output is something like Table 1 and in fact I need the data in a Table 2 format. Honestly I don't have many clues in how to do it. Table 1 <tbody> x y z a b c aaa bbb...

Hello Team, I've exported a list of metadata from my SharePoint Document Set library. The library is where we manage our "kaizens" which are a kind of standardized meeting. For each kaizen, I've captured the Topic, Date, and Members who attended the meeting. Because the Member field in...

So I have a corporate database that lists unique items and properties for the items in a table. This table is linked to a local access db, and I cannot add fields to it. Therefore, I'd like to create a table that mirror's all the same unique rows of the corporate table -- and have my own...

hi, in sheet1 I have source table: <tbody> Car Year Color Type Audi 2000 Red Sport BMW 2001 Black Coupe Volvo 1998 Yellow Combi VW 1996 Black - Fiat 2003 Red Family </tbody> Then in sheet2 in A1 I will be selecting car name (Audi, BMW etc). Now if I choose "Audi" I want to in...

Hi, i'm very new in VBA.. Currently I'm on my project which required me to creating a automation tool by plotting 2 bar chart automatically based on 2 table data as shown below View image: VBA1 *I got no idea why i can't attach the picture here, so I pasted the link here =/* However as the...

Hi, i'm very new in VBA.. Currently I'm on my project which required me to creating a automation tool by plotting 2 bar chart automatically based on 2 table data as shown below However as the table data was generated out from another automation tool thus the number of rows can be increase or...

Hello Forum, I was wondering if you can help me with a vba code to extract values from a table like this to multiple rows of 3 columns only. <tbody> Name of Students Apples Lemon Oranges Pineapple Strawberry Grape Lime Coconut Peter 4 2 1 John Derrick 3 1 Stuart 7...

Excel 2010 Data formatted as a table One user inputs data into the table for a charge they are making. Our finance person later reconciles the charge by changing the cell in the 'Invoiced' column to 'Yes' and entering an invoice #. I'd like to have VBA code that changes the cells to locked so...

Hi all, anyone can tell me how can i delete intireRow (in slected row), with VBA code in excel 2010? tnx Rafi:confused:

Hello, I try to build a table with various formulas in Excel 2007 using VBA. The input data are in 2 different spreadsheets and I will build the table in a 3rd sheet of the same file. In my sample case, I use about 10 rows even though later on that number will increase significantly. I give...

Hi Guys, I hope you can help me. I received some data in the following format: Mr|A| Jones| $500| 15 Sunset Road| Claremont||| 15/3/2010|Invoice|$2000| 20/3/2010|Payment|$1500| Mr|G| Moses| $2000| 20 Musket Road| Bellville||| 15/3/2010|Invoice|$4000| 30/3/2010|Payment|$2000| I need change...

Table 1 Looks like mine table. (but mines actually 34 rows long including the header) TABLE1 <TABLE style="WIDTH: 343pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=457><COLGROUP><COL style="WIDTH: 118pt; mso-width-source: userset; mso-width-alt: 6698" width=157><COL...

Hi There (Apologies if this doesn't make sense!) I need to store results from an paper audit so that the data can be entered via a form and interrogated through queries. I have 6 text fields but the remaining 30 questions are multiple choice. I also need to store date, time, who the auditor...