#1
|
|||
|
|||
workseet with Tables for VLOOKUP formulas needs to be split into 3 pages
I realize this may be something really basic, but I am a pretty low level beginner. All the help from this forum has been great and has let me actually set up my workbook perfectly, but I have put all the tables on one worksheet that are used for the vlookup formulas and have realized that this means if I ever have to make a change, like adding or deleting something, and I might, that will mess up all the tables.
So, is there an easy way to take that one worksheet that has the tables on it, and split it into 3, which would allow me to set the tables up by category, i.e. owner, income, expense, or would it be better to just start a new workbook template? Thanks for any help. Ruth |
#2
|
||||
|
||||
When you use the term " table" do you mean like a range ( some columns and rows without anything special) or is it a table that is inserted via the Insert ribbon in Excel?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Hi. Yes, they are tables that I inserted from the Insert tab for the formulas like:
=IF(D26<>"",VLOOKUP(D26,Table6_Expense,2,FALSE),"" ) There are 9 of them, and they would split nicely into 3 groups if I could figure out how to do that, though I might learn more if I just played around with it Ruth |
#4
|
||||
|
||||
Could you please post a sample sheet showing what you mean by " messing up"?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#5
|
|||
|
|||
I'm Sorry, I can't. I actually don't have what I was working on since it was so messed up I just deleted it and started with the one I had saved that was just 1 back from what I was trying to change. I figured out what was wrong, I think. So, this was the problem: I don't really understand how the 'internal' excel is working, so I had no idea how the inserted Tables, The Name Manager and such are kind of linked and interact, when I was trying to split out the tables on 3 different worksheets, I copied the inserted tables worksheet using the control and mouse to drag, then renamed the worksheet and then deleted all but the tables referencing owners, then went back to the original table worksheet and did the control drag again, and deleted the tables on that page that didn't reference income, and then did the same thing again for expenses. Then I deleted the original tables worksheet. But what I was seeing in the name manager, I couldn't figure out, like Table25, 26, 27, I didn't have 27 tables, {hee, hee, hee, but I did }.
Anyway, I went back to the older workbook and late last night and got it done, probably not as easily as it could be done, but it works and I do now have my 3 separate table worksheets and only the original 9 tables in the Name Manager. I also learned last night that if you copy a worksheet from one workbook into another workbook [I copied a summary sheet] the formulas in that sheet in the new workbook began =SUMIF([OLD_workbook.xlsx] and rest of formula, which told me that the sheet was linking back to the old workbook So thank you for your interested and willingness to help me. If you know of a place that explains how excel is working [internally, I don't know how else to express it], that is how the worksheets are interacting and such, I'd would really appreciate the information. Thanks again, have a great day. Ruth |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Formulas transferring to other pages in workbooks, but data isn't. | Melissa Ames | Excel | 4 | 03-02-2016 01:58 PM |
Tables: Ensuring Rows Not Split Across Pages Yet Retaining Repeated Header | Andrew H | Word | 5 | 12-28-2014 06:08 PM |
Nested vlookup with varable tables! | Dave Jones | Excel | 0 | 08-30-2012 09:15 AM |
Automatically split Mail Merge based on number of pages | SaneMan | Mail Merge | 1 | 12-03-2011 01:11 AM |
Vlookup and If conditions together along with match formulas | david_benjamin | Excel | 2 | 04-11-2011 11:30 AM |