vba &

I have some data points that are unique in each sheet and the same unique data points need to pasted as a value in the same worksheet but at different range I have write down following VBA code for copy paste in same sheet <code style="margin: 0px; padding: 0px; border: 0px; font-style...

I have following vba code which throws error of object required error 424 please help me on this With Worksheets("OPTIONS").Activate.QueryTables.Add(Connection:= _ mystr, Destination:=ThisWorkbook.Worksheets("OPTIONS").Range("$A$1")) any help will be appriciated by word of thanks

For example, if in the range of A:A cell A8 change then copy D4:I4 and paste it as value in another sheet named as "ADP" at the same place i.e. D4:I4 For that I have tried the following macro which requires some modifications, please suggest the same. any help greatly appriciated. thank you...

Hi all, Firstly thank you for taking the time to read my post.. My Question: I have an image that I want to put into into excel document and when a user completes a certain cell value corresponding to the part of the image it fills in the specific part of the image with that cell value. For...

Hi all, I was wondering if i could get your advice. Is there a way to automatically increase a numerical value in "column A" by 5% without having to add another column to do the calculation within VBA. I haven't come across any Google topics that can answer this question.

Hello, Looking for the code to check a userform textbox to see if anything in it contains anything other than numbers. Basically textbox1 takes the input and finds the numbers, however if someone accidently inserts letter or special character instead of a number it messes my other code up. I...

Hello, I am trying to insert HTML code for the first time in my VBA to help format the body with bold, font, number point, etc. I found a nifty site (https://www.quackit.com/html/online-html-editor/) that allows me to build what I want the email body to look like and then it gives me the HTML...

Hello, Stumped on this one. I have a userform with a textbox to input item number(s) and two option buttons "upload" and "retrieve". when the code is run I would like it to doe the following: If optionbutton1.value = true then I'd like it to take the item number(s) to be put into a textfile...

BELOW LINK (1) IS GIVEN FOR DETAILED EXPLANATION OF MY QUERY IN EXCEL SHEET (1) https://drive.google.com/open?id=1ZwLNu1g_kNJ9qJzzwZDunStWc0cKKlVN BELOW LINK (2) IS GIVEN FOR VBA CODING TO BE DONE IN WHICH EXCEL SHEET (2) https://drive.google.com/open?id=1k4ZKvnHwR_1yp2BHuB0yWMF4ewgLljZJ...

Hi Experts, I need your guidance please. I was wodnering if anyone knows how i can enhance the below code to generate folders based on the output file name and move the output file into the folder that is created. - The code generates multiple excel files in the below format "Store...

Good morning my peers, I was wondering if anyone could help with the below code. My row header is from row is from "A1:L1" however i need to have A:1 toL1 & subsequent rows to "A5 to L5" copied into the new tabs. can anyone help amend this beast? Sub MoveOnCondition() Dim DataSh As...

I was wondering if i can get your expertise! Is there a code that anyone knows of that will do the following: 1. Split a workbook tabs into new separate workbooks. 2. Save each new workbook created as the original file name including with the tab name that has been moved into the new workbook...

I was wondering if i could get your advice. I have the below code which works for copying and creating additional tabs by splitting values from a column into 2 tabs by applying a autofilter. However when it creates the 3rd tab it shows an error message that there is not enough memory to...

Hi I have been working with a excel file with lot of datas which is arranged in 2 sheets, So I would like to get datas from sheet 1 to sheet 2 with reference to the column headings. For example: <tbody> function1personA Function2personA Function1personB Function2PesonB crit1 crit1...

Hi all Been searching through high and low but haven't found what I was looking for. Perhaps someone here can help. Quite often I find my self in need of a macro that can hide/show details to a certain level for my Pivot Table in compact mode. It needs to be robust as it should work in various...

I have a workbook which requires the user to typein a county name. There is then a vlookup that returns the urban/rural designation based on that county name. I was wondering if there was a way, when the county name was entered incorrectly and results in an error, for a form to pop-up with...