
How do I get data form one sheet to copy to another one if it contains ...
Mar 13, 2023 · Here are the steps: * Open the Excel workbook that contains the sheet with the data you want to copy. * Create a new sheet where you want to paste the data. * In the new sheet, enter the …
copy/paste sheet with subtotal to another workbook
Nov 9, 2010 · I have a spreasheet with subtotals that needs to be copy/pasted into a new woorkbook. I see that when copy/pasted within the same workbook to another tab it retains the subtotals, but …
Copy/Move a sheet & break links - Microsoft Community
Jan 14, 2011 · 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 …
Pulling certain data from one sheet to another
Sep 12, 2011 · Pulling certain data from one sheet to another Hi Folks, I have a sheet "Tracker Sheet" that has data in columns A to AY. I have a second sheet "Weekly Report" that I want to display some …
When copying excel column's into an Outlook email, I loose the Excel ...
May 2, 2023 · I use the function of copying Excel column's into an email chain to speak w/ clients. However, over the past week the visual appearance of Excel is lost and it only copies the text making …
Sheet.Protect VBA script breaks sharepoint co-authoring?
Feb 8, 2018 · Sheet.Protect VBA script breaks sharepoint co-authoring? Hello. I have macro enabled workbook that has a protected sheet and shared in SharePoint 2016. Everything works well when …
Macro to move rows to another worksheet if a cell contains a certain ...
Jul 19, 2010 · I'd like to know how to move rows to another worksheet if a cell of a determined column indicates a certain value (e.g. action done). Thanks!
Auto Filter based on range on another sheet - Microsoft Community
Jun 17, 2014 · Hi, I need to filter one sheet based on the values in a range on another sheet. On sheet "ImpactReport" I need to filter Column A based on the values of Column A on the sheet "ActivePlants".
Can you combine multiple open Excel files into one Workbook?
Sep 24, 2012 · I need to place multiple excel files into one workbook. Is there a way to do this easily without having to copy & paste each one individually and placing them into one workbook (multiple …
Copy Excel Sheet into Word via Visual Basic - Microsoft Community
Mar 28, 2014 · Copy Excel Sheet into Word via Visual Basic Hi, I have a similar question to the one below, except that I would like to initiate the VB code from Excel - if possible. Basically, I want to …