block

Is it possible in VBA to disable inserting partial rows to let the user only insert full rows. Protecting the worksheet is no option because of all the macro's behind the worksheet. Thanks in advance :)

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

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

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

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

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

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

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

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

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

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

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

Is this acceptable practice ?

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

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

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

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 ?

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

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.

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