• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Use a formula to duplicate a table?

D

DonMinter

Member
Is it possible to use a formula to duplicate a table?


I have two sheets. Sheet one is a collection of tables. Sheet two is my "definitions" sheet. I have a start date, and an end date as data in my definitions. Each table in sheet one is a date broken down into hours (columns 1 - 24, ignoring headers, labels, etc.).


Now, if the person enters 5 days different on sheet two, I need to have 6 tables on sheet one... Day 1 to day 6 (6 - 1 is five days difference).


Can this be done using a formula? I really don't want to relearn VBA for this, as I haven't written any code since like Excel 2003.


I'm using Excel 2010. I've read everything I can find on tables, but I can't find what I'm looking for. I can even do additional sheets (one per day) if need be, but I'd prefer a single sheet with 1 table per day. I'm also open to other ways to do this short of cutting and pasting manually (which is what I'm going to have to do if this doesn't work).


For more information, I'm trying to adapt the Gantt charts to allow for hourly granularity for very tight project schedules.


Thanks in advance for any suggestions anyone can make.
 
I'm not really understanding the question.


You could always name the table, select cells of the same size as the table and enter =tablename as an array, but I'm not clear as to why we would do that, considering the table is already there.


Can you post a sample?
 
I think I am going to change my approach, Dan_l. I think I'm going to manually create the tables for this first evolution, and just make my dependencies work via formulas. There will be enough data-linking in that to keep me busy. This problem has already cost me too much time for its worth. I can always come back later and tweak the spreadsheet if I find the manual C&P too arduous. I just didn't know about Excel tables, and was trying to use them for what is probably too tricky for a newbie to tables.


Thanks for the interrogative. I truly appreciate the fact that you read and attempted my poorly-worded inquiry.


Don
 
You must log in or register to reply here.
Back
Top