VBA macro

[Ishaqur]

I have 1700 hundred record some are debit and some are credit I need to move credit value in debit column with negative sign as value

 

[jolivanes]

See last sentence in Post #8 .
DropBox or equivalent is your only option.

BTW, if I understand you right, you want to copy and paste between different files.
That should be a new Post as it has nothing to do with your original request.

 

[Ishaqur]

Yes please

 

[Ishaqur]

Reply please
BTW, if I understand you right, you want to copy and paste between different files.
That should be a new Post as it has nothing to do with your original request.

 

[Ishaqur]

I have to copy column f , g , h data from monitor file and want to add in main file below last entry of column f g and h

And also add serial number in e like last drool number in column e is 2014 if we copied four record from monitor file serial number should go 2018

And also want to copy c and d last data in next for record

 

[jolivanes]

Please do not private message people. The forum is for the benefit of all people that need help.
It is entirely up to you to describe in detail what you would like to achieve.
In the PM you wanted to delete all the values that are doubles or more. What does the previously supplied code do?

 

[jolivanes]

Maybe you mean to change the code from Post 16/17 from this

.Offset(1, -2).SpecialCells(12).ClearContents

to this?

.Offset(1, -2).SpecialCells(12).EntireRow.Delete

Have you checked into DropBox for a file to be shared with people that can help you?

 

[Ishaqur]

Hello sir

I have two workbook in the same place one workbook name is A and another workbook name is B

I don’t know how many rows in A file I need to copy column A , F H from row 2 to last row in to file B in Colomn A, F and H from row 2

Please help

 

[Ishaqur]

Hello I am want to filter field 25 and delete all record after filter Criteria is not equal to 1
Delete entire row without heading

Pleas response someone

 

[Ishaqur]

Hi I have two files one is main.xls and second is monitor.xls both file has A to Z column I need to copy from monitor file column E F G H k in main file bottom of the record