I can use the Power Query tool to import data from Google Sheets easily, if the sheet is publicly available via a link. I just choose "Data from Web" and use th
I've an excel sheet "Calcs" with 1 column name "old". I'm trying to add new column "new" with a fixed value of "1" to existing sheet "Calcs" and am using below
I'm using "Node.js", "express" and "SheetJS" so that an endpoint that saves the data (from an array of objects) in an XLSX file and returns the url of the file
All the data that come from the source are integers: 345819404 1093 28495 The only "tool" I have at my hand is Excel-style formatting options to turn it into:
I am stuck with an issue/ on how to approach this problem. In the attached image (sorry I am not allowed to add the image now and hence the link) you can see in
I am trying to make a code that will save a copy of a file with a new name based on text in Cells D1 and D2 from the active sheet of a workbook. I can't seeming
I've uploaded a video on Youtube showing the problem (Youtube because I can't do it on StackOverflow directly). Any idea why I have this problem? I'm using Micr
everyone: I have a table with these dates: I have another table with a list of dates and owners: I need to merge/join these two tables so that the transaction
I have a criteria where user uploads excel. So in that I want to check if column Is Replacement (Y/N) has values as Y then I want Replacement SAP ID cannot be b
I have problem with data type conversion in power query. I have data about total working hours ("[h]:mm:ss"-in this format) {]2 when I change data type to Gene
I've put together a random name generator (using a few other helpful threads on here) and this is the code I've come up with. It keeps outputting the list in al
Sorry about my newbieness here. So... I have this table: And I want to collect some data into a different sheet: As example, I am collecting D14, with this f
I am currently novice when it comes to VBA and I have this problem that requires an expert in this field. So I have a Masterfile Named Archive with Extract butt
I am using Syncfusion library to generate an excel report. I referred syncfusion to generate the report using template makers. The data is correctly exported in
I initially asked this question How to loop through a specific row of a 2-dimensional Array? and @FaneDuru was kind enough to supply a solution but now I am hop
I was able to merge(inner join) a transaction table with an owner info table using account number as my key to get the following results: I need the transactio
I need your support to re-arrange an excel sheet, listing all values in columns to be in new raws. As is: enter image description here To be: enter image descri
I'm writing some code to automate data entry at work. My issue is that the if statements are not working despite the conditions being met. I've tested the code
I've used various guides, documentations and tutorials to create a custom formula. Basically the formula takes two parameters ItemID and DateV. =DP(ItemID,DateV
I have a spreadsheet using two sort routines: Sub Sort_Date_From_To() Range("A3:Q10000").Sort Key1:=Range("C3"), Order1:=xlAscending, Key2:=Range("F3"),