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. create Calendar from table
  2. [SOLVED] calculating time difference
  3. Connect to two barcode scanners
  4. Naming a sheet to the current year
  5. Copying excel ranges to powerpoint
  6. Autofill column B based on dynamic range in column A in multiple sheets except some
  7. Duplicates in named range
  8. Possible to apply conditional formatting across multiple ranges?
  9. Code that adds new appointments to Outlook
  10. Adding a Filter to a Pivot Table Inquiry
  11. copy data from multiple workbook ranges into one workbook sheet ranges
  12. [SOLVED] VBA to compare multiple worksheets and produce report of cells where data varies
  13. Workbooks.Open - Convert .CSV
  14. Sendkeys and windows 10
  15. [SOLVED] Summing individual rows, for overall group total
  16. organize data in groups with near equal Totals
  17. [SOLVED] Combine multiple DIMs into one line instead of separate?
  18. [SOLVED] [Microsoft][ODBC Driver Manager] Data source name too long
  19. Print Documents Using File Path
  20. Filtering dates
  21. Insert Excel Ranges in PowerPoint
  22. User Form Assistance
  23. Macro to send e-mail for different recipients with different messages
  24. [SOLVED] Array Step by 50 - Loop Incremental
  25. [SOLVED] Delete Rows Not Containing Array Term
  26. Help With Coding Structure
  27. Need to copy Some part of outlook mail body into excel through vba
  28. [SOLVED] Replace Exact String - Array
  29. List Box - Scroll Bar movement creating a ghost image of the ActiveX List Box
  30. [SOLVED] Userform Assist - commandbutton to add multiple textbox
  31. OLAP Pivot Table - Variable number of filters
  32. [SOLVED] WorkSheets in an Array - Copy From
  33. Send Mail VBA LOTUS NOTES
  34. Textbox search conditionally
  35. CLEARCONTENTS OF CELLS WHEN OTHER CELL VALUE IS DELETED
  36. [SOLVED] Going through a range (Looping?)
  37. UserForm webBrowser ctl: how to detect 'no web page found' for a defective url?
  38. Merge 2 Excel Worksheets together
  39. Integrating Calendar with WorkSheet and UserForm
  40. Close Open Text File - No Save Prompts
  41. time to decimal format
  42. [SOLVED] Text to columns for every character in text file
  43. [SOLVED] Transpose Selected Cells Containing Specific Value
  44. [SOLVED] Macro to Print Worksheets Containing Specific Data
  45. Code to copy the active WS before a specific WS in the WB
  46. countifs column with date
  47. VGA code to list files attributes and also arranged them with filter using buttons
  48. Want to fill data from Excel in to specific Form for Print Lable.
  49. [SOLVED] Trying to Create a Remove Last Button
  50. [SOLVED] Can you keep a connection to a DB open?
  51. Hit button and download file using excel vba on web page
  52. [SOLVED] Highlight Offset Consecutive Column Cells
  53. [SOLVED] Userform focus causes document in opposite window to minimize - Dual Monitors
  54. [SOLVED] Subscript Size
  55. PDF2XL
  56. INDIRECT with Data Validation for a 3D formula
  57. For Each inside another loop works only once after excel startup
  58. Excel-Visual Basic UserForm Coding
  59. Check for headers in Excel
  60. work hours with lunch break
  61. reformuler un tableau ce forme dans rapport Excel
  62. exportasfixed format specific range not working
  63. Delete table rows where a cell in D contains certain numbers
  64. Refresh DB Connection Programatically
  65. Changing Vlookup to variable depending on search results? idk
  66. [SOLVED] Variable Not Defined Error
  67. [SOLVED] Transpose date from column name
  68. Create outlook reminder from excel
  69. Help with macro filter sequencing
  70. Excel sending email format
  71. [SOLVED] DATE and TIME FORMATTING in Office 2007
  72. Web scraping
  73. I need the cursor to go to the last non-zero in column C
  74. Treeview not loaded in userform
  75. [SOLVED] Worksheet.Evaluate to Formulae
  76. Vba Need Dice Continue Rolling?
  77. [SOLVED] Generating new ID VBA code
  78. [SOLVED] ListBox - Population - Load For Each Worksheet
  79. [SOLVED] update a table between two Excels files with a condition
  80. Upload File with winscp and sftp
  81. Select Listbox Item by ComboBox Item
  82. [SOLVED] Add a link button dynamically in 1 cell of each row
  83. How to use buttons on userform
  84. search a column of keywords in a folder of .docs and match file names and string
  85. Chart - Excel 2013 - Series Highlight on Label mouse over
  86. [SOLVED] Simple Macro Help
  87. Changing an Excel Userform does not work
  88. Updating database using userform dependent combobox selection
  89. How to save as with fixed name and server location ?
  90. Open PDF in WebBrowswer Control on Userform
  91. Filter by named range in closed file
  92. [SOLVED] For loop inside IF statement
  93. Link spreadsheets
  94. [SOLVED] Making VBA userform, ChangeButton does not work
  95. [SOLVED] Calling Textboxes created in runtime with a form how to reference in a loop
  96. Vba Macro in Excel for exporting multiples files in Word with prompt
  97. Advanced Filter Help
  98. Explain Formula
  99. [SOLVED] LEFT Function to retain first 10 characters of cells with VBA
  100. VBA to use a variable filename
  101. [SOLVED] CDR CVS help needed
  102. If Value is >= 1 Take header and insert into row
  103. VBA Powerpoint formating
  104. [SOLVED] Struggling to apportion value 'dynamically' - Worksheet attached
  105. [SOLVED] Transpose Excel data from rows to columns
  106. [SOLVED] VBE Editor Select Module
  107. [SOLVED] VBA Macro Stops at line 986
  108. To search a column in a database and to return all the entries found
  109. Disable Sort In Shared Workbook
  110. [SOLVED] Offset in an Array - Replacement
  111. Conditional VBA for Combinations
  112. [SOLVED] Runtime error 1004
  113. [SOLVED] Tab delimited text file issue
  114. Montly, Weekly, Daily Attendance
  115. New line in formula & Join Text
  116. Automatic numbering up, with two matches
  117. Newton's Method Iteration Code in VBA- No errors but will not output
  118. TOC macro to skip displaying hidden sheets
  119. Email and HTML
  120. [SOLVED] Editing the contents of a Match Index Cell through VBA
  121. INSERT OVERWRITE INTO correct syntax?
  122. Available Procedures in COM add-in
  123. excel formula and vba automation help
  124. Speedup VBA
  125. [SOLVED] NEED HELP RESCTRUCTURING MACRO TO FIT MY WORK SHEET, PLEASE.
  126. Problems with simple counter
  127. [SOLVED] VBA Copy and Paste data form one workbook to another.. Problem is data change every w
  128. Stuck on VLOOKUP VBA using variables
  129. callback for Application.Run
  130. Issue with sending the active workbook & printscreen via Lotus Notes
  131. [SOLVED] Cell with multiple lines of data , delete lines without # into one line
  132. [SOLVED] Issues with Arrays and DLLs
  133. Embedded objects in Excel
  134. [SOLVED] Converting a string by detecting Chr(183)
  135. How can remove " after do replace in beginning and end of cell
  136. Internal Hyperlinks in Pivot Tables
  137. [SOLVED] Compare dates - password required if expired
  138. [SOLVED] Help with an array formula
  139. [SOLVED] Using a variable to call either a form or a sheet
  140. VBA, i want the value, not the formula
  141. Getting VBA to decide which cell to use
  142. Need help with my macro "Sub or function not defined"
  143. How do i extract a part of text file content
  144. UserForm Retrieve Data From Correct Sheet, based on Combo Box Value
  145. [SOLVED] Find a cell in a range based on a condition & change the value of the cell beneath
  146. VBA code for Autofit row height for rows with merged and unmerged/normal cells
  147. Toggle SUM/AVG on Pivot Table
  148. Enable and disable calculations for a range of cells
  149. Userform - Different rights for differenz users
  150. copy email body to excel
  151. xlDown not returning last used cell
  152. [SOLVED] Remove lines with no entries and copy back some data
  153. [SOLVED] VBA Unprotect not working properly
  154. Print from Image Object in Sheet using VBA (range of print changed when filter table)
  155. [SOLVED] how to create a excel macro (button) that will show next number from a list?
  156. Loop Thru Cells
  157. Comparing Data Across Sheets, with Multiple Variables
  158. [SOLVED] Count_Colours_Not_Duplicate
  159. [SOLVED] Copy and paste row of data to another worksheet macro
  160. Find a last row and insert a values
  161. [SOLVED] Multiple Consecutive Line Feeds Using vbCrLf
  162. Using Macro to Pull in New Data Every Month
  163. [SOLVED] Merging two Private Sub
  164. Invoice date help
  165. [SOLVED] Very simple problem with no solution found
  166. Username to populate
  167. Replace functions with hard values
  168. Change color of cell/cells
  169. checkbox in excel
  170. [SOLVED] Help with Offset and r Resize formulas to select a range.
  171. Excel VBA macro to fill web form using excel data
  172. Import CSV File to Workbook
  173. [SOLVED] Extracting Dates
  174. VBA Power Analysis Macro help
  175. Automatically copy certain cells from rows from one Worksheet into another Worksheet
  176. [SOLVED] Automatically filter selected worksheets by date criteria
  177. VBA - Help me to solve this one, makro who can select between 3 sheets
  178. collection / array help
  179. Excel VBA performance variance issue
  180. VBA & IE Form
  181. [SOLVED] VBA to extract data from WebPages
  182. [SOLVED] Run code on each cell until month changes
  183. Sorting Issues
  184. Linest() <> Chart Trendline Formula
  185. Deleting specific cells when a condition is no longer met
  186. [SOLVED] Script to loop match initial search term in data column to find the value of cell bel
  187. Convert PDF data into Excel or txt using VBA
  188. [SOLVED] Concatenate cells with leading zeros vba
  189. Move data from sheet 1 to 2
  190. [SOLVED] EXCEL (macro) - Analysis of hourly intervals from sectional graph, correlation
  191. Help Logging into Website with VBA
  192. function keys open wrong dialog
  193. Switch case not giving desired product
  194. Change from Internet Explore to Google Chrome
  195. Excel Date formatting issue
  196. Delete by Dates
  197. [SOLVED] dblclick cell text cursor blinking
  198. VBA Column comparison against sheet and viceversa
  199. Manipulate 2 different columns to become one
  200. Deleting Data from Database using VBA
  201. Class Does not suppor automation or does not support expected interface
  202. Time stamp in a fixed cell when content of specific cells in row are changed
  203. VBA Macros Copy Paste Seed Up Help
  204. Ink Signature to cell
  205. Populate Form Label Captions from Worksheet
  206. Help w/Offset Paste
  207. IF function in VBA - Can't COPY
  208. [SOLVED] Open Folder with Comma and Ampersand in Name
  209. Pivot Table not updating after Cut and Pasting Values to Data WS
  210. [SOLVED] VBA outlook
  211. First VBA project summary file please help
  212. CopyRow help for multiple tabs
  213. Repeat code for each row
  214. [SOLVED] Copying only values in VBA
  215. When changing Row B in Sheet 2 automatically do sorting with Row B in Sheet 1
  216. Copying certain rows of worksheet into new worksheet depending on date
  217. [SOLVED] Break text
  218. VBA Userform Precedence
  219. Transferring Userform data to excel
  220. Hyperlink function reference multiple cells?
  221. vba consolidation of specific sheets data and Pasting in specific Mater sheets
  222. Excel VBA IMAGE help!
  223. [SOLVED] Transferring data to a summary spreadsheet
  224. SUM for a dynamic table
  225. Convert Userform with a scrollbar into pdf
  226. Excel 2016 .CopyPicture
  227. VBA-Extract only number from a string
  228. Best method to check range completion before running rest of program.
  229. [SOLVED] Worksheet collections in formula?
  230. VBA too long-winded help needed.
  231. Ifnumber & Search with mulitple Conditions
  232. [SOLVED] vba help on declaring varible
  233. [SOLVED] Copy certain worksheets from one workbook to another while keeping format
  234. API Help Needed
  235. [SOLVED] Copy a single field from Access to Excel
  236. [SOLVED] Copy data from rows to other worksheets
  237. VBA - Email notification when job added to list.
  238. Copy formula/row range down to a value specified by another cell?
  239. [SOLVED] Fill Userform Text Box From Worksheet
  240. Data transfer depending on the empty cells
  241. Getting a Macro in Power Point to skip update if and excel sheet is open
  242. [SOLVED] Excel Code Help, Loop related
  243. Update Another Sheet with Results of Formula w/Multiple Criteria
  244. File properties using FSO and Dir
  245. Product List Search Function
  246. Create Power point presentation from multiple excel files
  247. [SOLVED] Align List Boxes On User Form Using a Loop
  248. Sumif from pivot table
  249. [SOLVED] Add Unequal Amount of Data To Two Columns of UserForm List Box
  250. Filter quantity of the commodity code from total data and minus decesing ???