Quote:
Originally Posted by thumb
If I have to edit something, say like deleting an entry, do I highlight both cells of that entry and right click it and choose Delete and when the popup window comes up and asks how I should move the cells, would I choose 'Shift Cells Up'?
|
That's one way. It's likely you'd need to run the macro to refresh the links on the
PrintMe sheet as you'll have deleted cells which had a link to them (there's no harm in running this macro at any time). Another way is just to highlight both cells and press the delete key on the keyboard. Be aware though, that when sorting, because you'll have created an entire blank row, you'll have to be sure that ALL your data is selected before sorting (Excel will think it's two tables (or more)).
Quote:
Originally Posted by thumb
Another question is can I change the name of the file when saving it if I want to like change your MSOFFICEFORUMSXXXX.XLSM to Games_Name.xlsm?
|
Yes, either change it manually in
File Explorer (aka
Windows Explorer), or use
File|Save As to save it under a new name (you will still have a back-up copy under the original name).
Quote:
Originally Posted by thumb
Another question, when I do edit something, do I have to do it in the EditMe sheet or does it matter?
|
If it's data, edit it on the
EditMe sheet only - that's the point; to separate data changes from the display/print-out. If you want to change output column widths, shading and such like, then you do that sort of thing on the
PrintMe sheet.
Quote:
Originally Posted by thumb
Last question, I have another file for Utility that I have set up exactly the same way so could I just open that file up and add the Macro to it?
|
Yes, but make sure the sheet names match on the code lines with the
'adjust' comment.
I see on your original workbook you had many connections/queries: one to a file on your desktop called
games1.txt, and many to a file called
games2.txt. This is where you've imported data into your workbook. These queries are all over the place and would mess up your sheet if they were to be
refreshed. Really, they should be deleted (along with their associated
Names). If you want me to do that then attach the file here, otherwise if you were confident enough you could run a little macro, only once, to delete them:
Code:
Sub LoseConnectionsAndNames()
For Each connectn In ActiveWorkbook.Connections
connectn.Delete
Next connectn
For Each Nm In ActiveWorkbook.Names
Nm.Delete
Next Nm
End Sub
Note that it works on whichever workbook is the Active workbook, which may not necessarily be the workbook you put the code in.