excel tables

Hi all, I've got a worksheet that's part of quite a large workbook to help organise events and contacts. I do about 18 events a year, so it's not practical to do them all on separate worksheets. I all the events in rounds - 3 rounds of 6 meetings. All the rounds in each meeting are side by...

Good morning. I read the article concerning this question but the recommended code was not working for my intended application. I am looking for some help, please. I have an excel table for which I need to back up daily. I want to save new data (values only) each day without overwriting the...

I was try , 3 table marge but i was tried ...... i was remove this table , & make New table but this last Name Assign Problem ...... How make Running File Marge 3 table , Without loss Data...??? How to possible ??? Pleased Show me Step- by- Step.

Hi Everyone, I am looking for a solution of complicated problem. Below is my problem details: I have excel table with huge data. For example, my table starts & ends at Sheet1! $D$7:$R$2926 . The Table is named as “Data1”. But I want to change the table name as “January” which name will be...

I wrote a macro (mostly by recording it) that copies data from a section on one sheet then calculates the end of my table on another sheet and pastes (paste special, being that the data I am pasting is a formula and I need to paste the values) the data to the end of my table, which on its own...

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

Hello, In our Excel table, let's say we have column B and column C. We would to group column B into one group, and column C into another group. So we click on column B and choose "Group" and it does the trick. Next, we click on column C and choose "Group", but now column "C" is grouped together...

I created this macro which is working. The problem is that I am stuck trying to see and adjust the size of the tables before sending. When I use .send the email goes. When I use .display it creates the email within the excel and I select the range, but don't end up seeing the email before it...

Sub practice() Dim sht As Worksheet Set sht = Worksheets("R401a") Dim one, two As Range ' two will be treated the same as one, just haven't coded it yet. Set one = sht.Range("one") Set two = sht.Range("two") Dim arr() arr = sht.Range("one") ' one is a excel table I named Dim i As Integer For i...

Hello VBA World :) I am struggling with my VBA code (Excel 2010) and I hope someone here can help me out. First of all you should know that I am new to VBA (started a week ago). So not all the fundamental VBA knowledge is in my head (... yet ;) ) This is what I need my macro to do: ...1. Open...

Hi all, Can someone please clear this one for me? I need to connect to 2 Excel tables using PowerPivot. My question is whether the 2 Excel tables need to have the same number and same type of columns (headers)? Will the connection be successful if I have a common header in both tables even if...