You can't have the macro in a separate file, it needs to be in the main fcw32.mac macro file found in the CC3+ data directory (Not the installation directory from your screenshot).

Technically, you can have it in a separate file, but that means loading the file first with LOADMAC, but that isn't a very good idea since that causes the main macro file to be unloaded, and CC3+ relies quite a bit on that one.

Macros can also be stored in separate files if you load them as script files (*.scr), these can then be run directly with the SCRIPT command. Script files only contain one macro, and should not have the MACRO and ENDM lines at the start/end, but are otherwise the same.

Yes, you can just copy stuff over from one CC3+ data directory to another, including symbols and drawtools and anything else in there. Just make sure you don't overwrite something you didn't intend to. But unless you have messed up your old data directory somehow, and you are running the latest update, most files should be the same anyway.

The only thing to be aware of when it comes to custom stuff, is the question if you made sure to always use relative paths. Of course, if the locations are exactly the same on the new PC it doesn't matter, but if they aren't, you may end up with some red X's if you have used absolute paths in your symbol catalogs and such.

Just view Sheets the same as layers in Photoshop. They work basically the same way. The naming confusion is just a result of the fact that when image editors started using what they call layers, they completely ignored that that name was already in use and had a different meaning in the CAD world.

As for layers, I don't recommend ignoring them completely, but for the most part, layers are set automatically and don't influence the outcome, so you can actually do most maps without thinking about them at all.

Unfortunately, it doesn't support ranges.

Maybe doing selections by name instead will help? (It's a bit down the page in the article)

Your buildings have entities on the wrong layer. This is probably caused to how the random building/street command works. The correct layer is set when the symbol catalog is loaded, so if it changes after that, it can cause issues with this command. It can be worth checking that the correct layer is set every so often.

Fortunately, it is easy to fix.

To fix it for future placements, simply change the layer shown in the status bar to one of the city demographics layers; the ones named BLDNG (XXX).

To fix buildings already placed in the map, either simply delete and recreate them, or use the Change House Layer command found in the City menu on them. Note that after selecting the buildings and Do It, the command line will prompt for a layer. the easiest is to right click inside the map to get the layer dialog, then pick the appropriate demographic layer, hit OK, and when back in the map, hit the refresh button to update the display to actually see the change.