How to record data that created based on a drop-down list in Excel using VBA
I have an excel spreadsheet that give me a result column (say 100 rows) based on the selection from a common drop down list (say 30 nos). I want to record the result column for all the values in the drop down list in a separate table (like 30columns x 100 rows).
Can anyone please help me with this?
Thank you in advance
See also questions close to this topic
How to consolidate repeated data from a listBox and show the number of times it was repeated
I have three columns in an excel file. ASSET, DATE, DESCRIPTION. The asset can be repeated lots of times. I would like to hide duplicates and see in another column the number of times the asset was repeated and see these data in a listBox. Every time the same asset number is added in the listBox I want to see incremented the number of times. I have used COUNTIF(range,cell) but I don't know how to hide every time an asset is added.
TRIM & Remove Duplicate and TEXTJOIN a variable range using VBA
I would like a range most varying say A1:A20 pulled from an application with space in beginning or in end so it need to be TRIM and then Remove Duplicates, remove blank Cells and they need to be TEXTJOIN(",",TRUE,A1:A20) Range is variable. So that I can copy paste this to QMF for running query. Appreciate your help in creating this VBA so that I can create a button in the ribbon and can use in any excelsheet.
macro to transpose a table into column
i have numbers are arrange in table like in first row 1 to 10 then in next row 11 to 20 then 21 to 30 and so on i want that each row should transpose into single column like in any column 1 to 10 then below 10, 11 to 20, then 21 to 30 and so on
VBA loop to next url after 15-20 url it start overriding data in same cell. Why it start putting data on wrong cell after some url?
I am trying to get data from url & loop to next and put in next empty column. all working fine but after some URLs start overriding data in seme cell.
Why VBA start overriding after 15-20 urls.
Accessing an image that's inside of an Excel Table via VBA
I am designing a VBA Form in Excel. The Workbook has a table called "images", and inside there I am dropping some images from my local hard drive.
These Workbook & UserForm are to be shared with my colleagues. They might not have these images in their harddrive, but they will have them inside of the Excel table.
I am looking for a way to load an image that's inside of a table inside of an "Image" VBA form control.
In Google all I find is how to load an image from my hard drive (i.e. using an absolute path like "C:/my_images/car.png"). What I can't find is how to load an image that's within a table, i.e. already bundled within the Workbook.
Excel VBA - Replace chart marker with picture
I would like to replace the markers of a line chart with a picture in VBA.
This is equivalent to:
I copied/pasted this picture in a sheet of the workbook and called it
With .ChartObjects("graph").Chart .SeriesCollection(1).MarkerStyle = xlMarkerStylePicture ... End With
What should I use to replace
...and point to my image?