please help

Hi, I need help to solve this issue, Like i have to many customer codes and they all have zeros before numbers like, <colgroup><col><col></colgroup><tbody> Current Shape Required 000003 3 PAK LAND CHEMIST 000005 5 KHALID MEDICAL STORE 000006 6 CHISHTI MEDICAL STORE 000025...

Hi im hoping someone can help me with this because i am really struggling.. I am having issue with ".CommandText = Array( _ "SELECT * FROM Consolidated WHERE [Start Date]> '2019-01-01 00:00:00'")" it seems to be working fine if i do the criteria on brand or anything else.. however it...

Hi All - Having an issue with copying a worksheet and saving into destination on local drive with the data inside moved with all the equations and data validation - need to copy it only as a read only [No equations, No list] - values only - On Error Resume Next strDirname1 = "XYX"...

The columns relevant here are BA,BB&BC although I may put this data on a separate sheet just in A, B & C The number of cells occupied and contents in BC changes. Which is why I can't press record and be happy. On Columns BA,BB&BC data filter is applied. I click the header drop down in BC and...

Hi all - I have the below code to copy a set of row data from one tab and paste/transpose when a Command Button is clicked on a second tab. How do I edit this so that every time the Command Button is clicked, the data is pasted to the right on the first blank row? Currently, when it's clicked...

Hi all - I've got the below code to copy column data when a Command Button is pressed and paste/transpose on a different tab. Each time the button is pressed, the data is pasted on the next subsequent row. Is there a way to paste/transpose the data but keep the original cell formatting where...

hello i have tried macro for,the following thing. "list of codes" is a one excel book contains 16subject codes. "data file" is another excel file..it has 25 columns of data students data.like name ,id number,colege name,doj ,dob,area ,subject code,,etc.,; "imp details" is a new book Here ...

I just created a thread but seems its gone.. so re-writing. What I am trying to do is make a range which will be mirrored in two different sheets. That is, they accept input which will be reflected in either of the range I specify. For example, if I put 123123 on Range1, it will be shown the...

Hi guys.. my very first post to this site What I am trying to do here is making a two way input range in two different sheets That is, if I put anything in "A:A" Column(or specific range) in sheet1, it will appear on sheet2 "C:C" column(or specific range). Also, if I revise it on Sheet2 range...

Excel version 2013 on windows. I have a spread sheet that I need to hide entire rows based on another cells contents. I need two rules, based on different conditions. Rule 1 When cell C14 contains "Select" I need Rows 20:34 to be hidden. When Cell C14 contains Anything other than "select"...

<tbody> A B C D E F G H I 1 Contract# Contract amount Already encumbered Invoices Paid Already Encumbered Balance Current Contract Amount Encumbered Unencumbered Balance 2 1234 100 50 40 40 10 </tbody> I made a small copy of my spreadsheet. I will try to explain what I want to do to...

Hi, I am not too familiar with macros. Is it possible to create a macro that will send a worksheet as an attachment to an Outlook email? I would like to create a "Submit" button at the bottom of my worksheet that will send the email if possible. Also, is it possible to have a dialogue box open...

Hello, Goal = To have a combo box add an item for each cell in a range. I have a userform where a user can select a material, and based upon the material selected another combo box is loaded with color choices that they can select from. But I want this to happen automatically when I add or...

How do create Students Rank List in excel,Based on "Pass" candidate only To assume Rank,If "fail"candidates not assume that marks. I tried this formula =RANK(c6,$c$6:$c$41) It's assumed all marks to getting Rank for pass & fail students. This is wrong, i want only Rank for pass students only not...

<colgroup><col style="text-align: center;"><col style="text-align: center;"><col style="text-align: center;"><col span="2" style="text-align: center;"><col style="text-align: center;"></colgroup><tbody> Posting Date Order No Customer No Combo Code Item Desire Out Put 4/19/2016...

Take 102201631000-102201633999-234245 from text file and take right formula from first two numbers =right(text1,6) & right(text2,6). i.e. 631000 & 633999 then i need to place them in text like. 102201631000 234245 102201631001 234245 102201631002 234245 102201631003 234245 till 102201633999...

Hi, Thanks in advance for your help. I have: <colgroup><col style="width:48pt" span="5" width="64"> </colgroup><tbody> Alan Maria Lisa Tony Fred GB65 GB65 GB65 GB65 GB65 GB65 GB65 GB61 GBA4 GB61 GB65 GBA4...

Hello, For the life of me I cannot find the syntax error in my If Or stmt. I'm hoping fresh eyes an spot it. I tried to clearly mark the problem line with comments, its the line looking for the Notes field. I'd love any help, Thanks! <code> Sub fInput_Complete() 'Validate Entries 'copy listbox...

Hello, The last few days I have been trying to figure this out with no luck whatsoever. I am using Excel 2010 32-bit with power query on a Windows 7 64-bit computer. I was going the use the html creator, but the dl link was down and I had to use screenshots. I have a sheet titled "LeadSheet"...

I'm trying to get a formula that will enter a particular value when 2 specific criteria are met. I've been trying to use an =IF(AND( statement, but so far I keep getting a "the formula you typed contains an error" message. I need to have cell V9 return a value of 8 if the following conditions...