how do i enter data into specific cells of a set of selected rows? [SOLVED]

[dronka]

I am creating an invoicing function in a table of sales (SalesTable). The code currently allows me to select multiple rows in SalesTable and then it takes the data from those rows (each row representing a line item sale) and creates an invoice. The code creates an invoice number. I'd like to be able to go back to SalesTable (the rows are still selected) and enter the invoice number into specific cells (column L, "Invoice Number" in the table) of the selected rows.


E.g. I select rows 2 and 3 of SalesTable and run the invoice code. The invoice is generated and an invoice number ("iNumber") is generated. The code ends back at SalesTable and rows 2 and 3 are still selected. I want to create code that will enter iNumber into column L ("Invoice Number" column of SalesTable) of the two selected rows.

 

[inbp]

Hi dronka can you share sample file

 

[Hui]

Dronka

Press Tab repeatedly until the selected cell is arrived at

After you type your value/text press Tab, not Enter and your range will still be selected

 

[dronka]

Thank you both. I will try to put together a sample file. Where does one upload such files?

 

[bobhc]

Good day dronka


Reading the green sticky's helps


http://chandoo.org/forums/topic/posting-a-sample-workbook

 

[dronka]

Thank you all for replying. I figured out a workaround using search and replace within the selected range. It may not be as elegant as the solution I was hoping for, but it works.