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
Damien_Rosario's avatar
Damien_Rosario
Silver Contributor
Apr 20, 2018

Hi there

 

Based on what I understand, maybe give this modified file a shot?

 

In answer to your first question, just press enter twice to move down to the next row.

 

Question two, I've set it up so that when you enter a TYPE into any cell in column A, it will automatically be reflected in the Copper History worksheet. I've aligned the CopperHistory worksheet content to your Copper worksheet content.

 

Essentially you can link between worksheets by going to your Copper History worksheet and clicking into a cell (e.g. A4), press =, click onto the Copper tab, and click onto the cell that you want to reflect. Press Enter when done.

 

Hopefully this is the solution to your query?

 

Please let me know how you go?

 

Cheers

Damien

  • 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