|
- Creating a VBA macro for speedier comparison work
Thanks for the speedy reply! I've attached two documents here, the first is the template that is being completed by x amount of people and then returned to us The second document is the macro as I've managed to get it going so far Financial Comparison Macro V1 xlsm Workbook Template for Macro xlsx The template contains a summary tab which is what I'm trying to get VBA to look at and pull
- Locked VBA Code Disappears - Microsoft Community
Hi Stuart, Thanks for posting in the community We are happy to help you According to your description, to narrow down the situation, I would like to suggest you open this workbook in the Excel desktop version, open the Version History pane, then open each previous version one by one and find the version where the VBA code still exists After that, you can find the related user who edited the
- Updated data in for forms - Microsoft Community
Hi Paul, Thank you for your reply and further clarification If you tend to update your data from linked Excel workbook to your forms in Microsoft Forms It is not feasible to achieve it Because it is a “one-way syn”c from Microsoft Forms to Excel, which means Excel workbook will only get the responses and record in linked Excel workbook from Microsoft Forms, if you tried to edit or
- I cant save, save as, email or rename my excel workbooks. How do I . . .
I need to fill in data on a particular workbook that was emailed to me I can fill in the data, but my program won't let me save it, rename it, save as, or email it out
- Excel2016 VBA workbook. open filenameの構文について
こんにちは。Excel VBAに下記記載があるとします。 workbook open filename"Aファイル"sheets（"Bリスト"） selectこの場合ファイル名=Aファイルを開いた後Bリストを参照となるのですが、Excel bookのファイル名を変えるとAファイルを参照できなくなりエラーとなります。 Excel
- How to Print (not Save as) Excel worksheets as separate PDFs?
I have an Excel workbook, with many worksheets, each with a descriptive label I want to print them as separate PDf files I already have a VBA macro that allow to Save each one as a separate PDF file,
- Copy Move a sheet break links - Microsoft Community
I want a macro to make a copy of the selected sheet (s) to a new workbook and break links with the other sheets or UDFs in the original workbook turning the UDFs formulas referring to other sheets or AddIns to their respective values
- Hyperlink a cell within workbook - Microsoft Community
The free Excel workbook "Professional_Compare" (updated) is available at MediaFire (compares every cell in two worksheets Or each row in one worksheet against all rows in a second worksheet - choice of compare type) It includes optional "Clean Data" and "Quick Uniques List" utilities
|
|
|