Hi,
I created a worksheet in excel to calculate my offers to my customers. Each offer is then SAVED into a separate database (new excel sheet) , one row per offer.
The strategy I use is that I simply link the values from my worksheet into the very first row of my database (A1:Q1)
Whereafter I run the following code :
Sheets("Quotes").Range("A1:Q1").Select
Selection.Copy
Sheets("Quotes").Range("B1").End(xlDown).Offset(1, 0).Select
-----------------
note: .Range("B1") has to be B1 for a specific reason. I know I can fix it by changing the value to A1, but that is not what I need.
The above code searches for the first EMPTY row in the database so it can paste the new offer in an empty row.
However, I need to first move one cell te the left --> A# because my current selection is on the B# column. Otherwise my offer is pasted incorrectly and doesnt align with the others.
- I also understand I need to enter the correct code in this area, hence why I am typing in between the code.
-----------------
Selection.PasteSpecial Paste:=xlPasteValues
Workbooks("Quotes.xlsm").Close Savechanges:=True
Workbooks("Skye.xlsm").Activate
I hope I explained it correctly and thanks to help me out.
Michael
Bookmarks