I would like to create a "SaveAs" (or whatever you suggest) control button that will 1). create a new worksheet in a folder *and* 2). remove values from columns 1&2; 3). replace values from columns 5&6 to 3&4, 4). and remove values from columns 5&6. I know how to do it manually (i.e.linking & formulas0; but my boss wanted to know if it can be done in one click of a button . Is this possible in Excel?
Thanks!!!
Jackie
Thanks!!!
Jackie