Forum Discussion
Automate data entry from another workbook
Please help me, i want to automate a task in excel but i don't know how to do it since data extraction is complicated. Here's what needs to be done: 1. When i enter the JT number excel should be ...
Small and fast VBA solution from sheet to sheet
Sub commanbutton1_click()
Sheets("Tabelle1").Range("B25:G500").Copy Sheets("Tabelle2").Range("B2")
Sheets("Tabelle3").Range("B25:G500").Copy Sheets("Tabelle4").Range("B2")
‘ect.
End Sub
Small and fast VBA solution from workbook to workbook
Sub test()
Workbooks("test1.xls").Worksheets("Sheet1").Cells(1, 1).Copy
Workbooks("test2.xls").Worksheets("Sheet1").Cells(5, 5).Paste
End Sub
*With both proposed solutions, the areas / cells / workbooks would have to be adapted to your requirements.
Best regards,
nikolino
I know I don't know anything (Socrates)