Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
In need of a whacky function
I'v built a spreadsheet that has multiple worksheets all of which retrieve
data from a central worksheet (we'll call this central sheet "data input") The "data input" sheet is where the "quantity" of different items are added to the workbook. The worksheet that pulls data (we'll call this sheet "data pull") from the "data input" worksheet needs to identify the quantity of items in the "data input" worksheet, then populate the "data pull" worksheet with that same number of rows. In other words if Dat Entry has four rows of data, Data Pull will see the item quantity as four and return four rows of data. If you change the number of rows in Data Pull to 7, then Data Pull will now return 7 rows of data. I hope this makes sense....if not email me at and I'll try and explain further. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
Excel patch whacky | Excel Discussion (Misc queries) | |||
Excel 2003 - Whacky Menu Bar | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
In need of a whacky function- | Excel Programming |