M
Mike
Help please, I am trying to automate the cutting and pasting of lines
based on a value of a cell.
I have a spreadsheet that is partly automated that sorts contact data and
will copy a selected range into a new spreadsheet. What I want to try to
do is select rows within this that have a status = good and paste them
only to my template spreadsheet.
I have worked out how to automate the file saving with a date and
timestamp but not how to make the selection and invoke a message box to
confirm the the selection.
Layout is :
Date/Name/Company/Address/Product/Status/Ship/Product/Qty/ +5 columns
with Sales Data
My template just needs the first nine columns for an import process and
the rest are disregarded.
Any help at all would be grately appreciated
Many thanks
Mike
based on a value of a cell.
I have a spreadsheet that is partly automated that sorts contact data and
will copy a selected range into a new spreadsheet. What I want to try to
do is select rows within this that have a status = good and paste them
only to my template spreadsheet.
I have worked out how to automate the file saving with a date and
timestamp but not how to make the selection and invoke a message box to
confirm the the selection.
Layout is :
Date/Name/Company/Address/Product/Status/Ship/Product/Qty/ +5 columns
with Sales Data
My template just needs the first nine columns for an import process and
the rest are disregarded.
Any help at all would be grately appreciated
Many thanks
Mike