worksheet reference

I am trying to add a vlookup code to a cell and have to reference the worksheet to the left/second to last sheet in the workbook. The name will change since it's a date, not always the date prior because of the weekend. Some things I tried are below, none worked ... Dim sh As Worksheet Set...

Good morning everyone Apologies in advance if this is a real beginners error but I just can't figure out why its doing this and its causing quite a problem. Background: I have a master spreadsheet that we use to plan transport based on product lines that have been requested by my customer and...

I am trying to have vba enter a sumif formula into cell E8 on the sheet named "EOC" Based on the sumif formula (below) here is the information I have: =sumif(range, criteria, sum range) Range: The range for the sumif formula is column AF of a particular sheet. The sheet however will change...

I am trying to create a budgeting spreadsheet that contains 26 worksheets that represent 2 week expense cycles. The worksheet will tally all the expenses in its 2 week cycle, compare them to a target budget, and calculate the remaining budget. I would like to roll the remaining budget over to...

This is my first post so I hope to get some good easy feedback. I am making a document for quoting materials and the first worksheet is quoting, all others will be Material Data Sheets. I want to make a drop down list on the first worksheet that can choose from any of the available materials...