Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-10-2015, 11:51 AM
bwwalker08 bwwalker08 is offline Move data from one sheet to the next available row or cell of another sheet Windows 8 Move data from one sheet to the next available row or cell of another sheet Office 2013
Novice
Move data from one sheet to the next available row or cell of another sheet
 
Join Date: Apr 2015
Posts: 1
bwwalker08 is on a distinguished road
Default Move data from one sheet to the next available row or cell of another sheet

Simplified formula to move data from one sheet to the next available row or cell of another sheet when a number is entered into a cell range?

I am trying to put together a flat rate system for our dealership. It is still in the very early stages of being formed, but I would like it to have the ability to move a whole row of data to a quote form (another sheet) when a number such as "1 or 2" has been entered into a specific range of cells, and then multiply the number entered into the specified range, in the event that the flat rate code needs to be used more than once on a service quote. I have been able to accomplish this on a cell to cell basis with the formula listed below. (note that 90AAAAAAA is the name of the sheet that I am pulling data from, Cell B9 is the cell that will activate the formula, if it is a value greater then 0.5, C9 is the cell the data will be pulled from if activated by cell B9, and as mentioned above, I wanted it to multiply the number in C9 by the activation value in B9):

=IF('90AAAAAAA'!B9>0.5,'90AAAAAAA'!C9,"")*('90AAAA AAA'!B9)

So, I have a few questions:



1.
How can I make this formula pull data from not only multiple cell ranges (i.e. C9:C500) and have it be activated by multiple cell ranges (i.e. B9:B500), but also pull from approximately 50 different sheets?

2.
Is it even possible without a complex string?

3.
Is it possible if I copy and pasted the above formula 491 more times for each one of the cells I would like it to pull data from, then do this for each sheet I would like to pull data from? (I realize that thatís like 25,000 formulas, but I guess the question I am asking there is, is there a limit on how characters can be entered into the formula box?)

4.
Lastly, if we were able to figure the above questions out without a complex string, would we be able to have the formula move the data described to the next available row? Because when we are going to be putting together a quote, we are probably going to be using several different codes at random and would like them to automatically go into the quote form neatly. Again, if this isn't possible without a complex string, then we maybe shouldn't worry about it, because that is something that is out of my very limited book of knowledge when it comes to Microsoft Excel.

A copy of what I am beginning to work on has been attached, if that will help explain things any better.

Thank you!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Populate sheet 3 with data from sheet 1 and sheet 2 speck Excel Programming 0 01-14-2015 07:54 AM
Move data from one sheet to the next available row or cell of another sheet Help Coloring a cell in Sheet one if data is missing from another sheet Aeducan Excel 1 06-22-2014 04:49 PM
Move data from one sheet to the next available row or cell of another sheet How to move data from one sheet to another maximbebi Excel 2 02-17-2014 08:50 PM
Move data from one sheet to the next available row or cell of another sheet How to move data from one sheet to another maximbebi Excel 3 02-16-2014 11:46 PM
copy cell from sheet 2 to sheet 3 macro slipperyjim Excel Programming 1 02-18-2010 01:31 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:42 AM.


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