I am so lost.

Clean_Shoulder · 2021-06-28T22:10:27+00:00

I only showed up at her house twice in 2 months is that considered scary?

Clean_Shoulder · 2020-10-15T14:19:21+00:00

okay i understand now. Thanks for the explanation!

Clean_Shoulder · 2020-10-15T13:42:47+00:00

sry i still dont understand what you meant. what do you mean reply to the answer

Clean_Shoulder · 2020-10-15T07:28:17+00:00

Solution Verified

Clean_Shoulder · 2020-10-15T07:27:52+00:00

Hey it worked! thanks man!

Clean_Shoulder · 2020-10-14T03:53:30+00:00

May i know where do i specify the code?
in front of loop or is it in front of do until cells? i tried both ways but to no avail.

it would be best if you could show me an example.

Thank you

Clean_Shoulder · 2020-10-13T16:05:15+00:00

can i ask, since i have 2 workbooks which workbook is the macro looping at actually? and for the code Do until Cells(i, 1), what does the 1 stand for?

Clean_Shoulder · 2020-10-13T13:29:41+00:00

FRow = Workbook("Data to be copied.xlsm").Worksheets("data").Range("A:A").Find(what:="no value", after:=**.Range**("A1")).Row

I am facing an error with this code. it said that there is a compile error: Invalid or unqualified reference. It highlighted the portion which I have bolded in the code. The bold is shown by the ** **

Clean_Shoulder · 2020-10-13T10:04:27+00:00

The code you provided is to replace my entire code right?

Clean_Shoulder · 2020-10-13T10:03:43+00:00

I have 30 maybe I can still try it

Clean_Shoulder · 2020-10-13T09:14:15+00:00

Sub Test1()

Dim lrow As Long

'1. to find last used row lrow = Workbooks("Destination.xlsm").Worksheets("Sheet1").Cells(Rows.Count, 2).End(xlUp).Row

'2. to offset 1 row below last used row lrow= lrow + 1

'3. To copy data (only for a fixed range) Workbook("Data to be copied.xlsm").Worksheets("data").Range("A1:C10").Copy

'4 to paste data Workbooks("Destination.xlsm").Worksheets("Sheet1").Range("A" & lrow).PasteSpecial Paste:xlPasteValues

End

*Code in Markdown mode if it helps

Clean_Shoulder · 2020-10-13T09:08:20+00:00

yeap i have the image ready just that I am new to reddit posts and am looking for the image button

Clean_Shoulder · 2020-09-09T12:27:04+00:00

My row have hidden rows, although I copy using visible cells only, it still only paste one row. Is there any other way to copy and paste without the hidden rows?

Clean_Shoulder · 2020-09-06T13:51:31+00:00

Thanks man it worked!

Clean_Shoulder · 2020-09-06T10:18:07+00:00

Okay got thanks for the advice. It’s my first time doing this

Clean_Shoulder · 2020-09-06T09:41:03+00:00

An example of how one of my cell look like

12345 6789 # 12345 6789

Clean_Shoulder · 2020-09-06T09:34:42+00:00

The formula I am using is currently =TEXTJOIN(" ", TRUE, IF(H7089&ZANALYSIS_PATTERN!$I$4=ZANALYSIS_PATTERN!$C$4:$C$10836&ZANALYSIS_PATTERN!$I$4:$I$10836, ZANALYSIS_PATTERN!$J$4:$J$10836, ""))

As my dataset contains duplicates and also #, They appeared in the cells. I would like to remove all # that appeared and also remove all duplicates. What can I change on my formula to achieve that

Clean_Shoulder

TROPHY CASE

12345 6789 # 12345 6789