tables;range names

I have a number of different workbooks, let's just call them workbook 1, workbook 2, etc.... Each workbook has multiple worksheets referencing different data from the other workbooks/worksheets. I originally had different named ranges (static) in each worksheet, to make things easier to...

I have created a spreadsheet with 2 tabs. Tab 1 has slicers referencing a table on Tab 2 The table on Tab 2 contains embedded Pdfs and pictures for each item entry I can display the picture of the embedded pdf on Tab 1 dynamically but cannot double click and open the image. On Tab 2 I can...

MR. Excel Help Hi all, I am having trouble with a delete row macro for one of my tables in excel. When I run my "Call_Delete_Row" code in an existing table after I open my excel spreadsheet, the last row for two tables on two different sheets are deleted. However, AFTER I run...

I have a table where I need to find the elements present in different samples. For every sample, the no of iterations is a variable - I can have two rows of sample 1 and 3 rows of sample2 or 5 rows of sample4. the number of columns which are the elements can also be different. I have considered...

Hi, Hope someone can help I'm getting an error on the highlighted part of the code below? This occurs when I'm referencing a sheet by its code name and not its tab name. Any help or advance?? Private Sub CommandButton1_Click() Dim lngStart As Long, lngEnd As Long lngStart =...

Hi I have create tables in 2 sheets but I wish to consolidate them in one sheet. Is there an easy way to move them does anyone know? Many thanks Dan Excel 2007

Hi! I need your help to get this macro right. I need to copy the formulas i have on a table as values on top of the original cells . How can I select the combination of columns and rows i want to select? I dont want to copy the whole table , just a selection of the information contained in...

Situation: Excel data converted to Table (Insert Table); table renamed to MyTable Formulas created to access table data using structured table references e.g., =sum(MyTable[[#data],[Col1]]) For specific reasons, the Table needs to be converted back to a range and then, after certain actions...