PDA

View Full Version : Excel Help



Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 [144] 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165

  1. Retrieve value based on selection
  2. Select Case Function on a CommandButton/ToggleButton
  3. Merging columns
  4. Moved: VBA: Picture in Word-Header? Position?
  5. VBA Paste As Values
  6. Toggle to Hide Rows
  7. Matching multiple values from different column
  8. [SOLVED] Filling in blank cells with data from another workbook - VBA
  9. VBA help
  10. ListBox on Userform doesn't refresh
  11. Filtering out a specific range and pasting it a row below
  12. new logic need to add to the code
  13. [SOLVED] Code To Save Worksheets As Individual .txt But Only The First 9 Columns Of Each sheet
  14. VBA Books/Courses For A Novice
  15. Help Needed: Picking Shortage Corresponding Date
  16. Copy Used Row
  17. Macro to create new sheets when master is updated
  18. Some last problems with barcode prog. ' SetFocus, Barcode Length ,Autosave'
  19. [SOLVED] Time Rounding VBA (Custom Function?)
  20. Nested Loop to create multiple series in a single chart. Where did I go wrong??
  21. Pls correct my code (sending mails)
  22. [SOLVED] Filtering unique data & Remove duplicate rows & save unique record range in new book
  23. How to check if a cell contains something or not
  24. [SOLVED] Template SaveAs on First Open
  25. Corrupt data in workbook?
  26. Path/File Access Error - Replacing text in xml with text from excel
  27. VBA code to subtract the time diferences in the userform.
  28. Data Merge - Identify Rows Not Pulled Over from Sheet2 into Sheet1 - VBA
  29. Problem with Folder Picker
  30. [SOLVED] VBA Code to Match US Region to the State that is entered
  31. Get multiple values from sheet and assign to textboxes
  32. [SOLVED] Compare two lists of numbers
  33. [SOLVED] Delete row if it contains a certain word or phrase - and use array
  34. Extracting the URLs from a tweet
  35. [SOLVED] If Cell is Highlighted -> Copy Row and Paste in Sheet2
  36. Cumulative sum based on a condition
  37. small logic is missing (auto mail)
  38. [SOLVED] Left & Copy
  39. [SOLVED] Combine worksheets and move row and columns
  40. [SOLVED] Help Loop and Count if more than one unique
  41. Copy Worksheet to another Workbook - VBA
  42. Looping to find difference in time within string
  43. For loop delete entire row if cell is blank
  44. [SOLVED] VBA Celloffset function in For Each Cell function not work
  45. Compare 2 different excel sheets
  46. Delete duplicate rows if they do not contain a specific word
  47. Run "x" number of random draws and calculate totals against a pre-defined set.
  48. Read outlook emails copy to excel.
  49. Range not selecting correctly?
  50. WORKDAY #VALUE ERROR
  51. [SOLVED] Find unique records between 2 sheets and delete
  52. Active X component cant create object
  53. Time of creation of shape
  54. VBA code to lock the active sheet
  55. Can't get code to loop through worksheets
  56. How to check for conflicts in a schedule?
  57. VBA select/send email based off criteria
  58. run msgox at certain times of the day only if a specific workbook is still open
  59. Convert table of contents to another format
  60. [SOLVED] A text box in excel that contains a Picture taken from a file
  61. path string in cell
  62. [SOLVED] Linking Label Caption To Textbox
  63. userform menu problem
  64. [SOLVED] How to reuse variable value across Private modules
  65. ThisWorkbook.SaveAs fails at second attempt
  66. disable close "X" button
  67. Using different Range in the body of email based on row criteria - Appointments
  68. Code error 9. Create a workbook and worksheets in relation with variables
  69. [SOLVED] Fill Series of Sequential Numbers in Column A Based on Last Value in Column B - VBA
  70. [SOLVED] Combine two arguments into one.
  71. [SOLVED] Copy sheet and paste values - VBA
  72. Concatenate Multiple Cells
  73. Object required (Error 424)
  74. [SOLVED] Copy values only not the formats.
  75. VBA to search in sheet1, match data in sheet2, return search results in sheet1
  76. Simplifying and looping VBA
  77. Modify VBA code for Advanced Filtering
  78. duplicating range
  79. ComboBox change for multiple comboboxes
  80. VBA auto outlook 2016 to send e-mail based off criteria
  81. [SOLVED] Formula to calculate AVERAGE but only to last used row in a grid.
  82. [SOLVED] Average values within time range for matching header
  83. Compare if any changes then highlight
  84. paste special values for multiple pivots
  85. VBA
  86. VBA
  87. [SOLVED] Grab data between two dates using arrays
  88. VBA Loop help (Error Loop without Do)
  89. Excel custom data validation with drop down list
  90. Index / Match / and search for result between two dates and a little bit more complex
  91. [SOLVED] Got Excel< 2007? Test if "Action Will Reset Project"
  92. Select added value from dropdown menu, program output
  93. Everytime I open my excel file open this file as new excel instance
  94. AverageIfs Dynamic Formula -Criteria Not Working?
  95. Making a leave tracker with VBA
  96. [SOLVED] Create a new sheet / workbook for all Unique values (Including Pictures / Images)
  97. Two Workbooks - Search for Values in Workbook 2, Copy and Paste in Workbook 1
  98. disable cells DataValidation
  99. [SOLVED] Need Some Help with SumProduct
  100. [SOLVED] How to find which columns are being used in active chart
  101. [SOLVED] "Run-time error '1004' on code to remove the ellipsis (...) character from a column
  102. [SOLVED] Setting a found item to a Variable
  103. [SOLVED] Replace certain cells in rows with values from same rows but in different column
  104. Pasting the contents from one sheet to a row after the last active row on another
  105. Not enough memory + Excel 2016
  106. Limiting User Entry on A Userform Combobox NOT working
  107. [SOLVED] Last User Save
  108. [SOLVED] Copying entire row from Sheet1 to Sheet2 if values in multiple cells matches
  109. [SOLVED] Default to current date in textbox
  110. [SOLVED] Reposition cursor in cell that contains the error
  111. VBA question on counters
  112. [SOLVED] Error 1004
  113. VBA - Consolidating information from one sheet from multiple workbooks in the same ma
  114. [SOLVED] Dynamically call function in sheet's VBA module
  115. Copy Data without Activating a Tab
  116. How to extract specified data to the other worksheet?
  117. Excel Error when arguments with multiple parameters are passed
  118. How to amend this code in order to copy the inserted comment also?
  119. [SOLVED] Can someone tell me why this doesn't work.
  120. [SOLVED] Type Mismatch Error
  121. Help subtracting sales from order
  122. For...Each + Merging Cells Leading to Error 2042 (Type Mismatch)?
  123. Macro to copy row, base in condition, into the botton of the table
  124. XMLHTTP - communicate with server - not working on Japanese OS
  125. Initiating a new instance of a class object
  126. Save worksheet as pdf using cell value and loop through work sheets
  127. VBA code to find current user default download folder, then open a specific file
  128. staffing rotation in excel
  129. [SOLVED] help about my code (get data)
  130. [SOLVED] Search a pdf file depended on textbox value in multiple folders and subfolders
  131. create filenames from the values in a MS Excel spreadsheet
  132. [SOLVED] Compare 2 colums of different sheet and copy values for matching data
  133. Multiple Entry Dependent Drop Down Macro
  134. VBA Converter Required
  135. [SOLVED] VBA Calculation
  136. VBA Insert array formula base on criterias
  137. [SOLVED] VBA Question on InputBoxes to Fill Cells on Worksheet
  138. [SOLVED] VBA Formatting Help
  139. Codes working for 2 templates but not the 3rd
  140. [SOLVED] Formula for placing ascending and descending numbers
  141. Can't add new item to the listbox while running the userform
  142. Hyperlink
  143. VBA Error/Trapping/Identification
  144. VLOOKUP with variable workbook and worksheet names in macro
  145. [SOLVED] Create a new workbooks for each Unique value
  146. [SOLVED] merge 2 VBA enabled worksheets to 1 sheet
  147. [SOLVED] VBA Code - setting cell background color doesn't hold with different selection.
  148. Help with time if/then in VBA
  149. VBA Help: Date/Time Stamp functionality
  150. Excel VBA to count the ADDITIONAL comments added to a cell
  151. Excel vba code to automate IE.
  152. [SOLVED] Excel VBA -Comparing Two arrays
  153. Trying to only retrieve files that i do not already have
  154. Creating a dynamic piechart
  155. Vba to highlight the cell and remove duplicates
  156. [SOLVED] Listbox - calculation based on selections
  157. [SOLVED] (HELP) add multiple process to my code
  158. Passing an item and its key to another collection
  159. Error connecting to MySQL using VBA (3709 error)
  160. VBA code to store and count data filtered by other columns
  161. Identify keyboards with vba 7 (Excel)?
  162. [SOLVED] grabbing error values
  163. [SOLVED] Baffled by Runtime Error 1004 - Help Please
  164. [SOLVED] return the value from 'A' which has the largest sum of values in 'B'
  165. Formula producing mixed results, may required VBA
  166. [SOLVED] Process too long for counting received,sent mails etc. with Outlook
  167. VBA to loop through each row and subtract if conditions met
  168. [SOLVED] Importing worksheets and retaining file order
  169. VBA error with parsing JSON
  170. Automating Data Retrieval From Terminal Emulator (OutsideView) with VBA
  171. Splitting multiple worksheet
  172. Filter Data and Copy to new worksheet
  173. [SOLVED] Sorting in Excel VBA
  174. [SOLVED] Pivots auto sort and dollar sign needs to be added
  175. [SOLVED] To Uppercase
  176. [SOLVED] Excel Worksheet_SelectionChange event not firing at all? (on both Office 2013 & 2016)
  177. [SOLVED] Index & Match formula error
  178. Find values
  179. [SOLVED] Problems with GetSetting function
  180. finding last column used and insert new data weekly
  181. Fliter listbox using checkbox
  182. Open File for Output hangs
  183. [SOLVED] Setting the date as dd/mm/yyyy from a combined field
  184. dynamic way of Filter and delete
  185. [SOLVED] Retrieve data(Time, From, subject, category) from Outlook inbox to Execl
  186. [SOLVED] Is possible to show the UserForm of another Excel file?
  187. [SOLVED] Application Defined or object Defined Error 1004 after every cell update
  188. [SOLVED] Named Ranges - Same code, but one is cast as Variant and the other a Range?
  189. [SOLVED] VBA Code to filter a list, then create new list in a new column
  190. FormatConditions.add to change cell color when something is entered
  191. [SOLVED] Is MsgBox Suitable ?
  192. [SOLVED] VBA Pivot Table- Datafields Horizontal to Vertical
  193. Run Time Error 13 (Type Missmatch)
  194. Excel templates and save as workbook
  195. Transpose non organized data
  196. formula error while cut/copy of cell contents
  197. How to pick one webpage each from a collection of web page list!!!
  198. VBA UserForm Movement limit
  199. Fill Formula Down Column when Rows Inserted
  200. [SOLVED] Help with SaveAs PDF
  201. [SOLVED] Combining Data from multiple worksheets to a printable worksheet
  202. VBA - Excel Assistance on consolidating multiple workbooks into one
  203. [SOLVED] Changing a cell font color upon cell entry & exit
  204. Error during import from webpage -> *** requires a JavaScript enabled browser.
  205. Paste multiple formatted word paragraphs into single Excel cell
  206. Arrays Compare
  207. Excel comments: a registered macro that doesn't work
  208. Need help with an vba macro for excel that adding an 0 in a number combination
  209. [SOLVED] New-work-assignment / Sort data
  210. [SOLVED] UDF called by another UDF sees Caller as an Object
  211. [SOLVED] Countif or Similar Help Required and advise on Named Ranges
  212. How to fix this problem? "unable to set the visible property of the pivotitem class"
  213. Excel - Identify Shapes by Content
  214. UDF calculation very slow in excel 2016 (faster in 2010)
  215. [SOLVED] Input cell value based on multiple dropdown list to populate
  216. Rename files using criteria in Excel
  217. VBA query while inspecting element on webpage
  218. Get duration of mp4 files
  219. [SOLVED] copy rows if number doesn't exist in all worksheet
  220. [SOLVED] How to get the index of ActiveChart
  221. excel file saving issues
  222. user form(vba macro)
  223. get file paths based on name criteria from folder
  224. Problems with xl2007
  225. [SOLVED] Update column of selected items in Multi Select Listbox
  226. [SOLVED] Recon between two spreadsheets across various columns
  227. Decorate my sheet as an interface
  228. Remove Duplicate Row IF Older
  229. [SOLVED] Copy Data from one sheet to New Workbook with the New Header Name
  230. Assign value to pie chart
  231. Highlight and popup message Between employee dates are overlap using (vba)
  232. [SOLVED] Macro for Conditional Formatting
  233. How to capture the lock time and event of System by vba?
  234. Gap in between the words in excel
  235. Help--Can't extract data from Mysql using cell content as select condition
  236. Union range vs Arrays (error out of range)
  237. [SOLVED] Date Format in VBA
  238. sorting among workbooks
  239. [SOLVED] callback an EditBox in the Ribbon
  240. [SOLVED] ListBox Object -- Inconsistent behavior (sometimes unresponsive?)
  241. [SOLVED] similar cells - grouping
  242. Producing hundreds of Multiple Regression analysis scenarios simultaneously
  243. Automation error
  244. [SOLVED] Copy a column from excel and paste in the "To" section of a new email in Outlook
  245. Export single row from given sheet & append into existing MSAccess table.
  246. VBA replaces long number with # sign (Excel 2010)
  247. It's possible to add a Word document with a customized name?
  248. combine mutiple values into single cell based on criteria
  249. Should be a simple fix but not sure how to move and tweak my If statement....
  250. Relative Paths within Excel for CSV imports