473,320 Members | 2,006 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Excel Help

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.
Apr 24 '07 #1
6 1982
manontheedge
175 100+
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?
Apr 24 '07 #2
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.
Apr 25 '07 #3
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.
Apr 25 '07 #4
manontheedge
175 100+
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.
Apr 25 '07 #5
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.

Expand|Select|Wrap|Line Numbers
  1. Sub assassin()
  2. '
  3. ' assassin Macro
  4. ' Macro recorded 4/25/2007 by User
  5. '
  6. ' Keyboard Shortcut: Ctrl+j
  7. '
  8.  
  9. j = 0
  10.  
  11. For i = 1 To 30
  12.  
  13.  Cells(i, 3) = Cells(j, 1)
  14.  
  15.     j = j + 5
  16.  
  17.     Next i
  18.  
  19. End Sub
Apr 25 '07 #6
manontheedge
175 100+
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
Apr 26 '07 #7

Sign in to post your reply or Sign up for a free account.

Similar topics

7
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...
8
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...
6
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#...
17
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
2
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...
14
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...
2
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,...
9
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...
0
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...
0
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...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
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...
0
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...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
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....
0
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
0
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...
0
isladogs
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.