Macro code editing to collect extra lines of Data

**Cupragsw** · 06-17-2014, 06:27 AM

The following code produces a spreadsheet with the following titles and data

Miro Ref Resolver 2 Customer Acceptance Customer Number Customer Name Resolver 2 E/C Number Resolver 2 Manager Resolver 2 Site

Please Login or Register  to view this content.

However, i need this to pick up an extra colloum from the 3 sheets

the extar coplloum i need is F from each of the 3 sheets

current it picks up A,L,R,V,W,Z,AA and AB

How can i amend it to collect the F colloum

might seems easy but i have inherated this spreadsheet and Macro so i am working around procedures created by someone else who is no longer in the busniess

**davesexcel** · 06-17-2014, 08:22 AM

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic