written

The code that I have written works that all the workbooks are open (there are three) two of the files are forecasted demand and then there is a master that imports the data and digests it for managers. Everyday their are going to be new forecasts that need to be loaded. I have written code to...

Good day,i hope my issue is an easy one to solve, i am totally stuck so here i go.I have a series of values in Column A Hello 1Hello 2 Hello 3Hello 4 (with hello written in black and the numbers are written in red) and in block G2 i have the formula:=CHOOSE(RANDBETWEEN(1,4),A1,A2,A3,A4) but the...

I have to segregate a consolidated P&L, in which I have PY, CY, BUD for one brand followed by another brand and there are almost 50 brands. What I have to do is I have create a master table where in I will put in the Brand name and it should reflect the information for that brand. G1, H1& I1...

Hi I've recently upgraded to Excel 2016. A webscraping programe written with 2007 stops working (not responding) with Excel 2016 It'll start to loop through a list of websites but just stops responding after 3 or 4. I've tried exporting the mod,saving as a non-macro workbook and importing the...

Hi, I am Tevfik . I have an NX Nastran Fem Analysis Solution File with format .f06. I have to import it to excel with macro but I couldn't do . The values must import in different columns . Text file added. I need Von Mises column values which is at read colour. Thanks. 1...

Hi all MrExcel I want to get data range from Multisheets to another sheet with conditions that I written In sheet MAIN when I type in Cell D2 ="56201001". I want all row in sheets"Noibang" and "ngoaibang" has contents "G00014-56201001-01201001-201704-BI-M-01" copy to sheets (DATA_1st). I now...

Hello everyone, I have a very simple problem: How do I select all written cells starting from C4 until the last available cell in that same column C?

Hello, I have 3 Columns and multiple rows. Columns E, F and G. When I enter the numeric value "2" in column E, I would like it to add 10 years to the date that is already written in column F and have it display in column G When I enter the numeric value "3" in column E, I would like it to add...

Ive started a gigantic task where Im gonna try to convert soccer team names scraped from several different sources. problem is that many team names have small variation in how they are spelled from site to site. here is a sample to show what I'm struggling with: <tbody> POleksandria...

To all I have a xls sheet which contains formulas as follows In cell C1 = If($A$1<> “”, 99,””) The idea is that a value is written if A1 contains something (i.e. a value) otherwise no value is written. I do not want 0. I want a blank cell Then in a macro I pick up the value from cell C1 as...

=if(p1=1,'fa1'!d6,if(p1=2,'fa1'!d7,if(p1=3,'fa1'!d8,if(p1=4,'fa1'!d9,if(p1=5,'fa1'!d10,if(p1=6,'fa1'!d11,if(p1=7,'fa1'!d12,if(p1=8,'fa1'!d13,if(p1=9,'fa1'!d14,if(p1=10,'fa1'!d15,if(p1=11,'fa1'!d16,if(p1=12,'fa1'!d17,if(p1=13,'fa1'!d18,if(p1=14,'fa1'!d19,if(p1=15,'fa1'!d20,if(p1=16,'fa1'!d21,if(p1...