Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
'Pushing' data from 1 sheet to another
Is there a way to 'push' data from one sheet to another? I am thinking of
some kind of formula like an if-then-else. I want to check a cell on sheet 1 for a certain value (such as the number 5) and if the condition is met, then I want to copy or 'push' other cell data from sheet 1 to other sheets in the workbook. I realize I can use the 'if' function in a cell on the sheet where I want the data to end up which would 'pull' the data from sheet 1, but this will not work for me because I want to use the data in the cell on sheet 1 to determine which other sheet in the workbook the other data from sheet 1 is copied to. As an example, if the number 5 is in a cell on sheet 1, then I want to copy or 'push' other data on sheet 1 to sheet 5 in the workbook. Thanks for any help, Learner101b |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pushing the Envelope with the RANK function | Excel Discussion (Misc queries) | |||
see chart from pushing button | Charts and Charting in Excel | |||
Pushing my luck | Excel Worksheet Functions | |||
I just want to create a check list for my snow pushing business c. | New Users to Excel | |||
Toggle betwen "editing" and "pushing" a button in excel | Excel Discussion (Misc queries) |