Home » Forums » Open Source Learning Center » Question and Answer

Mirroring data

Submitted by _aaiden on 15 April, 2013 - 07:55

I am trying to set up a spreadsheet where I have a worksheet called 'Data Entry Form', here I will enter data under certain headings and when I finish entering the data I want to move it to a new sheet to manipulate an invoice.

Under the headings there isn't always an amount of units though, which is where my problem arises. Can I interpret the data so only the headings with an entered amount of units will carry over?

I have tried a long if statement that was in a sequence but couldn't quite get it working?

Any help?

AttachmentSize
Sample Sheet.xlsx39.39 KB
‹ (SOLVED) How to use a cell value as the "To value" value on Goal Seeking Reconfiguring variable assignments ›
»
Nick's picture

hi.. not entirely sure what

Submitted by Nick on 15 April, 2013 - 08:48.

hi.. not entirely sure what your question is about..

in terms of logging data to an excel database for use later, recommend looking at this:

Share Trading System

»

I have attached a sample

Submitted by _aaiden on 15 April, 2013 - 11:41.

I have attached a sample spreadsheet to give you an image idea..

I want the table under 'Monthly Payroll Charges' to transfer to the invoice but anything without a unit not to be brought over?

Does this help?

»