Hello All,
I am new here and would really appreciate your help.
I have a report that gets downloaded each day and may vary in lengh depending on the number of transactions. It is 37 Columns wide by. C150 Rows down.
I want to split it onto 3 worksheets - by either Customer Name or ID No. ( 2 Columns) for onward e-mail.
I have tried a Pivot table but its not working saying the report is too big for the screen.
Any ideas would be welcome.
Regards,
Chevy RV
Last edited by Chevy RV; 08-10-2018 at 09:40 AM. Reason: Make it clearer
.
This macro will search Col A for unique terms and copies the row to a sheet with the same name. The sheets must already exist for this macro to function.
That means you will need to create the sheets with the names / terms you are searching for on the master sheet.
The code can be amended to search any column desired.
Please Login or Register to view this content.
Hello Logit,
I have copied in the Macro , Created the sheets but am stuck with how to change the Search Column to Column AF from Column A?
I have changed the start of the macro from county to ID in Column AF but it is stll searching Column A and saying the Tab doesnt exist for that field.
Also , if there are , say 10 Rows that relate to the 1 ID, will it copy the 10 of them onto the individual Tabs?
Thanks for your help.
Regards,
Chevy RV
.
Here is the edited version for Col AF :
Note in the above where I've inserted AF and the number 32. Column AF is Column #32, begin counting from the left side of the worksheet.Please Login or Register to view this content.
The sheet holding all of your initial data to be searched, is named "Master" in this macro. You can name the sheet anything you want but you will need
to edit the term "Master" to the same name you give the sheet tab. That would be the cause for the error message re: Tab Doesn't Exist.
Hello Logit,
It's nearly there. Its copying the relavant rows across to the other worksheets perfectly but the 1st row or column headings are not being copied over to each sheet as would be needed..
There is a blank row left at the top of the worksheet for the column headings and all.
Any ideas on how to get this row/column headers onto each sheet?
Your help is very much appreciated.
Regards,
Chevy RV
.
Try this :
Please Login or Register to view this content.
Hello Logit,
It is now returning a Compile Error : Duplicate Option statement.
Do i also need to amend it to column AF as outlined before?
Thanks for your help.
Regards,
Chevy RV
Could you use the code Logit supplied in post #4 and reference the cells on the master sheet that you want copied to row one of each customer sheet?
Looking at the file attached to post #2, if I wanted the word 'County' to be placed in cell A1 of each sheet, I could:
1) Select the 'Macon' tab,
2) Press the shift key then select the 'White' tab,
3) Paste the following into cell A1: =Master!A1
The result will be that each of the seven sheets will have that formula in cell A1
If this doesn't solve your issue, please upload a sample showing what you expect as a final result.
To attach a sample workbook (not a picture or pasted copy) click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks