Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails
Set wbk1 = ActiveWorkbook Set wsht1 = wbk1.Sheets("Sheet1") Set wbk3 = Workbooks.Open(wbk3path) 'Interface workbook Set wsht3 = wbk3.Sheets(1) wsht3.Range("A1:AA2").Formula = wsht1.Range("A1:AA2").Value wsht1.Range("A1").EntireRow.Delete wsht1.Range("A1").EntireRow.Delete Do I = wsht1.Range("A1") wsht1.Range("C1:AA1").Copy K = wsht3.Columns("A:A").Find(What:=I, lookat:=xlWhole) wsht3.Range(K).Offset(0, 2).PasteSpecial xlPasteValues wsht1.Range("A1").EntireRow.Delete Loop Until I = ""
|i need to create an excel drop down list that that is limited||7||29|
|Macro to Refresh the Hyperlinks without opening the source files||1||36|
|Excel - Macro hide columns not working||4||19|
|cannot get subtotal to work||8||17|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
14 Experts available now in Live!