Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #23  
Old 03-21-2016, 08:22 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 Clarification!

Sorry my last post wasn't very clear.
This is the present set up -
In my Donors table the 2nd column contains the same information as is in the 2nd column of my Bank table. And so the coding that you provided me with made that link and allocated the money received from each donor in accordance with their percentages for each of a number of projects.

What I am trying to do -
1. In the Donors file the 4th, 5th & 7th columns contain the Name, Surname & Postcode for the donors.
2. In the other file (let's call it 'Tax') the same information is in the 2nd, 3rd & 5th columns.
3. The combined information in all 3 fields must be unique - there can be donors with the same Name & Surname but with different Postcodes so that is why I need to check all 3 fields for my latest project.

So my question is - can the VB code provided a year or so ago (which is working perfectly) be easily adapted to check the 3 fields instead of just one?
And I assume that if I use the same file (say 'Tax') as the 'Ledger' I will be able to get the result of applying the percentages from the Donors file to be added to the tax file.
I trust this helps to clarify what I am trying to do now.
Reply With Quote
 

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:14 AM.


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