holds

Hello! I have a line of code Range("A1:LastTableCell").Copy Worksheets("PasteSheet").Range("PasteToHere").Value This keeps giving me an error, and I'm guessing it's because I'm using variables. LastTableCell and PasteToHere are both variables that contain addresses. For example, LastTableCell...

Hi there, Need a little help if anyone can please. One column holds data of names of staff who try to make appointments, for this instance "Dave" "John" and "Trevor" Another column holds a list of appointments made set to a simple "Yes" or "No" A 3rd column lists a value of sales that result...

I have a spreadsheet where Column A holds a document reference number, Column J holds a type (fixed rent/insurance/service charge), Column K holds a status (invoiced/to be invoiced), Column L holds a target date, Column M holds a target amount. What I would like to report on, is for each...

I need to return a latest date from a table but filter down on an ID I have 2 tables AD Visit - Holds details of visit dates and can have multiple visits for an ID AD Completed - Holds the ID and needs to show the latest date for an ID The last vist date needs to work on up to the last 8...

I have 2 tables: Table 1 - Holds all of the data about companies Table 2 - Holds all of the staff names in my company Is there a way to create some sort of calculation which shows: Total Distinct values in 'FieldX' (Table 1) where 'StaffMember' (Table 1) is equal to 'StaffMember' (Table 2)...

I have a spreadsheet that tracks some things. Column A holds a date, Column B holds a #; And Column C holds a $ amount. I want to change the font of Column C to red if Column A plus Column B is Greater than today. So for example; <tbody> A B C 6/10 10 $100 6/1 10...

I am using a "Workbook_BeforeClose" operation to hide all worksheets except one. This is working fine for now but as I move through the process, I want to be able to change which sheets are visible. Within the application, I have a login in function to control visibility but when the workbook...

I'm trying to switch surename and first name in column B, and put new name into column C. This bit of vba is working ok. But I only want this to be done if there are 11 digits in column A in the same row. Column A holds numbers, 11 digits for persons and 9 digits for companys. Column B holds...

Hi folks I have an accounting spreadsheet which has, as one of its columns, a 3 character accounts code. Another column holds the value associated with this code. For example, column A holds the account code and column B the value: ES2 $4.30 I'm looking for a formula, please, which can scan...

Hi all In cell E2 I have formula to get total time worked through a range of days, this total is formatted as [h]:mm for example if cell E2 holds value 9:23, this means total worked is 9hrs 23mins in Cell R2 I have the actual total salary received for this same period for example if cell R2...

This is my first post. Thank you in advance for taking the time to assist me. I have a formatting question that involves calculations. I have data with several columns, with the focus on 2 columns, namely the 3rd column ("C") and the 8th column ("H"). Column "C" has repeating values and...

Hello there, I have a range of numbers in different columns. Col A holds serial numbers (Sl No.), Col B holds From Number & Col C holds To Number. If i need to select the corresponding Sl No. for a number (say in this case it is 426.00) that falls between 401.00 & 500.99, how do i get...

Hi I have a spreadsheet with 2 worksheets. Sheet1 holds a list of Names I.e. Mark, Paul, Peter etc Sheet2 holds daily data, Column A = 1st day, Column B = 2nd day etc (this information changes month on month when new data is pasted in), it holds the name of the person and then below it holds a...

Hi all I'm stuck with the following problem. I want to be able to change the number in a cell based on a percentage in another cell as follows:- Cell A1 holds the dynamic number, Cell A2 holds the %age number. Logic for cell A1 needs to be:- If A2 value <=65% then A1 shows number 5...