# block

1. ### Different sort criteria in single data set

This is one for a hobby. I have a card collecting spreadsheet that lists all available cards with columns for various stats like name, weapon, class, etc. Final column is either owned, wanted, or just blank. I set up a quicky VBA macro to sort everything by my desired "order of columns"...
2. ### Copy paste block with hidden rows

I need to add code to a macro to copy and paste a block of cells that include hidden rows of data, sample code Selection.SpecialCells(x1CelltypeVisible).Select Copy Range(A4:B10).select Application.CutCopyMode=False Range(A4:B10).select Selection.PasteSpecial Paste:=x1PasteValues...
3. ### select the most recent value from one block of 10 columns

Hi everybody, I have one block of 10 columns. The 10 columns contain data ordered by year (from the most recent to the oldest - 2019 - 2018 .... - 2010). Example of block of 10 columns: <tbody> company A 2019 A 2018 A 2017 A 2016 A 2015 A 2014 A 2013 A 2012 A 2011 A 2010 value...
4. ### Formula to Count Cells

Hi can anyone help with a formula? On Sheet1 I have headers in cells "A1:D1" A1 = Ref B1 = A C1 = B D1 = C On Sheet2 I have Data with headers in 3 separate blocks with 7 columns each: "B1:H" "J1:P" "R1:X" "B1:H1" - headers = A "J1:P1" - headers = B "R1:X1" - headers = C On Sheet1 in the...
5. ### Count of cell blocks

Hi all, I am trying to solve a pattern problem and need your help desperately. Is doing my head in. So I have a number of clients that have booked an appointment. As you can see in the file the weeks are at the top. What I want to find out for each customer is: 1. count the number of...
6. ### Recalculate Split Binary Columns

Firstly, forgive to code tags, I can't seem to work out how to attached a sheet with excel genie. Looking at the chart below the top row is the binary header value for the columns and each row has been split into single cells. The first block uses the values 3,4,5,6,7 converted to binary. The...
7. ### AutoPopulate Records Based on Dates

I have a budget forecast workbook where I track my upcoming recurring bills along with all my transactions - be it cash, ATM, check, etc. This also includes any deposits. It is basically an electronic check register with a budget forecast function. There are three ways I gather/enter data: 1)...
8. ### Schedule chart help

Hello! I am trying to create a chart to represent block schedules by date. So far I set up my table and chart as you can see in the image in link ( https://photos.app.goo.gl/KKYhpmq6LVXaVtAP7 ). I am stuck with the following: If a date has more than one block (overlapping or not), can you...
9. ### Block Schedule Chart Question

Hello! I am trying to create a chart to represent block schedules by date. So far I set up my table and chart as you can see in the image in link ( https://photos.app.goo.gl/KKYhpmq6LVXaVtAP7 ). I am stuck with the following: If a date has more than one block (overlapping or not), can you...
10. ### Separate number into their own cells, but more advanced.

Good morning, Excel gods. I need help yet again. I have a lot of data in on cell that I need separated into their own cells. <tbody> 866-0108 1/15 LB BONGARDS BLOCK YELLOW CHEDDAR 2.10 2.13 .03- 87.00 109.62- </tbody> This is what is in one...
11. ### Excel Formula - Incrementally Add a +1 to a Header Name each time it is copied/pasted

Hello Group, I am working on a project and need one last piece to wrap up this file. Explanation: I have a block of Data B2:N15, There are various formulas within the block that link to other sheets and some manual entry fields. I have set up these blocks so that a user can copy a block and...
12. ### Exit Function inside With-End With block

Is this acceptable practice ?
13. ### If data is in between or equal to 2 dates, display a number

Sheet1: <tbody> Block 1 Block 2 Block 3 2019-05-20 2019-05-23 2019-05-27 2019-05-22 2019-05-26 2019-05-31 </tbody> Sheet2: <tbody> 24 Cat 2019-05-21 25 Dog 2019-05-27 26 Bird 2019-05-24 </tbody> ** In column B, I used data validation to create a list: 1, 2, 3 Sheet1 defines...
14. ### cell is starting point of range of values

Hello How to place a large data block at a chosen cell I know I can copy the range and paste it at the chosen location, but I would like to simply use block = Range("BB1:CC50") Range("A1").value=block currently all I get is the first cell into A1. I would like the entire block to appear...
15. ### Can a Measure create more than one value?

Hello and thank you in advance if you can help, I am VERY new to using measures. I am using Excel 2019 on a PC. I have created some measures that will give me a distinct count of species in a query/dataset, as well as a distinct count of blocks. My data has fields/columns for All Regions...
16. ### EXCEL 2013 Sheet and blocks barcode

Barcode scanner, 60 sheets. I need the active block to be A1 on a specific sheet . So if Paul scans his barcode i need the active block to go to his sheet, and if john scans his barcode i need the active block to go to John s sheet A1 ?
17. ### Select Case Issue

In general, is/are there condition(s) in which Excel VBA will not recognize a "Select Case" statement? My current project is failing to compile (Error: Case without Select Case)) even though "Select Case" is obviously in the code just above the first case. (It is not within another Select Case...
18. ### Scan barcode

I have 20 workers , each with a barcode.I need the active block to be A1 on a specific sheet . So if Paul scans his barcode i need the active block to go to his sheet, and if john scans his barcode i need the active block to go to John s sheet A1 ? Can it be done ? Thank you.
19. ### EXCEL 2013 Sheet and blocks

EXCEL 2013 Sheet and blocksI 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...
20. ### EXCEL 2013 Sheet and blocks

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...