hoping

I hope this is possible, but I want to be able to repeat column headers n times depending on the table below. I would just put the formula on the far right on the same row, but hoping it would come out like the bottom picture. Thank you if you know how to do this! Example of output:

Good Morning, I have a combibox in a userform that I'd like to tweak. I used to pull data from just one column to display in the box, but now I was hoping to have two columns of data (separated by a space) displaying. I've written a basic piece of code below but it didn't work. Hoping someone...

Hello, I imported a CSV file into a query format and my date column is showing as this right now: 2019-08-28 03:32:31 EDT is there a way I can change that to read 8/28/2019? when I change format to date it does nothing. I can do a formula to pull the left numbers, middle and right but I'm...

Can I add a line at the beginning of my Macro to set the row limit to 5000 (or whatever)? The Macro currently adjusts for "infinite" rows and I'm hoping this will speed it up. Thanks!

Hi all, I couldn't see a fix for this after doing a few forum searches, so I'm hoping you fine people can help. In column T of this spreadsheet I have put a formula in [ =(COUNTA($E6,$H6,$K6,$N6,$Q6)-COUNTIF(E6:S6,0))/COUNTA($E6,$H6,$K6,$N6,$Q6) ] which counts the amount of times text is...

This formula works for me except that if 'oas recovery tax'!D5 is greater than a certain threshold, in this case 125650, then it is returning a negative amount. I am hoping that there is a modification to the formula that will ensure that it never returns a value less than 0 (zero)...

I was wandering if it was possible to have a cell that when you entered 240 and hit enter it would show 240 (20')? I was hoping this would be possible with the custom option in the format cells dialog. Thanks for the Help.

If I wanted/hoped to have a screenshot of the exact error (specifically the highlighted line) of code and to save it in a file on my desktop. I am not exactly sure how to do this and was hoping I could get some help. Thanks!

Hi I have list of accounts and I need each account to be pasted 12 times. So I need to transform Column A into Column B. I have 1600 accounts so I was really hoping not to do this manually :))

Hi guys, I don't work in VBA too often and have been searching for hours for, what I thought would be, a simple Find and Replace code. All I'm trying to do is search for a cell's value (located in "B8") down a column ("B14":B"). If a match is located, I was hoping to replace that matched row...

I wrote a function that scrapes data from a web site and adds one row just above the TOTALS row. That row has a sum function that for this example is: =SUM(B121:B137) But once I add one row it should be: =SUM(B121:B138) I have a LONG process in mind to address this but I am hoping there is a...

I'm hoping someone can help me with splitting a column of data into six separate columns. I've tried using various functions with no luck, as the numbers can be different lengths, although each are separated by a forward slash. The "Text to Columns" feature isn't really an option as I'm hoping a...

https://drive.google.com/open?id=1TfqRi0g6FwDCY0iNOfVWOyLhAXgBPygR I'm trying to write a VBA sub to look up the value of two references on different sheets. The problem I've got is the value being looked up has entries in more than one row which I believe is difficult for this command. I was...

Having no luck getting my head around the order or events and hoping it's easier than I'm making it out. Two columns- column A is a list of names; column B is either a numerical entry or "tbd" for 'to be decided. Want to put out a list of names where the first two characters can be the "tb" in...

Good Afternoon All I was hoping you could help with the below example, which I'm sure is fairly simple but I'm not sure where to start <tbody> 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 Recommended Year 6640 0 0 0 0 0 0 0 0 0 2019 </tbody> I was hoping to use a formula in the...

Hello Everyone, First time poster and hoping you clever people can help me with a formula that seems beyond me. My formula is as follows: =IF(A2<"","In Progress",IF(A2="","Dormant",IF(F2="","Complete"))) So if A2 is empty it is "Dormant", if it contains anything it is "In Progress", but it...

So I am sure everyone or most people now how auto filters work. I was looking into, I guess dynamic searching. So as you type in what you are looking for it preforms an autofilter. I was hoping someone would be able to explain how to do this, as well as, is it possible to have two of these on...

Hello, I hope everyone is well. Long time, no post :) I receive non-normalized data from our field staff who are in teams of 2. For our final analysis, we choose only the team lead (indicated in its own field/column as TL). However, on rare occasion, they leave their response blank and we need...

Are there any HCL Leap experts out there? Doing a survey and have a question about creating a table for a question. Able to put it together, but when we save and go into the survey, the formatting is all gone. Hoping to maybe talk to someone that can walk me through it. Thanks! Bob

Hi I am trying to cut down the amount of inputting on a time\expenses workbook . The cell (d34) is a date and I was hoping to trigger the cell to autofill based on another cell if it was >0, (cell ref Timesheet!D33) , it would look to Timesheet!B23 (which is a date) and as d34 is in the...