Excel Macro -- 2
Budget: $10 – $30 USD
VBA Code for Excel
Create a new sheet next to the current sheet named on the value in sheet “Quote” cell H5
Copy the entire sheet “Quote” to the newly create sheet, paste as values (not formula)
Copy the format from Quotes to the new sheet.
From sheet called “Quote #” delete row 1 and move all values in column A up so that the value previously in A2 is now in A1
Return to “Quote” sheet cell C6
Create a new sheet next to the current sheet named on the value in sheet “Quote” cell H5
Copy the entire sheet “Quote” to the newly create sheet, paste as values (not formula)
Copy the format from Quotes to the new sheet.
From sheet called “Quote #” delete row 1 and move all values in column A up so that the value previously in A2 is now in A1
Return to “Quote” sheet cell C6