Microsoft Excel Macro (VBA ) required
$30-100 USD
Kiszállításkor fizetve
Microsoft Excel Macro (VBA ) required to run in Microsoft Excel 2007.
* The macro must copy all selected cells from one sheet and paste them on a new worksheet (created by the macro) within the same workbook, starting at A1 on the new worksheet.
* An error (abort) message must be displayed if cells in the source selection are not contiguous.
* Rows and/or columns on the source worksheet could be hidden and must be excluded from the range to be copied.
* Cells within the selected range will have conditional formatting applied which references cells outside the selection and the cell and text formatting (including cell background colour) for each source and target cell must be identical.
* Row height and column width properties on the target worksheet must match those of the rows and columns within the selected range on the source worksheet.
* Formulas in cells within the selected range must be converted to values on the target worksheet.
* There may merged cells on the source worksheet (and therefore within the selected range).
* A message box must be displayed indicating that the macro is running.
* Screen updates must be disabled during the copy process.
* A message box (OK/confirmation) must be displayed once the macro has completed.
* The original selection on the source worksheet must be visible and selected once the macro has completed.
Projektazonosító: #2784817