I can demote hits header row, but the problem then is that empty cells in that row now are filled with "column 6" etc!? How can I fix this? Force Powerquery to import without headers? I am trying to load and combine multiple excel files with the same table data :confused ..read more

sorry this is not a new question but i think i not perform my question exactly. i start a new excel with ( at least two workbooks ) one with all my data ( tabelas ) and another one ( orcamento ) where i want to made a lot of calculations, in orcamento a have a cell ( X28, i think this is correct ) that calculate max ( Ax24,BF24 ) and pretend a value, with this value i watch in workbook "tabelas " and in the list - disjuntores, calibre - and look for the value >= and nearest value in this list and fill the cell ( usando o quadro calibres disjuntores,In ). At this time i use a dropdown to cho ..read more

I am printing excel documents and get an error message in notepad, yes, notepad. My work around has been saving as PDF instead of printing as PDF, but curious if this is a situation that can be fixed %%[ ProductName: Distiller ]%% AptosNarrow-2bc0000-560000 not found, using Courier. %%[ Warning: unable to embed font /Courier.Out of memory. ]%% %%[ Warning: Courier cannot be embedded because of font file error. ]%% %%[ Error: invalidfont; OffendingCommand: xshow ]%% Stack: -dict- -file- %%[ Flushing: rest of job (to end-of-file) will be ignored ]%% %%[ Warning: PostScript error. No PDF file ..read more

I have a comp plan that pays out: 1x from 0-100% 1.25X from 101%-200% 2X from 201%-250% 1x from 251%+ I've got the 0-100% correct and the 251%+ correct, but struggling with the formula for the 101-200% and 201-250%, can't figure out how to tell excel that if the commish is 225%, that the 101-200% still works. Love some help! Marc Attached Files Marc Daily Tracker.xlsx‎ (8.8 KB) Download ..read more

Hello, I'm having issues in that I'm receiving a #Div/0! error in my spreadsheet. The goal is to figure out what the final sick and vacation pay would be in cell B15. All green boxes are what the user would fill in and the rest are formulas. Some employees at the company have 2 positions which have 2 different rates of pay. And with that, cell E11 and E12 is the percentage of their job at that particular rate of pay. If there is someone that has one position I would take out the salary in cell B12 and the FTE in cell E12. When I do that, that is when I would receive the #DIV/0! error. Any idea ..read more

I am looking for a macro that would do the following: On specific date or say the 25th of each month if the spreadsheet is opened up the macro would copy A1-A14:L1-L14 then paste it in a specific workbook name PR. Each month it would make sure to just copy and paste under the previous months data. Then the macro would take H2:H14 and copy the current values to G2:G14 then save the file. Basically I am trying to move data to another workbook for tracking and history and then use the main workbook for a month tracker with updated data. Is this something I can get help writing or can you poi ..read more

How do you add a new line in a MsgBox message ? Trying to put these 3 lines into one MsgBox message: Code:   MsgBox "Shape 1 Name: " & shp1.Name, , ""   MsgBox "Shape 2 Name: " & shp2.Name, , ""   MsgBox "Shape 3 Name: " & shp3.Name, , "" This works: Code:   MsgBox "This information is on the first line. " & vbNewLine & _         "This information is on the 2nd line. " & vbNewLine & _         "This infornation is on the 3rd line. " This doesn't: Code:   MsgBox "Shape 1 Name: " & shp1.Name ..read more

So basically the code below is to help me automate a repetitive task. However for some reason the only part not working as it should is the function where it changes K column from TRUE/FALSE to 1/0 accordingly...any ideas.. Thanks:cool: Code: Sub AutomateReporting()     Dim ws As Worksheet     Dim LastRowA As Long, LastRowK As Long, LastRowF As Long     Dim rng As Range, cell As Range     Dim destSheet As Worksheet     Dim sheetOrder() As String     Dim i As Long, j As Long         ' Define the worksheet to work ..read more

Hi All, Code: let     Source = Csv.Document(File.Contents("\\company.com\dfs\data\WM\CR\Shared\CPM\20240419TESTFILE.csv"),[Delimiter=",", Columns=24, Encoding=1252, QuoteStyle=QuoteStyle.None]),     #"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),         #"Changed Type" I Have created a connection to a CSV file using the above code. The issue I have is that a new source file is created daily and is named YYYYMMDDTESTFILE. Can someone please tell me how I amend the code so that when I run the query, the source file name u ..read more

Hi, Looking for formula to check to see if the string in a cell has all charaters the same. eg : AAAAA, BBBB, 11, PPPPPPPPPPP, WW, AAA, XX, XXXXX, XXXXXX Thank you in advance ..read more