VBA Excel: Code needed to remove empty columns of worksheet of a very big file.
- or -
Post a project like this2330
$$$
- Posted:
- Proposals: 4
- Remote
- #1803271
- Awarded
Description
Experience Level: Expert
General information for the business: A leading unversity
Kind of development: New program from scratch
Num. of modules: 1
Description of every module: I am a medium good VBA programmer. I have a big database that has 55000 Rows, and 78 filled columns. Unfortunatelly, the worksheet goes to the Address Column "NA". This results in a too big file causing troubles.
My computer is to weak to delete this Columns and to copy paste the data into a new worksheet.
Description of requirements/functionality: I need a code that allows me to either
a) delete the columns: I know how to programm this theoretically, but with my codes this results into "not reponding"
b) copy paste the columns with data into a new worksheet with then smaller dimensions. Also here I would theoretically know how to do it, but my computer crashes doing that.
So I need somebody that know how to handle this (maybe while copy pasting clearing cache?).
that 1) fixes the problem and b) hands me the code that I can do that in the future my self.
OS requirements: Windows
Extra notes: I need it as fast as possible.
Kind of development: New program from scratch
Num. of modules: 1
Description of every module: I am a medium good VBA programmer. I have a big database that has 55000 Rows, and 78 filled columns. Unfortunatelly, the worksheet goes to the Address Column "NA". This results in a too big file causing troubles.
My computer is to weak to delete this Columns and to copy paste the data into a new worksheet.
Description of requirements/functionality: I need a code that allows me to either
a) delete the columns: I know how to programm this theoretically, but with my codes this results into "not reponding"
b) copy paste the columns with data into a new worksheet with then smaller dimensions. Also here I would theoretically know how to do it, but my computer crashes doing that.
So I need somebody that know how to handle this (maybe while copy pasting clearing cache?).
that 1) fixes the problem and b) hands me the code that I can do that in the future my self.
OS requirements: Windows
Extra notes: I need it as fast as possible.
MARC M.
100% (49)Projects Completed
36
Freelancers worked with
27
Projects awarded
34%
Last project
30 Jun 2021
Switzerland
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Marc,
I too would like to see how far you've got with this. Please send me your file to take a look at, I will then be able to create suitable code for your purposes.
Regards
Tony H -
please attach the file
546350546345
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies