Dynamic Column List From Another Table

[bj90]

Hi,

Can a table column have all of the cells with data from another table column? I want this to be a complete list and not just a cell equal to another cell please.

My source table has data in A2:A4 on the Invoice Data sheet.

My destination table starts in cell A10 on the Status sheet.

Thank you

[Special-K]

What are you trying to do?

[bj90]

I want all Invoice Numbers on the Status sheet starting in A10 thank you

[Special-K]

Post a sample spreadsheet with expected results, remove any sensitive data, create a mockup example if necessary.
Use the Go Advanced option at the bottom of the page then scroll down to Manage Attachments as the "paperclip" method does not work on this forum.

[bj90]

I have a list of Invoice Numbers in column A of the table in the Invoice Data sheet.

I have a Status sheet so I can have the complete list of all of those invoice numbers.

The table column on the Status sheet begins in cell A10. This is where I would like the complete list please.

Is it still necessary for the file?

[Special-K]

So you just want 'Invoice Data'!A2:A4 copied to Status!A10 onwards?

Formula or VBA solution?

[bj90]

I am sorry for the trouble and seem to be offending most everyone so I have no choice.

[Special-K]

So you just want 'Invoice Data'!A2:A4 copied to Status!A10 onwards?

Formula or VBA solution?

[AliGW]

I am sorry for the trouble and seem to be offending most everyone so I have no choice.

Whom do you think you have offended?

And why have you marked another unsolved thread as solved?

[Special-K]

Whom do you think you have offended?

And why have you marked another unsolved thread as solved?

My fault, I was a little harsh as my request for posting a file wasn't done.
I edited it out.

[bj90]

I know it's just me, I seem to be impatient and don't know how to properly ask questions. It is for the best for you to help others in need.

[Special-K]

I'd still like to solve this and sometimes a picture is worth a thousand words hence the request for a file.

The only thing I can see so far is you want 'Invoice Data'!A2:A4 copied to Status!A10 onwards?
Will you eventually want all the source data from A2 onwards to be copied to Status!A10 onwards?

Do you want a formula or VBA solution?

[bj90]

Please help someone else in need I have realized that I don't deserve assistance.

[AliGW]

There really is no need to be a martyr. The reason that people like me help on forums like these is to assist people like you. It is true that you can be a bit impatient, and in so being, you are missing the point of what is being explained to you, so at the moment you are working with a half-built jigsaw and are unable to see the wider picture.

At some point you’ll have that epiphany moment and understand what the issues are, but that hasn’t happened yet and yes, that can be frustrating.

You will get there, but you need to be patient and try to fully understand the advice you are being given instead of opening threads, asking for help, being prompted for more information and then abandoning them because you want an instant answer that isn’t forthcoming. People are not trying to be obtuse: quite the opposite. Problem is, if you continue in this vein, the wider membership will gradually decide not to bother trying to help you, and then you’ll be left high and dry and with nothing to show for it.

Try to be guided by those willing to help you who have a vast amount of knowledge about these issues that you are trying to resolve.

[bj90]

I don't want to private message so I will put it here.

I give up asking for help. I seem to have a way to be impatient and not getting along with the rules or regulations on here so when you have the time remove me from this forum so my account doesn't take up valuable space.

[AliGW]

That is YOUR interpretation of the situation. It is not ours, nor have we implied anything of the kind. Whether or not you stick around is entirely your decision: nothing will be removed or closed, so you can come back if you change your mind. It’s entirely up to you.