Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-03-2016, 06:57 PM
innkeeper9 innkeeper9 is offline workseet with Tables for VLOOKUP formulas needs to be split into 3 pages Windows 7 32bit workseet with Tables for VLOOKUP formulas needs to be split into 3 pages Office 2007
Novice
workseet with Tables for VLOOKUP formulas needs to be split into 3 pages
 
Join Date: Aug 2016
Posts: 20
innkeeper9 is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 10-04-2016, 12:45 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline workseet with Tables for VLOOKUP formulas needs to be split into 3 pages Windows 7 64bit workseet with Tables for VLOOKUP formulas needs to be split into 3 pages Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,470
Pecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to behold
Default

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?
Reply With Quote
  #3  
Old 10-04-2016, 07:37 AM
innkeeper9 innkeeper9 is offline workseet with Tables for VLOOKUP formulas needs to be split into 3 pages Windows 7 32bit workseet with Tables for VLOOKUP formulas needs to be split into 3 pages Office 2007
Novice
workseet with Tables for VLOOKUP formulas needs to be split into 3 pages
 
Join Date: Aug 2016
Posts: 20
innkeeper9 is on a distinguished road
Default

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
Reply With Quote
  #4  
Old 10-04-2016, 11:32 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline workseet with Tables for VLOOKUP formulas needs to be split into 3 pages Windows 7 64bit workseet with Tables for VLOOKUP formulas needs to be split into 3 pages Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,470
Pecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to behold
Default

Could you please post a sample sheet showing what you mean by " messing up"?
Reply With Quote
  #5  
Old 10-05-2016, 01:45 PM
innkeeper9 innkeeper9 is offline workseet with Tables for VLOOKUP formulas needs to be split into 3 pages Windows 7 32bit workseet with Tables for VLOOKUP formulas needs to be split into 3 pages Office 2007
Novice
workseet with Tables for VLOOKUP formulas needs to be split into 3 pages
 
Join Date: Aug 2016
Posts: 20
innkeeper9 is on a distinguished road
Default

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
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
workseet with Tables for VLOOKUP formulas needs to be split into 3 pages Formulas transferring to other pages in workbooks, but data isn't. Melissa Ames Excel 4 03-02-2016 01:58 PM
workseet with Tables for VLOOKUP formulas needs to be split into 3 pages 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
workseet with Tables for VLOOKUP formulas needs to be split into 3 pages Automatically split Mail Merge based on number of pages SaneMan Mail Merge 1 12-03-2011 01:11 AM
workseet with Tables for VLOOKUP formulas needs to be split into 3 pages Vlookup and If conditions together along with match formulas david_benjamin Excel 2 04-11-2011 11:30 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 11:48 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft