A
A
Artem Golikov2014-08-28 12:06:16
excel
Artem Golikov, 2014-08-28 12:06:16

How to automate table formatting in excel?

I want to apologize right away for, for sure, a stupid question, but the complete lack of knowledge in this matter forces me. So - there is a file, in this file - receipts, 2 such receipts on one A4 sheet. I need to make sure that each such receipt is placed on a separate sheet. Yes, of course, you can do everything manually, but when it comes to a file in which there are a hundred such receipts, and the files themselves - another hundred, then the manual method disappears. I suspect that VBA can help, but I'm not booming at this...

Answer the question

In order to leave comments, you need to log in

1 answer(s)
Y
Yuri Lobanov, 2014-08-28
@iiil

Yes, vba can help, or rather completely solve the problem. You can write to freelancers and they will do the job for you or sit down and learn vba, it is a very simple language that will help you out more than once.
You can dig into excel itself, maybe you will find something, but I don’t remember this, although I know Excel well. Truth without a file the task is not absolutely clear. Each receipt must be printed on a separate A4 sheet or on a separate excel tab (in the English and Russian versions, the tabs are called Sheet). But even in this case I would not bother and would write a small macro.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question