Posts by pantakos

Understood and respect.

Thank you !

Cross Post

Table Reference

Hello all, I have a question. I need to reference to another sheet the value of a cell that is in a table. I need this to be inserted at an other table at the…

www.mrexcel.com

Thank you for your answer

Something like that, but I need the values to be inserted in another table (RATE), so I need to insert specific values [PCS].

If you see the example if something change at the first table the values inserted to the second one and use them to do calculations

My English are not that good... I hope you understand. The fact is that I can do that on Windows but on MAC is not working

Hello all,

I have a simple excel that has two sheets. One FORM and second RATE

Both have Tables.

My need is, when the table in sheet FORM fills then automatically fill and the table at sheet RATE

I am trying to make it happen but #Value keeps coming. I understand that my first table starts from Row 17 and the second from row 1

What can I do?

The formula am using is =Invoice[@[PCS]:[PCS]]

I hagve attached the excel if it can help

Thank you!

test-excel.xlsm

royUK of course!

Here is the solution

solution

With help from https://www.msofficeforums.com…sed-other-worksheets.html

This is solved, so case closed.

Thank you

Hello all,

What I need to do is to rename the created sheet (Products) with the name of the sheets in ws , that are used for the calculations (fill Products worksheet with data).
The format will be TEMPLATE-games-play2 etc , only the sheets with data
Please find attached an example

test6.xlsm

Thank you

Cross posted https://www.mrexcel.com/board/…ets.1203494/#post-5875738

Create / Rename Worksheet based on other worksheets

alansidman If you check my first post I said that I have post it and at two more forums

Someone? Please

Cross-posted: mrexcel.com/board/threads/chec…-but-keep-format.1201684/

I tried to change sht = Array("E") to sht = Array("E", "K") in order to check both Columns and add it where the code paste the values, but no luck.

I need to keep the table.

What can I do?

Thank you in advance,

Gerasimos

SAMPLE10.xlsm

PS: Partial question have been posted here https://www.excelforum.com/exc…-problem.html#post5658628 and https://www.mrexcel.com/board/…-but-keep-format.1201684/

Update! Finally I will do that with footers using this code

ThisWorkbook.ActiveSheet.PageSetup.LeftFooter = or RightFooter etc.

Thank you all for your effort and time wasted !

Cheers!

Quote from royUK

Do you want it adding by the BuildInvoiceAll macro?

That needs checking though?

Or at the PrintCurrent. Is it possible? I can add text under the last row of the table at BuildInvoiceAll using this code

'Application.CutCopyMode = False
'Sheets("DATASET").Select
'LR10 = Cells.Find("*", Cells(1, 1), xlFormulas, xlPart, xlByRows, xlPrevious, False).Row
'Range("A1:E13" & LR10).Copy
'Sheets("FORM").Select
'lrAnotherSheet = Cells.Find("*", Cells(1, 1), xlFormulas, xlPart, xlByRows, xlPrevious, False).Row
'Cells(lrAnotherSheet + 1, 1).Select
'.HorizontalAlignment = xlCenter
'.VerticalAlignment = xlBottom
' ActiveSheet.Paste

But I was thinking if it can be addedd at the last page of the invoice (FORM), above footer , I mean at the last line and not exactly under the table.

Also posted at https://www.mrexcel.com/board/…00879/page-2#post-5861890 and https://www.excelforum.com/exc…an-excel.html#post5657901

Hello royUK . Thank you again for your help

Sample attached.

Hello,

I have a worksheet that collect data from various worksheets and insert them at a worksheet.
I need when I press print , a text that is in another sheet to be placed at the last printed page.
i.e. if the print is 3 pages then then text wil be placed at the bottom of the 3rd page. If 2 pages then at the bottom of the 2nd page etc.
I want the text to be placed at the bottom of the page and not right after the last filled row. (if the text is lets say 5 lines at the last 5 lines of the last printed page).
As you can see at the attached picture the printing consists of 2 pages. At the 2nd page the marked space need to be at the bottom of the page.
The sheet may consist of 3,4, 5 pages or even more. I need the yellow marked shape to be placed always at the bottom of the last printed page.

Thank you in advance

This is also posted at https://www.mrexcel.com/board/…ted.1200879/#post-5861484

Everything ok.

Your advice about tables was correct. I figure it out

Thank you royUK

Ok, I have removed merged cells, and created table, you were right as usual.

My problem is that it doesnt add rows but push the existing rows down and delete everything under it. Is there a way to add rows? You see I need the last rows for the totals.

Here is the workbook at google drive. I still cant upload xlsm here

EXAMPLE1.xlsm

Dimmer Stock,EXAMPLE PRODUCTS,QUANTITY,PRICE 2,PRODUCT 1,1,€2,00 5,PRODUCT 2,6,€9,00 8,PRODUCT 3,11,€16,00 11,PRODUCT 4,16,€23,00 14,PRODUCT 5,21,€30,00…

docs.google.com

royUK I managed to create the table with the formulas. I have some cell merged thats why it didtnt work. My problem is that I need the last 5 rows of the "original" invoice to stay untouched, so the sums will be last. I cant move rows down and not overwrite the rows that are already there.

Is this possible? To have some rows always there and not be overwriten ? And can this be done with VBA?

I hope you understand, my English are not that good as I am not English. Thank you !

I cant attach it , only in zip mode!

Quote from royUK

You haven't answered my question about how you are actually adding the data to the invoice.

By collecting them from Column D from the other sheets of the workgroup. If a product has quantity I collect Quantity and Price and insert them in the FORMA sheet with Description, Price and Quantity. using VBA.