(VBA) Move selected cell one to the LEFT

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 :

Please Login or Register  to view this content.

-----------------
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.
-----------------

Please Login or Register  to view this content.

I hope I explained it correctly and thanks to help me out.

Michael

From looking at the code, I belive this is workable.

Please Login or Register  to view this content.

Hi Dave,

Thanks for your reply!

Which bit of code makes the cell move from B to A before pasting the contents?
because if I'm reading this correctly, this code does exactly the same as mine, however with cleaner code.

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.