Combine data from different sheets in Book1 into new sheet i

Keyboard macros or custom scripts

Combine data from different sheets in Book1 into new sheet i

Postby MayDay1988 » Sun Apr 23, 2017 8:20 am

I have data in a few tabs in Book1 and when I run macro (button locate in Book2) I want to combine everything into new sheet in Book2. However, it isn't just copy and paste.
In my book1 I have COL A:F that contain same info that use for G:P some COL are blank.
When combine data I want A:F to repeat (add more rows) for when G:P isn't empty.

I have attached Book1 which the data and Book2 how I wanted it to look like after run macro. Is there a way to do this? I actually have more than 2 sheet to combine but the attached example should be good for the example.

Thank you in advance!
Attachments
Book2.xlsx
Result
(11.94 KiB) Downloaded 64 times
Book1.xlsx
Data
(8.96 KiB) Downloaded 62 times
Microsoft Office 2010 on Window 7
MayDay1988
 
Posts: 1
Joined: Sun Apr 23, 2017 8:17 am

Re: Combine data from different sheets in Book1 into new she

Postby FJCC » Sun Apr 23, 2017 3:37 pm

Hello! You seem to have chosen the wrong forum to ask this question.Your signature says you are using Microsoft Office and this forum supports OpenOffice and other programs closely related to it. You may get an answer here but your are more likely to get help at a forum dedicated to Microsoft Office
AOO 3.4 or 4.1 on MS Windows XP ( before 2013-08-03) or Windows 7
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 6582
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA


Return to OpenOffice Basic, Python, BeanShell, JavaScript

Who is online

Users browsing this forum: No registered users and 2 guests