VBA Code or Excel Function For Multiple Sheets in a Workbook

rjamend3

New Member
Joined
Apr 28, 2017
Messages
2
I know that there are probably threads that have answered this before, but I figured I'd start a fresh one as most of them are pretty old.

I have a workbook that was given to me where each participant receiving quarterly payments has their own tab (50+ tabs). Each participant has their own unique participant number as well as their own compounding fixed interest rate for their payments. Right now, I am manually finding the quarter and copying pasting it into another spreadsheet which leaves way too many opportunities for errors. I really was hoping that there could be a way to have a "master sheet" where I could input a date and a code runs iterations across all the different tabs and pulls the participant's name, date of payment, "weight of the payment", participant number, and the amount payable.

I have bought a "VBA Coding for Dummies" book, but I would at least like to know where to start on trying to build this code/function.

Thank you in advance for any and all help!
 

JackDanIce

Well-known Member
Joined
Feb 3, 2010
Messages
9,334
Welcome to the board. It's quite broad and open what you're asking without enough specific details about your requirement (e.g. workbook name, summary sheet name, cell locations, source and detination details etc).

If you consider no-one can see your PC screen right now, how would you explain the problem then, say to a blind person?

This is a simple loop to loop through all the worksheets in the workbook the macro is called from:
Code:
Sub LoopSheets()

Dim ws as worksheet

For each ws in Thisworkbook.Worksheets
  ws.Select
  ws.cells(1,1).select
Next ws

End Sub
 

rjamend3

New Member
Joined
Apr 28, 2017
Messages
2
Sorry to be so broad. Each sheet represents an individual participant which is also the name of each sheet. In each sheet,Column B is the number of payments remaining, Column D is date of the quarterly payment, and Column E is the Payment Factor that is multiplied to the final balance which gives you the gross quarterly payment amount. I would like to have a Sheet at the beginning of the workbook called the "Master Sheet" that I could put in a quarterly payment and it pulls the the participant's last name, payment factor, and the remaining payments. Once I have this information in the "Master Sheet", I would like to be able to copy and paste the payment information to another workbook to have it sent down to process the payment information.

Please let me know if you need any other specific information.

Thanks!
 

Forum statistics

Threads
1,081,556
Messages
5,359,553
Members
400,533
Latest member
fpenning

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top