block

I need to count all blocks with the date and time in it as a unit in a block .F3 sheet Donnie and keep it up to count. This is what i have at the moment but need to add on it. I have two sheets , in sheet Donnie block A1 you scan a barcode , then it writes the Barcode in A1 sheet DDATA(2nd...

File:- https://www.dropbox.com/l/scl/AADY9YPtJ_u41XmixEbGP3-z9vS8-yaN8PQ 1. this file have 6 sheets 2. 1-4 sheet are block name and thier particulars.(Here required Bib No separate sequence for each block. ) each block...

Hi I have spreadsheet & I am hoping to have a block of cells (e.g., A1:D10) locked upon changing a cell (e.g., F15 having an entry of "Yes"). I.e., any other value such as "No" will not lock cells A1:D10. Additionally, anyway to embed the code without having to run the macro each time opening...

I'm trying to create a very simple conditional formatting and for some reason Excel refuses to highlight all the cells. I have a block of cells A1:B4, in the lower left hand cell is a percentage. If the percentage is greater than 0% I want the entire block of cells to highlight blue. Once...

I have a 3 row tall signature block that is inserted 4 rows below the bottom of a dynamic table. I want to insert code that will ensure that the signature block never gets printed between 2 pages. I'm looking for code that will find the location of the last hpagebreak, compare it to the...

Hello all, I have a block of HTML that I need to table'ise in Excel. The format of this data is unfortunately a gigantic block of HTML code with the relevant fields scattered within. It looks like this. You may have to quote my post to get the HTML tags as this forum auto-displays them...

Statement invalid outside of type block: Sub last_row dim last_row as integer rangecopy as range last_row = Range("B" & rows.count).end(xlup).row rangecopy = range("A1:I" & last_row).select debut.print rangecopy end sub

Hello everyone. I need to conditionally shade a range based on the value of single cell. See Image: I need to shade g25:m30 based on the value of G28. (edit - was G26) I have selected the entire block, went to conditional formatting and set up a formula based rule with =g28="QPM" What...

Hi there, I have a dataset that has a Car ID (Unit ID), the time (and date) the driver logged in and the time (and date) the driver logged out. I am trying to calculate the number to unique units logged on during each 15 minute block of time each day and display it in a table with the date...

Hello, I am working on a project that requires 3 blocks of data (1 Column) one after the other. I thought I could use the LastRow Syntax to get this done but it seems to not be updating after I paste the first block on my spreadhseet. My code so far with comments is below. Any help is...

Hi, I have report that puts this block of text after a blank line and I would like to delete it in a macro. The lines of data above are varying length IE 32 rows of data one time then 25 rows the next. data data data *My Open calls Copyright (c) 2000-2018 salesforce.com, inc. All rights...

Objective : Need to make a sheets that will serve as a document tracking and a searchable database. Requirement : 1. I need to make a table where I will input data such as tracking number, date, client name, location, status, remarks, and others. It should be able to accommodate continuous...

Hi, Quick question, hopefully simple question, from a confused newbie. I have 1,000 block of digits, each block is separated by 3 carriage returns in Notepad. I want to copy and paste into Excel and auto number each block - see sample below I want to number each block i.e. Block 1, Block 2...

I need to sort two rows out of 30 blocks of data each block with 25 rows of data. I would like to be able to capture those two named rows out of each block and copy them to a new spreadsheet. First row begins with account number 397 and second row begins with account number 498 followed by...

.... I have 3 cells (vertical), that contain R,G,B values. These "boxes" of the 3 cells is repeated 255 times, making 256 * 3 cells in total. I want all 3 cells in each "box" to be coloured to those RGB values, whenever any one of them is changed. I'm having a mental block at the moment, and...

Hello Friends I have a data base of address around 30k in the below format... Mr.Vijay Kumar N # 007, 1st Block Wilson Garden Bangalore - 560027 I need the Name in A1 & the complete address in B1 Eg N Vijay Kumar in A1 B1 - # 007, 1st Block, Wilson Garden, Bangalore- 560027... I tried using...

In the chart they use block letters. (square). I don't seem to be able to fine the I, L, O, U in block format. does anyone know if they exist, or if I can create them some how? Thanks Mikal

Hello, I am looking for some assistance on trying to come up with some VBA code to check that an ID number isn't repeated for a particular block of data. The data block sizes can change though. Here is a sample of the data. <tbody> B C D E 23 1000 x x 02022018092900 24 2100 x x PG001...

Hello everyone, I am trying to use If functions to track certifications. I thought this was going to be relatively easy but to be honest I'm stuck. The certification is good for 300 days after that they need to get recertified. The formula works until there is a date that is way our of the...

Hi all, hope you can help. In column E, I have Surname/s in block capitals followed by a space and then Forename/s with capital first letter and lower case the remainder. The question is there a way to separate Surname/s in one column with the Forename/s in a second column? I can use text to...