structure

Hi, I have 5 excel files. All files have same structure. These files are prepared on daily basis. So, structure for 9-Apr-2018 and 10-Apr-2018 will be the same. Only difference will be between number of records each file. How to I import all these 5 excel files in one single table of access...

I am using the following formula to round costs to fit into their relevant fee structure...

I require specific formula for lot wise sum of ID . The ID will re-occur but the re-occurred ID should be separately addition-ed. The ID will be nearly in 2000 number. # Do not sum all the similar Structure ID #Do not change the Structure ID <tbody> Structure ID Weight SUM A 1 A 1 3 B 2...

Hei, Im just begin to work with Excel and my english is limited so sorry if this question is answered many times. I have problem how to update prices. Every year I got price list in excel format with 30 000 lines . I used search and copied data in structure I need but on separate spread sheet ...

I have a spreadsheet with a Pivot Table. The Pivot Table is generated via Power Pivot, and the underlying data is from a set of CSV files (one per month) that are linked by way of the Queries and Connections interface. Here is how the directory structure is...

Greetings, I am receiving the compile error "For Control Variable Already in Use". I have nested For Each Next loops with the Control Variable as "Row". I am looping by the row with a predefined range of rows. How can I maintain the nested loop structure and use a variable that loops using a...

I am attempting to create a folder structure utilizing a dialog box and command button because the folder name will be custom. However, I would like create a folder structure under the unique folder name. I have the following to create the folder required, but am running into trouble recalling...

I am trying to construct a pivot table that uses multiple tables that have the exact same column structure. I do not want to make a “master file”. I don’t want to just consolidate the information. I would like one pivot table that can be filtered to get individual info by criteria. I can not...

Hello all, once again another stumbling block and could use a push over the hurdle. In column "G" I have a description of an item we are to fabricate. Each item to fabricate has at least 2 entries. These would be G1 and G2. There could be more to create the item (i.e. G3, G4, G5 etc..). Then the...

So I am trying to do some analysis on a portfolio of loans. The structure of the data is such that it is a web of many to many relationships. I have data tables for, among others: Borrowers Loans Guarantees Units Properties The Units have a many to one relationship with the properties, but...

Hi I have a workbook with over 100 worksheets. They have a different structure (some columns are in all of those worksheets, but some are not). If there an easy way to merge them by columns they have in common? Thank you in advance!

Hi, Im trying to implement SubTotal for my tree structure. I have validation list with values: H1, H2, H3, H4. Example: when user select H2, SubTotal should sum each value from H2 to H4 level. When select H3, SubTotal should sum each value from H3 to H4 level. Please see below example...

Hello, I have created 3 Macros that I have combined into a macro button - but I wanted to see if there is a way to "combine them" into one sub and make things more efficient, keeping the same order. Unfortunately, I am somewhat of a novice so I am not sure how to go about this. Any assistance...

Hi, I'm trying to change my current table structure into a new Table with different columns and I'm wondering if there is any fast way of doing this rather than manually updating each field. (there are over 200 rows to update). So a little background. My current Table contains all the...

Hi, I'm trying to nest an OR statement within an IF statement, with varying luck. ----------- The following example works: =IF(OR(H2="Apple",H2="ApplComputer",H2="APPLE CANADA DIV",H2="IPHONE",H2="MACBOOK"),"Apple”,"Other") While the below example does not and instead returns a #NAME? error...

Hi all, I've been trying to work off this older post (sorry if this is not the correct way to reference other posts) http://www.mrexcel.com/forum/excel-questions/525842-creating-folders-subfolders-using-macro.html but my VBA vocabulary is pretty limited to what i could reverse learn from...

Hey guys, I have been working on a project in Excel for weeks with no luck. What I am trying to make is an interactive BoM (bill of materials) setup almost like a Family Tree with buttons to add new child items. I've been working on coding this for weeks with no luck. Here is a link to my...

Hi all, I'm looking for a way to customise what gets locked when I protect an Excel workbook. For instance, I'd like users to be able to copy/delete certain worksheets, but not be able to unhide/delete other sheets. Is this possible? Many thanks, Grace

I have a table, "Table A" created with basic data. I have another table, "Table B" that houses certain transactions done by Table A. However, I also need another table, "Table C", that houses a different set of transactions for the Table A data (I will actually have~4 tables of different...

Folks: How do I make sure the field order is corrected if someone moves the fields around before refresh? Right now, I can't use the position commands because the fields already exist. I thought the remove fields code would work but its only removing data fields. - Thank you, Rowland Sub...