Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
if loop
Hi,
I neeed some help to make a loop, never don that before. How do I get the computer to find a certain value in a special area of a woorksheet. For example find and copy all cells with value 1 in row A and B in sheet 1 and paste it into sheet 2. Thanks for yor help! Sippe |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
if loop
Unfortunately looping is not allowed in Excel formulas. You can use looping
only in macros. Do you want to use macros? Anyways, why do you require looping for your activity. why don't you just filter out the date in row a,b for cells which have value equal to 1, then copy the rows and paste it to sheet 2. -- Kind Regards, Satti Charvak Only an Excel Enthusiast Noida, India "sippe" wrote: Hi, I neeed some help to make a loop, never don that before. How do I get the computer to find a certain value in a special area of a woorksheet. For example find and copy all cells with value 1 in row A and B in sheet 1 and paste it into sheet 2. Thanks for yor help! Sippe |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
if loop
Thank for yuor advice. But yes, I'd like to use macros. I think this would be
a quite easy loop to start with to understand the principal of loops and conditions. /sippe "Satti Charvak" skrev: Unfortunately looping is not allowed in Excel formulas. You can use looping only in macros. Do you want to use macros? Anyways, why do you require looping for your activity. why don't you just filter out the date in row a,b for cells which have value equal to 1, then copy the rows and paste it to sheet 2. -- Kind Regards, Satti Charvak Only an Excel Enthusiast Noida, India "sippe" wrote: Hi, I neeed some help to make a loop, never don that before. How do I get the computer to find a certain value in a special area of a woorksheet. For example find and copy all cells with value 1 in row A and B in sheet 1 and paste it into sheet 2. Thanks for yor help! Sippe |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
if & Loop | Excel Discussion (Misc queries) | |||
do..loop | Excel Discussion (Misc queries) | |||
Loop | Excel Discussion (Misc queries) | |||
Do Loop | Excel Discussion (Misc queries) | |||
Help with Do...Loop | Excel Discussion (Misc queries) |