help with excel cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

HI there,

basically i have a cell spread sheet, and i wanna have some help in this field

i have a sheet with products and exipry dates(sheet 1), and the products
expired (sheet 2).

basically i wanna know how can i make the cell from sheet 1 when it expires
, takes the whole raw for that specific product to sheet 2

thanks
 
HI there,

basically i have a cell spread sheet, and i wanna have some help in this field

i have a sheet with products and exipry dates(sheet 1), and the products
expired (sheet 2).

basically i wanna know how can i make the cell from sheet 1 when it expires
, takes the whole raw for that specific product to sheet 2

thanks
Click to expand...

You will need some VBA help with this one if you want to move the data
after the expiry date - it's easy enough VBA but probably not within
the scope of this group - feel free to email me with more details.
 
thank you very much,

basically i have a project in my IT lessons, and this is one of the
requirments,

is there any formulas or steps i could follow in achieving this target???

thanks again
 
thank you very much,

basically i have a project in my IT lessons, and this is one of the
requirments,

is there any formulas or steps i could follow in achieving this target???

thanks again






- Show quoted text -
Click to expand...

OK, basically you would need to check all the rows on the spreadsheet,
and if the data in a particular column was OLDER than today then the
entire row would be moved to the other workbook - you can record a lot
of these actions - I'm happy to help (suggest you email me at
(e-mail address removed)) with further questions, but obviously for
an IT project you are learning, I don't want to do the job for you as
you wouldn't learn anything from this.
 
Back
Top