Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-24-2014, 06:21 AM
gmayor's Avatar
gmayor gmayor is offline Can I autofill cells using percentages from another spreadsheet? Windows 7 64bit Can I autofill cells using percentages from another spreadsheet? Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 4,142
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

Nothing really to get your head around. Open the process workbook. Click the button on the Add-Ins tab and follow the instructions. Test with the workbooks you provided.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #2  
Old 11-24-2014, 09:39 AM
Baldeagle Baldeagle is offline Can I autofill cells using percentages from another spreadsheet? Windows 8 Can I autofill cells using percentages from another spreadsheet? Office 2013
Advanced Beginner
Can I autofill cells using percentages from another spreadsheet?
 
Join Date: Apr 2012
Posts: 62
Baldeagle is on a distinguished road
Default

Sorry - when I posted my initial reply I hadn't, at that stage, discovered how your process actually worked!!

I have now tested it and am very impressed. If it wouldn't take much more of your time could I ask two follow-up questions?
1. Would it be easy to adapt the coding to simply put the information from the Bank Transactions file into the Ledger (without attempting to fill the 5 Project cells) if the donor's information wasn't already in the Donors file? I got an error when it came to a new credit which hadn't been identified in the Donors file in advance. I would prefer in such a situation to populate the first 3 columns in the Ledger only (rather than stop the process with an error message).
2. If at some future date we were to change the layout of the Ledger (with additional columns inserted) where would I go looking for the piece of coding that I could adapt to find the right columns?

I really appreciate the work that you have put into this - it will certainly improve the ease with which the charity can handle their monthly recording of credits.
Reply With Quote
Reply

Tags
auto fill



Similar Threads
Thread Thread Starter Forum Replies Last Post
Autofill Address dazwm Outlook 13 08-21-2013 09:28 AM
Can I autofill cells using percentages from another spreadsheet? Autofill Automation Parkiee1981 Excel 4 03-15-2013 01:24 PM
Can I autofill cells using percentages from another spreadsheet? How to calculate percentages??? fabthi Excel 3 04-13-2012 12:08 PM
Charting percentages within a percent Tom0822 Excel 0 03-05-2012 08:50 PM
Can I autofill cells using percentages from another spreadsheet? Need cells to autofill with color Silver Rain 007 Excel 1 10-22-2009 08:19 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:43 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft