all you mentioned was the clock speed -- the clock speed is irrelevent (more or less) as there are other factors which make a big difference (model numbers would have been more helpful)
since you didnt specify, im going to assume you are talking about moving from an E6300 to an E6600: (if you have, for example a E6320, this changes my answer)
going up, you will double your L2 cache -- which is much more important (imo) than the additional clock speed, you do also get a better clock on that as well
though, if your MB supports it, i would recommend going with the E6750 instead (my price, its actually about $15 less) as it has an even higher clock, and a higher FSB (very important) -- however, it will require a MB which can use a 1333 FSB (many cant -- esp older ones)
however
Maybe I would be best to just buy another 1GB memory card?
you didnt specify, but you imply that you only have 1GB of RAM? i would definitely double that before thinking about any CPU upgrade
my recommendation:
if you have less than 2GB RAM, upgrade that
if your CPU is the E6300 (and not the E6320), then upgrade your CPU (get the E6600 if your MB cannot support 1333FSB, or get the E6650/E6750 if it can)
if your CPU is a E6320 (or otherwise has the full 4MB L2) then unless your doing a lot of CPU intense activities (in which case you probably already know what you need), there are probably more important things to upgrade/improve)