question

Hi everyone. I'm currently building a new order form for work and I've been asked to have one of the tabs auto-concatenate certain information from three other tabs - to prevent the customer from overtyping and getting it wrong. So I have four tabs:- Product A, Product B, Product C and Control...

For work, I'm creating a schedule that has automatically updating dates. In the first relevant date hex I've inputted '=DATE(year;month;day), which by itself works fine. Now, this afternoon I saved the excel file with the other cells referring to one another (and to the original) with the...

Hey all, After looking up guides, I tried to incorporate a line of code to mimic custom sort for my end product of this macro. Basically this macro takes existing tabs of active worksheet, copies them then perform some operations on them within the new worksheet. For some reason my sorting code...

Hello all, I have made the following VBA codes to save specific sheets of a workbook to a new workbook. However when I hide the sheets it no longer works. I want to keep those sheets hidden in the current workbook but not in the new workbook. Here is the code: Sub Export() Dim DCname As...

Hello all, I have figured most of it out myself and after looking around on the internet I still can't figure out a solution to make it value only when saving to a new workbook. I have tested the current code and it works but the new workbooks still have my original formulas in them which is...

Hello :) How can I get a cell to say, "Over Budget" in the BAD STYLE (red background, dark red text) if SUM of two cells is over value of another... and also to say, "Ok" in GOOD style (green background, dark green text) if SUM of two cells is equal to or under value of another??? Picture...

Hi im very new to VBA, my boss has asked me to do something I have very little experience in in a short amount of time :( I have a large data set exported from a simulation software which looks like this: 5 5 0 -3.34384 45000.55 0.109103 -3.23011 45000.2 0.109103 0.017424 33.0513077...

So I am trying to use this macro. Basically I want to sort column W ascending, then use the formula "=W2*-1" in column X, delete all values in column X that equal zero and W is blank, then copy and paste the values from column X to column I. When I do this it seems to work but it is changing...

Hello, I'm new to PowerQuery and loving it so far. I have some ETF prices I pulled from Yahoo Finance and pulled into PowerQuery. I have manipulated it into the following (Table 1): I want the data to look like the following (Table 2). Essentially, I want the "Ticker" column to instead by...

Hello, First of all, I am still new to VBA and more complex excel coding, so I'm learning by doing, searching forums and tutorials, stitching together bits and pieces of code I need. However, I ran into a dead end and would need help. Basically, what I'm trying to do: I have a project to sort...

I have a report which I have to update from time to time. The combination (Concat) of the values from two columns is unique, so I have a "code" which identifies the row. So, for the example: Sheet 1 has 1000 rows, Sheet 2 has 1200 (The previous 1000 are included in this) I want to copy over to...

Hi all, I would like some help with an excel spreadsheet I am creating to keep track of my overtime at work. As seen in the attached file, Column D is the overtime that I worked on that day. Column E is a dropdown box (Yes,No) which identifies if I have used those overtime hours (Eg. On X...

Hello, my 2nd post here and I'm pulling hair on another stuck Excel sheet. I've got an Excel sheet prepared however just couldn't upload it here. Actually just one question however with several conditions so I'm putting them into bullet points numbered below: 1. For each document, how do I...

Hi, I'm trying to build a macro with the following data... What I want to do is to transform the above into this: Basically, what I'm trying to accomplish is to take the data set and transform it into individual line items. Account numbers, names, and risk types repeat, but LOB and Net...

@ How to show selected menu in slicer to other cell ??? (Like a Reference Indication) in pivot table ???? I have Try selection in slicer information reference to other cell , Above image like this yellow Highlight cell this reference

I am trying to separate a string from it's three initial characters. Example: 100345-123-2455 100 345-123-2455 345-123-544444 345 123-544444 I have figured out, with help, how to separate the three characters, using the function...

I am trying to compare the first three characters in A1 with a range from C1 to C100. If there is a match, the first three characters would copy to B1.

Guys I really need some help. I have tons of tables in a powerpoint document. Some are 2 in x 2 in and some are 3.5 x 3.5 in. I need to resize only the 3.5x3.5 tables to a size of 2.8x2.8 I know this can be done with some easy vba code, but I don't possess the knowledge for it. I know it has to...

Hello, To give a bit of background: I'm one of the editors on a website currently hiring writers. We're creating a spreadsheet to track the content the writers create and when they created it. I want to create a count for the number of blog posts they've written in the last 7 days, if that's...

Im having a lot of trouble working with this formula, what im trying to get is, if the week number is even, then get the difference compared with two weeks ago (current- twoweek), else (current 53-previous 52), the thing is with other measures works perfect, but with this particular measure is...