Get all sheet data in Sheet RESULTa in the workbook if there is data in all other sheets.
All sheet data starts from column A1.
First row and first column data (any text or number cobination) position is fixed in Sheet1, Sheet2, Sheet3.
The data appears as below as when there are four sheets (Sheet1, Sheet2, Sheet3) in the workbook from A1 cell in each and the result as in the image will will be in RESULTa sheet. Data is coloured only to help in understanding:
dom.png
Last edited by vikim; 01-06-2019 at 07:22 PM.
Attaching a sample workbook enables others to work on your problem:
To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.
Click on GO ADVANCED and click "manage attachments" to open the upload window.
To add a file to a post
File attached.
Check it out
Please Login or Register to view this content.
The code is showing 'Runtime error 1004'.
I want to get only the data.
Last edited by vikim; 01-08-2019 at 03:20 PM.
Why are you getting an error?
Yes. When a sheet between others is empty.
Color based selection is not important. I need only the data.
Notice in the code you can ignore sheets you don't want to use. I can only supply a code for the wb sample you supplied.
Remove the lines with the color code
Worked. Thank you very much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks