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

  1. [SOLVED] VBA To Re-lock a specific cell after 30 seconds
  2. Find currency and add/debit according to amount
  3. Undo/Redo or CTRL+Z – CTRL+Y »» does not work for my own macros
  4. [SOLVED] how to use userform to operate pivot table
  5. [SOLVED] Countif and Count on visible rows
  6. [SOLVED] Edit textfile vba
  7. HELP! VBA Problems
  8. [SOLVED] .TextToColumns doesn't seem to work reliably.
  9. [SOLVED] Need help getting results of macro displayed, starting at row 5 column B thru F
  10. Starting from specific place in a row
  11. [SOLVED] Sumif multiple criteria
  12. [SOLVED] Prompt user for date and user to Open file
  13. [SOLVED] Copy and Paste
  14. Help to make VBA Model in Excel run quicker
  15. Very Very Very Very Complex excel formula required...
  16. split text in different cells after each underscote "_"
  17. Find previous day balance.
  18. Moving Sent Items To Another ARCHIVE Sent Folder.
  19. VBA PasteSpecial error
  20. Creating Checkboxes that when click uncheck the other
  21. Copying with condition
  22. Word Document Vba Excel - Changing Information in Multiple Documents
  23. [SOLVED] Justify text in a msgbox
  24. Insert new column with a Formula
  25. [SOLVED] How to force WorkSheet InputBox to accept currency or decimal value
  26. Macro defaulting to original filepath after sheet extracted to new workbook
  27. [SOLVED] HELP Getting data to final sheet based on highlighted cells!!!
  28. [SOLVED] VBA code Function to check if date is weekday
  29. .CompareMode with Dictionary
  30. internetexplorer from excel vba run time error 462
  31. Calculating Max and Min Value of RTD without capturing them.
  32. Defining range to convert to CSV
  33. [SOLVED] How to Combine Multiple Excel Workbooks into Existing Workbook
  34. [SOLVED] Counting letters and numbers separately in a single cell
  35. Add In Preferences
  36. Copy and paste in one worksheet by conditionqq
  37. how to filter all dates between two dates
  38. [SOLVED] VBA Code Require - Consolidate multiple sheets in 1 sheet when column Headin differs
  39. [SOLVED] Renaming Word Document from Excel VBA
  40. Compare two sheet , i.e import sheet and htmlcopy sheet and give result in third she
  41. [SOLVED] Roundup values in specific Range using vba
  42. I can't find a control
  43. [SOLVED] Issue with Excel Division of Fractions..Not showing correct results
  44. I get the error with that if condition.
  45. Fill down name according to column B
  46. vba - Create subfolder as per monthwise and one Masterworkbook
  47. Move all files on XX Folder to XX Folder based on excel.
  48. How to invert and copy data from a cell?
  49. VBA Coding help please
  50. Stgange overflow error
  51. VBA to load specific cells from one doc to another
  52. Macro to parse a file and input in a spreadsheet the lines that match parameters
  53. Move Filtered Data & Get series of Numbers
  54. Pivot report filter with wildcard
  55. VBA code help - concatenation
  56. [SOLVED] Open File not working
  57. Inserting lines in text file according to a list
  58. [SOLVED] How to Open a Picture using Windows Photo Gallery
  59. Print multiple sheet as single pdf page
  60. Defining names in VBA using for loop
  61. Delete Partially Duplicate Rows based on Multiple Values
  62. Search for data based on cells in another worksheet and copy data to another wrksht
  63. [SOLVED] Assistance required to resolve ComboBox_Change issues
  64. Copy paste
  65. Copy paste csv to xlsx
  66. extract after multiple criteria
  67. [SOLVED] String Array
  68. [SOLVED] Copy data based on a certain criteria
  69. Drop-Down List to Display Different Pivot Tables
  70. Concatenate Conditional Long String in Formula
  71. [SOLVED] Refreshing linked cells to 3 workbooks on different pc's
  72. Search for data in different wrsht and paste result to other column in original wrsht
  73. [SOLVED] NEED HELP IN GETTING MACRO TO WORK NON SPLIT DATA MACRO
  74. Scatter graph based on pivot table
  75. [SOLVED] How do I avoid selecting Shapes?
  76. SQL query run on Excel VBA
  77. Suggestions for Creating Hundreds of Data Lines for Budget
  78. Delete Blank Rows and Add Borders on Last Row
  79. Dlete row
  80. Unhide sheet with password protection
  81. Copy paste
  82. User Form Shown when open VBE Editor
  83. [SOLVED] Delete row
  84. [SOLVED] Connecting to phpMyAdmin SQL DB through SSH
  85. If Column X Contains Specific Text, Copy to Col X cell & del
  86. Reference a person in e-mail from VBA
  87. Userform Enter key
  88. Turn Multiple OptionButtons as False
  89. Add border top and bottom row for all pages
  90. VBA Sheet Linking Issue
  91. How to Sum Variable Columns and Rows Using VBA
  92. How to automate an email process –ideas and or advice
  93. Formula by vba
  94. Popup UserForm, the custom message box, is not closed.
  95. filter data Automatically with wildcard characters string
  96. hide/unhide column after criteria match
  97. VBA to use Format Painter from one row to another row
  98. Pulling data from MenaData and BioData in result sheet based on employee id
  99. Clear the data
  100. Page break setup
  101. need macro for auto year workbook with auto months and dates
  102. Combobox's
  103. VBA Help
  104. [SOLVED] Arranging data that is in columns in a different dynamic way
  105. [SOLVED] Move file by vba
  106. After page break bottom border for all pages
  107. Select record and update
  108. [SOLVED] Look up function vba?
  109. [SOLVED] Issue with VLOOKUP.....Working on 1 Cell but not the other cell....
  110. [SOLVED] Updating Win/Loss records with VBA Button
  111. The number of users in the shared workbook
  112. [SOLVED] Select Current Row when a Condition is True in a For Each Loop
  113. Best way to handle duplicate records....
  114. [SOLVED] Change Value on Multiple Pivot Tables at Once
  115. How can I paste specific rows and replace specific rows
  116. Searchable Drop-Down List Stops Working when Sheet Protected
  117. Debugging Offset within a Range?
  118. Opening XLSM file with Excel 2007 does not display content
  119. Vba process entire row delete
  120. Change the copy order in this VBA code
  121. VBA - Set background color (and text) according to column in another dataset
  122. [SOLVED] VBA command button to auto generate outlook email
  123. Extract unique text from cell - excel formula
  124. Please help
  125. [SOLVED] open worksheet from different worksheet cell
  126. Popup to display warning message
  127. Update Calendar Fills by Revolving Sequence Using VBA
  128. Complex Netting of Amount Against An Array
  129. Copy all of the sheets in an array to a new workbook
  130. how to fixed box text in the excel?
  131. Refer to cells instead of hardcoding text and numbers
  132. Best VBA process for extracting data
  133. Need to be able to move things in order based on sequence of events.
  134. VBA CODE for Subtract two cells
  135. Change cell color based on other cell value
  136. % variation between two cells
  137. VBA - How to Cycle through Workbooks to Paste Columns To a Matching Worksheet
  138. [SOLVED] VBA coding help
  139. Lookup closest value azimuth (0-360°) value in specific range and return over 360°
  140. If condition for stop printing sheet
  141. How to extract all data with same name
  142. Make Directory and File If doesn't exist?
  143. [SOLVED] crieria item in list to replace in another column
  144. Copy/Transpose/Paste Vertically Breaking on Blanks Macro
  145. need macro file with macro button to import and split the data in to multiple work bo
  146. logic operator bug, I've never had anything like this
  147. [SOLVED] Shell( .exe with input files)
  148. [SOLVED] Check if Plink.exe is active
  149. VBA open another Workbook copy and paste if condition is met
  150. Extract author and date from web page
  151. How to have excel add any new data in a pivot automatically
  152. [SOLVED] How to unhide Sheets based on 3 cell values
  153. Paste contents into cell that has color
  154. Copy Sheet to New WB but Macros still point to sheet in WB
  155. Duplicate the sheet and updte the Master
  156. Pass parameter into SQL statement in Power Query
  157. VBA Browse multiple workbooks how to short the code....
  158. [SOLVED] ADODB not getting all the data from one field
  159. VBA update and clear the value without delay
  160. [SOLVED] Hide and unhide columns according to number of days in my calendar
  161. Prevent to modify file extension
  162. Update Shopping list Fills by looking up on another workbook Using VBA
  163. VBA - Find and find next and sum their value help.
  164. [SOLVED] AdvanceFilter- Multiple Criteria in one Cell
  165. How do you write to worksheet in Excel 2007
  166. [SOLVED] Save as pdf's
  167. Open latest, partial named file in folder.
  168. Clear cell data that does not contain specific value
  169. Runtime Error
  170. Create Bookmarks from cell names when saving as pdf
  171. add a new event to an event change macro
  172. Vlookup Choose for 3 table after criteria macth
  173. Copy and paste a row in a new worksheet VBA
  174. Reference large spreadsheets without opening them
  175. Update Sheet2 based on date/time values in sheet1
  176. [SOLVED] How to get name of Option Button created dynamically
  177. copy cell value from one sheet to another sheet
  178. Next without For error
  179. Problems with Object Variable or With block variable not set
  180. vba using on android
  181. SQL on Excel Table
  182. [SOLVED] Formula to look for a cell phrase and add a cost
  183. [SOLVED] Transfering Values From Textbox to Textbox
  184. [SOLVED] Write array to row (not column)
  185. Mismatch data - Dates issue for certain range
  186. VBA Pivot Grouping help
  187. questions about ranges and refedit.
  188. [SOLVED] Create copy button on userform that autofills information already entered on userform
  189. String Manipulation to Sentence.
  190. Copy and paste filtered rows
  191. [SOLVED] RANGE OF CELLS TO IMAGES
  192. Filtiring Dates in Listview
  193. [SOLVED] combine macros and have access from my personal workbook
  194. [SOLVED] Different granularity for dashboard
  195. Userform Textbox Number format
  196. Vba to execute what was done with conditional formatting
  197. [SOLVED] UserForm Label Text Direction
  198. VBA Countif help Passing Criteria through Array
  199. Horizontal cell data to Vertical cell data excel formula
  200. [SOLVED] EXCEL VBA - Open the Specific file and copy the Data by Vlookup and Offset
  201. 'Send e-mail' bolt-on to existing VBA code
  202. VBA for highlight & extract cells addresss where harcode mannual entry
  203. VBA to execute filter for future date ranges
  204. [SOLVED] Duplicate Entries in Excel
  205. Populating listbox with selected columns
  206. VBA Change FileName with Numbers sequentially
  207. Extract Data from PDF to Excel in a format
  208. Open specific folder based on cell value or create folder
  209. How are these things done inside VBA Excel?
  210. VBA TextBox Upon Opening, Adding Userform, Not Prompted After Initial Save
  211. [SOLVED] How to count, sum and subtotal values in a filtered listbox?
  212. VBA: Copy and paste row data in multiple column if Sheet1 ID matches with SheetY ID
  213. Copy and paste images from excel to word with VBA
  214. Database Style
  215. Using a loop to run through Adding Freeform Nodes
  216. [SOLVED] Removing extension (.xlsm) when converting to PDF
  217. VBA R1C1 help on vlook up
  218. [SOLVED] Populate multiple textboxes
  219. How Can I Build Chat with Vba?
  220. [SOLVED] VBA SPLIT into cells and reshape into table
  221. Update chart after cell gets updated
  222. [SOLVED] User type not defined error trying to merge pdfs
  223. small with condition
  224. [SOLVED] Make Array with Full Paths to PDF Files in Parent and Subfolders
  225. VBA Search form
  226. Pull data from one table to another
  227. If cell is Empty!
  228. VBA: Input cell data outout in three ways
  229. Input box to display as ******
  230. How to share an Excel file containing a macro on the network
  231. Selecting (copying) specific rows up to the last column
  232. Keep userform open when opening or closing other workbooks
  233. help adjusting code combine two tables from two sheets to another sheet
  234. vba advanced_Filter help
  235. Customize ribbon 2013 excel
  236. [SOLVED] VBA Code not running if sheets are protected
  237. Pull from Table1,Table2, Test Data, Then place in Table3
  238. [SOLVED] VBA from text to number
  239. VBA Validation Fields and Date and Time Picker
  240. Require VBA Code for filter Data after criteria match
  241. [SOLVED] Finding/Changing Default Printer
  242. [SOLVED] Identify missing numbers in sequence
  243. [SOLVED] Reformat a table
  244. VBA Error 'Range of object worksheet failed
  245. Copy data between sheets
  246. VBA Macros to Copy Data to Another Workbook
  247. vba copy paste
  248. Copy data from website source code to spreadsheet
  249. [SOLVED] How to Log Changes on Sheets!
  250. Multi-use UForm - can it be improved upon?