Re: [ExcelVBA] Re: Macro to copy info from one shet to another

 

How about copying the original sheet a few times, filtering and deleting rows?

If the formulas are relative then that should work I think.

HTH

Lisa

-----Original Message-----
From: sheizageek@yahoo.com [ExcelVBA] <ExcelVBA@yahoogroups.com>
To: ExcelVBA <ExcelVBA@yahoogroups.com>
Sent: Mon, Feb 4, 2019 7:46 pm
Subject: [ExcelVBA] Re: Macro to copy info from one shet to another

I did try the filters and that works great but not 100%.  There are some hidden columns that perform date/math functions from the first data columns and they still function for the entire sheet and not just the selected ones.

 

If there isn't a better solution, I can use this.

 

Thanks for a reply.

 

Sharron

__._,_.___

---

Posted by: Green <1z@compuserve.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (5)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
------------------------------------

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

SPONSORED LINKS

.

__,_._,___