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 166 167 168 169 170 171 172 173 174

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