B
BabsCreates
Good Afternoon;
I have a workbook that tracks the sale of the items in my store. Th
Main tab contains all sale requests for the day. Each day these item
are either placed on hold, filled or voided. I have 3 other tabs eac
named Hold, Filled and Voided. I want to automatically move these item
to each designated worksheet according to the action taken on eac
order. Example: Items placed on hold would automatically move to th
tab labeled Hold etc. I have entered the headings below of the Mai
tab. Once the Action Taken column is completed with either Hold, Fille
or Voided then I want it to be automatically copied to the firs
available row on the Hold tab.
Invoice Customer Price Product Quantity
Action Taken
I hope I have explained this sufficiently and would appreciate any hel
I could get with this. I don't know how to write macros so I'm reall
depending on a good formula. Thank you in advance for your assistance
I have a workbook that tracks the sale of the items in my store. Th
Main tab contains all sale requests for the day. Each day these item
are either placed on hold, filled or voided. I have 3 other tabs eac
named Hold, Filled and Voided. I want to automatically move these item
to each designated worksheet according to the action taken on eac
order. Example: Items placed on hold would automatically move to th
tab labeled Hold etc. I have entered the headings below of the Mai
tab. Once the Action Taken column is completed with either Hold, Fille
or Voided then I want it to be automatically copied to the firs
available row on the Hold tab.
Invoice Customer Price Product Quantity
Action Taken
I hope I have explained this sufficiently and would appreciate any hel
I could get with this. I don't know how to write macros so I'm reall
depending on a good formula. Thank you in advance for your assistance