starting

Good Day, I have been working on this vb code based off some of your code, for building fillible forms. We are having an issue with the Private Sub SaveClient_Click Subroutine. The reason I changed the cell numbers, is to move them to the starting location on our workbook. as we want to have...

Hi i have searched everywhere for this and i have found a few examples but they don't seem to work for me so thought i would try here ! basically i have a date column starting from B6 a profit column starting from C6 and a difference column starting from d6. basically i have the dates for...

I have a directory of Excel files which are present in several sub-folders. I also have Information in column A of my Worksheet 1 (which will be the active sheet) and will be an exact match to the folder name. I would like to design a macro which searches all of the folders in a specified...

So I am trying to create a formula to equally spread a given cost X starting at year Y and spread over Z amount of years. Ex <tbody> Cost X Start Year Y Spread over Z years 2019 2020 2021 2022 2023 2024 2025 1000 2020 5 0 200 200 200 200 200 0 </tbody>...

I have the code shown below that someone suggested to me, but I need to change it so that a specific directory is given as starting point for users to then browse for folders to be placed in a user form listbox. I have no idea what to change to make this happen. Any advise would be appreciated...

I am trying to make a measure that combines a starting budget and a revised budget to create a final budget. As an example of what I am looking for, some line items have a starting budget (say $200) and no revised budget ($0), so the final budget would be $200. Some line items had a starting...

Hi everyone. I've got a table detailing employee information, including starting and expiring contract dates, with all the relative pivot tables and pie charts. I'm trying to find a way to dynamically get Excel to list every year in between the date the employee started working for us and the...

Hi everyone, I have starting in columns BX7,BY7,BZ7 digits ranging from 0 to 3 (0,1,2,3 ) and I wanted to count each digits as they go down by rows in separated columns. (0) starting in cell CB7 (1) starting in cell CD7 (2) staring in cell CF7 (3) staring in cell CH7 See example below ...

I need a macro that will delete all applicable rows in the spreadsheet if the value in column C from row 5 down = "Yes". There are breaks/blanks in between my "Yes" values, so it would have to go from the bottom up to determine the last row that could possibly need to be deleted. I thought I...

Good Afternoon Excel Gurus, Need help from the gurus with a quick formula to achieve the following result. I have a lot of sheets to fix and all sheets have 1000's of rows. Column A has tags starting with numbers and some starting with characters. I am trying to write a formula that can...

Hi all, I am looking o use the traffic light system to show any dates in a cell the exceed the current date by 1day, 2 days and 3 days, but if no date just remain blank Starting in K16 thru K512 I was trying =WEEKDAY(TODAY(),1)>1 but cannot seem to get this working correctly Thanks for any help

Hi, I am looking to create a headcount query that has 5 fields: Week #, Start Headcount, New Hire, Attrition, End Headcount I would like Week #2 Starting Headcount to = Week #1 Ending Headcount I keep running into a circular reference issue and I completely get why. If I create a Week #1...

I have a massive list of employees who worked more than ten hours in a single shift. A2 = John Smith B2 = 7/15/18 C2 = 11:57 AM D2 = 4:03 AM My problem is that we use ADP and in our system, you can clock in 7 minutes before or after the start of your shift and still get credit for starting at...

Hello, Is it possible to work with gaps.There must be a gap of 8 days between visits throughout the year.Can I do this automatically?Location X must be scheduled every 8 days for a visit, starting on 2 JanuaryI do not succeed with macrosWho can help me dave

Hello, Looking do do a vlookup to pull back multiple records for the same lookup value. for example in sheet1 starting A1 <tbody> Item Vendor 1234 11237 </tbody> I want to lookup all values that start with 11237 in sheet2 starting A1 <tbody> Vendor ship 11237-00001 11237-00003...

Hello! How to identify the first non zero cell in a row but starting from the right end? I basically need to make red the cells at the right of the above identified cell. Any hint? Thanks!

Hi I am reading one article about data validation and it says: "if a user accidentally enters the wrong date or data is missing we want to be able to set in place some rules of checking that information, this is known as validation." My question, can we use data validation to make sure user did...

Hello! I want to use a function that utilises a range, such as =ROWS($H$8:H8) where the starting point of the range is fixed. How do I do that if the starting point is returned by another function? How to make that starting point fixed? Thanks!

Want to copy range A1:I100 from sheet 1 workbook A to range starting cel B2 in sheet2 in workbook B

I am new to the forum and new to Excel. Work book contains 2 sheets, Sheet 1 Column C, beginning at C2 contains names, that may or may not duplicate, Column D, beginning at D2 contains Company names, that may or may not duplicate, Jumping over to Column J, J2 contains a numerical value...