multiple

Please help! I am struggling so bad! I am trying to run 4 potential values. C11 can contain "Mini" or "Regular" Mini = 5.50 Regular = 6.50 BUT If H11 contains "Lays","BBQ","Doritos", then add .50 to total. So if they select one of those options, the total then becomes 6.00 for a Mini &...

Good Afternoon, I know this isn't an Excel question, but I was hoping someone on this board could help. I need to create mutiple routes on a map and was wondering if anyone new of a free service to do this task. Basically ill have 41 distinct across the US and the software my company uses you...

I am looking for a macro perhaps. I have 3 rows of data Columns C to G I want to paste multiple times. Perhaps thousands of times. Is there a way I can cope C1:G3 and then paste it a number of times? I would like in some cases this to be 300 times, and in other cases 1500 times.

Hi, I've got some code that is looping through multiple workbooks (with multiple worksheets) to copy data however it's pulling ALL the worksheets within these workbooks and i'd like to limit it the copying to specific ones. Is there a way to list the worksheets that i only want the code to...

Seems our engineering friends at Microsoft are at it again. They love breaking things that work perfectly. I have a workbook with about 70 identical sheets. I wanted to print the same rows on each sheet. Well in the 2013 version you can no longer set the print area on multiple sheets. Fine, I...

Sheet contains an index of descriptions and order dates: Column D = Roof materials Column E = 12-09-2019 Below is to check order date in Column E and match to todays date. Checks to see if "Reminder Sent" is in Column F, if not, creates emails and places "Reminder Sent" with date/time in...

Hello Is there any other way than power query to combine multiple columns of a table and get a report in pivottable?...

Hi Guys, I need to change a multiple line excel sheet to the a single line sheet. I have the below sheet <colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>#DAE7F5[/URL] "] A B C J </thead><tbody> 1 Exported On: 16/08/2019 15:40:57 2 #00DC00[/URL]...

Hi Guys I have an excel sheet where a User Name is appearing on multiple lines (See below) And we want it to appear as below

Hello, I’m trying to determine if there is a formula I can use that will be able to dothis. The columns in my spreadsheet represent individual dates(e.g. column B is 01/09, C is 02/09, etc). for each date there are quantities andin column A there is a product code. Each product code can...

Hi I'm running Windows 10 and Excel 2002 (don't ask why). I like to be able to open multiple instances. At the moment, if I check the "Tools/Options/General/Ignore other applications" box I get separate instances when clicking on successive file icons (which is what I want), but the workbooks...

<tbody> <colgroup><col width="536" style="width: 402pt; mso-width-source: userset; mso-width-alt: 19602;"> <col width="145" style="width: 109pt; mso-width-source: userset; mso-width-alt: 5302;"> <tbody> Site list Site list...

I have a userform with several text boxes. Two are tied to select case statements. What I'm after is if the defect is "sheet metal (bent)" and the reason is "bent to long" I need it to put 01001 into a cell. That part is simple enough. The problem I have is that with each defect there are...

Hello all, I'm trying to find a value in an array using multiple criteria. Basically, what I would be looking to achieve in the below example would be to search for A2 in E1:E4, where B2 is also greater than G2:G4, and less than H2:H4 and return the answer from F2:F4 This should output Zone...

Is there another option if you can't use the =ifs command other than using multiple & if over and over? Thank you!

I have an .xltm file on a shared network drive. I set it up as a template to enable multiple users to use the same document at the same time, opening each instance as a template page... but... when they open it, the macro goes to save the file as a generated name... a pop up occurs stating that...

Hi All, Can anyone suggest if PDF to excel conversion is possible through VBA. I search many websites about that but got no solution. Please note my PDF can be multiple pages.

Hi fellows I have a question regarding searching in excel in multiple sheets I have 3 Sheets "Production" "Test" "Qualification" All have the same number of columns (ID, res, text, comment) What I want to do is: See if the ID (column A) from the "Production" sheets exists in either "Test"...

Column B is updated with RTD Output required in Column C as: If 3rd decimal place >=5, then INCREASE the 2nd decimal place by 1 value & COMPLETE VALUE to nearest .05 multiple ELSE DECREASE the 2nd decimal place by 1 value & COMPLETE VALUE to nearest .05 multiple Thanx in adv I am using...

I have a table that tracks positions across multiple companies and years. I want to count the number of unique positions. The difficulty is that the same position title can be with infinite companies (ie. "Associate" is a position at Company A and Company B, etc) There are also multiple...