I have a very basic issue in excel and I can't for the life of me find the solution. I have a dense worksheet of data and I want to distill some of the information into a much shorter list. The data is ordered and the information I want to pull out from the big sheet and put in the little sheet occurs in the same column in every 30th cell. In my new sheet, I want my column of information to refer to every 30th cell. In other words, I want h28, h58, h88, h118, etc. Unfortunately, I don't know how to make excel automate this process (there's too much info for me to do it by hand). Does anyone know how to do this? Thanks.
6 1982
are you saying you want to copy every thirtieth cell into the other sheet? or copy groups of 30 cells at a time?
you can use a macro...it will make this very easy. Do you know anything about macros or programming in Visual Basic?
i want to copy every 30th cell into one column. i don't know much about macros, but i'm going to spend some time tonight going through some online tutorials.
You can download SCAR, it was built by Kaitneiks for games, it works best on a game, which i=I will not give out the name, and that'll be pretty easy if you can script well...
I, myself, have no idea how to script in SCAR, but there are places for tutorials. The scripts are scarce, the most valueble place for scripts is scar-scripts.com or something, but they're all mostly game macros.
I was actually referring to Microsoft Excel. Macros are built in to it. Read up a little on it. It will make what you're doing much easier.
i'm trying to write a macro to do the job, but i'm not very familar with the syntax of the programming language. i tried writing the following macro, but there's a bug in line where i try to assign values to the cells. can someone tell me what error i'm making? thanks. - Sub assassin()
-
'
-
' assassin Macro
-
' Macro recorded 4/25/2007 by User
-
'
-
' Keyboard Shortcut: Ctrl+j
-
'
-
-
j = 0
-
-
For i = 1 To 30
-
-
Cells(i, 3) = Cells(j, 1)
-
-
j = j + 5
-
-
Next i
-
-
End Sub
try j = 1, instead of j = 0 ... the way you start it, the part with ( j, 1 ) is referring to cell ( 0, 1 ), and that cell doesn't exist
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Mike |
last post by:
Please help. I am using object.quit in an attempt to
quit an excel application that I started with createobject
("Excel.Application"). The code executes, but does not
stop the application. When...
|
by: mytfein |
last post by:
Hi Everyone,
Background:
Another department intends to ftp a .txt file from the mainframe, for me
to process.
The objective is to write a vb script that would be scheduled to run
daily to...
|
by: Matthew Wieder |
last post by:
I have the following requirements:
Build a stand-alone C# application that asks the user to click in a cell
in an Excel spreadsheet, and then displays the address of that cell in
the C#...
|
by: Mansi |
last post by:
I need to do some research on how to use excel automation from c#. Does
anyone know of any good books related to this subject?
Thanks.
Mansi
|
by: Kumar |
last post by:
Hi Folks,
I have a question regarding my windows c# application.
This application just reads MS Excel file and puts the data in to sql server
database.
In that excel file ,it has one named cell...
|
by: pmud |
last post by:
Hi,
I need to use an Excel Sheet in ASP.NET application so that the users can
enter (copy, paste ) large number of rows in this Excel Sheet. Also, Whatever
the USER ENETRS needs to go to the...
|
by: Mad Scientist Jr |
last post by:
>From an asp.net web page I want the user to open the results of a SQL
query in Excel, as automatically as possible (ie not having to loop
through columns, rows, in code).
For this,...
|
by: Doug Glancy |
last post by:
I got the following code from Francesco Balena's site, for disposing of Com
objects:
Sub SetNothing(Of T)(ByRef obj As T)
' Dispose of the object if possible
If obj IsNot Nothing AndAlso...
|
by: hitencontractor |
last post by:
I am working on .NET Version 2003 making an SDI application that calls MS Excel 2003.
I added a menu item called "MyApp Help" in the end of the menu bar to show Help-> About.
The application...
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
| |