Beginner Help

[jessedharris]

So I am have quite a task, I have a spreadsheet with a bunch of accounts, and they have the county, account name, address etc.... I want to bring them into separate tabs based on the county. I have a tab already for each county, just trying to figure out how I can bring them from the master sheet to the sheet with the proper county. (i update the master sheet and when I add a new account i want it to update on the proper county tab). I have tried vlookup, if, match, etc... I can not get anything to work. Any advise. I could use a pivot table, but the data doesn't change(its not "live")


Thanks

Jesse

 

[jessedharris]

https://www.dropbox.com/s/oiqikywalkiefe4/Harris Customer List.xlsm?dl=0

link to file

 

[hiker95]

jessedharris,

In your reply #10 you have posted images that we can not use for testing.

You are posting pictures. This means that if this was a problem where one needed to use your data, anyone trying to help you would have to enter the data manually. That makes no sense and I doubt that you would get an answer.

 

[hiker95]

https://www.dropbox.com/s/oiqikywalkiefe4/Harris Customer List.xlsm?dl=0

link to file

jessedharris,

I have had problems in the past when attempting to download an Excel file with macros, with the xlsm file extension.

In a copy of your workbook, please remove all macros, and, then rename the workbook using the xlsx file extension, and, then repost on dropbox.

 

[jessedharris]

done sir

https://www.dropbox.com/s/005kgu85xf0s2z1/Harris Customer List.xlsx?dl=0

 

[My Aswer Is This]

After seeing your image:
My script tries to do exactly what you asked for:

You said you had a : master sheet so I assumed the sheet was named "Master"

How was I to know the real sheet name was: "Current Accounts"

But your showing a sheet named: "Current Accounts"

See these are details we need to help you.

And why do you show row (40) of sheet named "Alachua" with "Bradford" Data?

And I notice some rows are hidden.
You should change all the references to sheet named "Master" to sheet named "Current Accounts"

And this is a module script and will only run when you click a button with this script in it or assign the script to a shortcut key. Or run the script from the Ribbon.

 

[hiker95]

done sir

https://www.dropbox.com/s/005kgu85xf0s2z1/Harris Customer List.xlsx?dl=0

jessedharris,

Thanks for your workbook/worksheets.

 

[hiker95]

jessedharris,

When I downloaded/opened your workbook, some strange things occurred in worksheet Master:

Cell A2 displayes Alachua, from the result of the following formula:
=_xlfn.IFNA(VLOOKUP(F2,'Zip Codes'!$A:$C,3,0),"Void")

Cell B2 displays GAINESVILLE, CITY OF from the result of the following formula:
='C:\Users\ my PCs User Name \AppData\Local\Packages\Microsoft.MicrosoftEdge_8wekyb3d8bbwe\TempState\Downloads\[Harris Customer List - Master.xlsx]Current Accounts'!$D47

What is going on in the background of my PC????????

I CAN NOT HELP YOU ANYMORE!!!!!

 

[jessedharris]

I am sorry for all the confusion guys, I am trying to stay with the format that was originally sent to me, I am just going to redo it on my own they way I know how to do it.

Thanks