thoughts

Is it possible to have multiple people share the same workbook with different permissions? Let's say everyone has access to the workbook file, but they have to have a passcode to view a certain tab? OR If you create the spreadsheet tabs to be very hidden, is it possible that the person who...

Not sure what has happened here or what I may have done, but what I'm typing in VBA the range is not recognized. Any thoughts as to why? Sub TestThis() range("A1").CurrentRegion End Sub Notice the range does not capitatlize.

I've seen a similar question to the append with the heading of "Using a variable in a formula", but I can't fine the correct syntax for my particular problem which is as follows: =DATE(YEAR(summary_start_date)+1,MONTH(summary_start_date),DAY(summary_start_date)) I want to change the + part...

I want to match "Order IDs" and add the "sku items" for a total kit count. Thoughts? Thanks R. Turner

The bold underlined formula below is equating to 9.63 for the selected fields, which should default to the second concatenate, but for some reason it is defaulting to the first concatenate. Any thoughts on why...

I have multiple text strings containing A(a), B(b), C(c), etc. A and a are related over and thousands of these are in one sheet. I want to replace A(a) with a and B(b) with b, so on. Any thoughts please? EX: Optimizer Mode(OM) -> OM Home Snoop(HS) -> HS

I have had these lines of code in a program for two years. Sheets("ShiftReport").Select Range("B2").Select ActiveCell.FormulaR1C1 = CDate(frmShiftOnDuty.dtpShiftDate.value) It has worked without any issues, in fact this very section of the code ran yesterday. No code changes...

Has anyone ever given this a try to see if this truly does speed up your code vs running functions natively: https://analystcave.com/vba-compiler-add-in-to-vb-net/ Curious of everyones thoughts. Seems like an interesting concept if this is true that DLLs would run quicker.

I'm sure this has been asked before I need to do a countifs > or = one cell then < or = another cell and and third crietera equals "Yes" This is on office 365 excel when I put the expresion into the cell it just shows the equation. =COUNTIFS(Input!A:A,(">="(Output!C1)),Input!E:E,"Yes") I have...

Hi! I am looking for a macro to put several rows of typed wording into one row of text. I copied a closed captioning transcript from a video into excel and it puts the entire script in short sections in several rows. I am hoping to be able to easiely condense it to then copy it into Word...

Hey all, Seems easy but I can't quite get it all together. I'm looking for a way to have this vba used in row J only if there is text in row B. Sub Test1() If (Range("I6").Value = Range("I2").Value Then Range("J6").Value = "Y" End If End Sub Basically having 2 cells (I6 and I2) checked if...

Hello all i hope your sunday is well I have a table that in column E i have 3300, 2220, 1300, and 2000 what i need to get is... iF E contains 3300 then REturn Range B once ie. B C D E...

Hi everyone, I am trying to multiply time by hours. For example 4:00 am x 5 (hours). The result should be 9:00 am, but i can't find a way to get that. Any thoughts? Thanks, Mark

I have the following code working as part of a macro without any issue... of course, when I get to my client, I get a debug error... The topRow and botRow variables are storing numbers and in debug mode, when I hover over them, the correct numbers are showing. Any thoughts on a better way to...

Hi. I need help. Example Data in column A - C. Desired Results E-F. I am looking to return the 5 largest sums based on a column and return the corresponding value. Thoughts? <tbody> A B C D E F 1 FL 200 MN 700 2 TX 200 CO 500 3 FL 100 FL 400 4 FL 100 TX 400 5 MN 400 CA 200 6...

I have a huge document with tons of these. And I always decide randomly which I will use on a given day. But I bet one of them takes up less space... thoughts? MC

I am trying to build an Index formula. I have the first part of the range, can I use address to get the rest of the range? so I have A1 to start so I am thinking index(A1: and then the address function to fill in the second part of the range...

Hi everyone, I have been working with this basic macro the last few days, and you guys have been amazing. I just have one last question on this. It will print the first two sheets, but I can't get it to print them Duplex. I tried adjusting the page settings and printer setting, but this...

hello in column A i have a name that appears as Lawrence_Harris in Column B i would like it to appear as Harris, Lawrence any thoughts on how i could do this ty

Cell G10 = 4/10/2018 Cell L10 = 4/9/2018 (It is ok to have negative days in our business) M10 = =NETWORKDAYS(G10,L10)-1 The answer is get is -3. Most of my rows are correct, but i see a few of this type issue. Thoughts?