Reply to thread

Message

<blockquote data-quote="Heretic Apostate" data-source="post: 895977" data-attributes="member: 696">Dang it, I was SO trying to make it fit onto one 3.5&quot; disk.&nbsp; I'm up to 2.34MB (including all the data, so it'll be probably 500kb smaller when I empty it).&nbsp; *sigh*Maybe zipping it will remove some of the size?&nbsp; How much compression does zipping a spreadsheet usually get?***********Okay, an update, before I take a break to clear my mind. <img src="https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png" class="smilie smilie--emoji" loading="lazy" width="64" height="64" alt=":)" title="Smile&nbsp; &nbsp; :)"&nbsp; data-smilie="1"data-shortname=":)" />Somehow, I don't know why, but I thought that sumif required that it be on the same page as the data?&nbsp; I cut-and-pasted the summary table onto its own page (which they're used to), and the sumifs still work.&nbsp; Oh well, that saves about 1320 calculations, woo hoo!I need to set up the macro for the advanced filters for the specifics table.&nbsp; Shouldn't be too hard, as I have the criteria already set up, and I can copy the format from the first eight adv. filters.&nbsp; Same thing for the two detail tables.I need to bring in the macros for autofilter/set print area/printing from the old spreadsheet for the summary (regular and TANF versions), specifics, and both of the detail tables.I need to create a &quot;Clear All&quot; macro, to set the spreadsheet up for the next case.And I need to bring in the &quot;Export Data&quot; (basically, open a new worksheet, and paste in the raw data and corrected dates; when you have to research a ton of dates for a person, you REALLY want to save them for next time) from the old spreadsheet.I should easily have this done within a couple days (since I'm taking it easy <img src="https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png" class="smilie smilie--emoji" loading="lazy" width="64" height="64" alt=":)" title="Smile&nbsp; &nbsp; :)"&nbsp; data-smilie="1"data-shortname=":)" /> ).Thanks, guys!&nbsp; I'll yank your examples for my macros.Can y'all recommend an easily-obtainable visual basic book (like one I can check out from the library)?&nbsp; I'm not great at VB (I'm beyond the &quot;monkey see/monkey do&quot; of just recording macros; I can actually generally go in and figure out what the macro did, and adapt and edit it to my needs), and I'd like to get better.</blockquote>

[QUOTE="Heretic Apostate, post: 895977, member: 696"] Dang it, I was SO trying to make it fit onto one 3.5" disk. I'm up to 2.34MB (including all the data, so it'll be probably 500kb smaller when I empty it). *sigh* Maybe zipping it will remove some of the size? How much compression does zipping a spreadsheet usually get? *********** Okay, an update, before I take a break to clear my mind. :) Somehow, I don't know why, but I thought that sumif required that it be on the same page as the data? I cut-and-pasted the summary table onto its own page (which they're used to), and the sumifs still work. Oh well, that saves about 1320 calculations, woo hoo! I need to set up the macro for the advanced filters for the specifics table. Shouldn't be too hard, as I have the criteria already set up, and I can copy the format from the first eight adv. filters. Same thing for the two detail tables. I need to bring in the macros for autofilter/set print area/printing from the old spreadsheet for the summary (regular and TANF versions), specifics, and both of the detail tables. I need to create a "Clear All" macro, to set the spreadsheet up for the next case. And I need to bring in the "Export Data" (basically, open a new worksheet, and paste in the raw data and corrected dates; when you have to research a ton of dates for a person, you REALLY want to save them for next time) from the old spreadsheet. I should easily have this done within a couple days (since I'm taking it easy :) ). Thanks, guys! I'll yank your examples for my macros. Can y'all recommend an easily-obtainable visual basic book (like one I can check out from the library)? I'm not great at VB (I'm beyond the "monkey see/monkey do" of just recording macros; I can actually generally go in and figure out what the macro did, and adapt and edit it to my needs), and I'd like to get better. [/QUOTE]

Verification