Forum Discussion

hopr37 hotmail's avatar
hopr37 hotmail
Brass Contributor
Apr 19, 2018

couple problems. I know it's somewhere in my spreadsheet

My spreadsheet is a basic inventory sheet. It starts with an amount and you can subtract amounts and it gives you the remaining amount. It also copies changes onto a second worksheet. Anyway, my i...
spreadsheet cells
hopr37 hotmail's avatar
hopr37 hotmail
Brass Contributor
Apr 20, 2018

Hey Damien. Thanks for the reply.

I understand the double click enter. That's good.

However, the spreadsheet you modified really doesn't do what I was hoping.

Just looking for a way to fill a range of  blank cells in column A with some text automatically.

One more question for you.

If you look at my original spreadsheet try to insert a new row on worksheet "copper". It gives a debug error that I don't know how to correct.

Thanks for your help

Damien_Rosario's avatar
Damien_Rosario
Silver Contributor
Apr 24, 2018

Hi there

 

I just need to understand a bit more about the blank cells in Column A filling with text automatically.

Are you just looking for placeholder text?

 

1. If so, just type whatever text you want into a cell in column A.

 

2. Copy the cell.

 

3. Click once onto a blank cell where you want the text to begin from.

 

4. Press Ctrl + Shift + Down to select all cells down to 65k.

 

5. Ctrl + v to paste.

 

All cells will have text. You can just replace the text when you are ready to do so.

 

I've attached an updated version of the file and have formatted both sheets so you don't need to add new lines, you just have to type in the values and away you go.

 

This may fix the issue with inserting lines that you have mentioned.

 

If I haven't understood you right, please give me more details on the column A text thing so I can get a better idea.

 

Let me know how you go?

 

Cheers

Damien

Resources