I am able to export MS Access 2010 tables to an Excel workbook with
multiple tabs -- and it even overwrites the cells from the last time it ran
-- but -- if there's less data than the previous run, the left-over rows
from the previous run screw up the data! Obviously unacceptable. So the
sol
Hi Everyone
I have a very wide sheet and sometimes it gets difficult to follow which
row contains the data I need.
I would love it if excel could overlay shading or a colour to highlight the
row and column of the active cell.
Ive seen vba code which will do this but it overwrites the fill col
In an Excel macro, inside a loop I issue the following,
where the names are unique each time:
Workbooks.Open Filename:=openFYL$
With Worksheets(1)
' .Copy''do not need; saves BOOKn space
.SaveAs svWK$
End With
' NOTE: Related metadata folders are created on the fly
This routine USED to work.
I added two lines of comment to indicate the problem.
...
vNam = Cells(2, 7).Text + "V" 'board voltage
pPath = "D:\ANALOG\HVREG\Boards\TITANTWO\TT_C\Jumpers\"
ActiveSheet.Shapes(1).Select
' ERROR: Method of 'Active Printer' of object '_Application' faile
data at the end, and give options at the start for "what
is next".
Now,it would be useful to be able to position that input box, as well as
change the font of the text in the box.
And, i think lastly, have the app automatically run when the XLS program
is launched.
Thanks,
Robert B
ell.FormulaR1C1
> ' check alfa?
> Wend
>
> End Sub
>
>
> +
> *I did not do this for you. God is here working through me for you.*
>
> On Tue, Oct 21, 2014 at 12:39 AM, Robert Baer > wrote:
>
>>
>>
>> On Monday, October 20,
On Monday, October 20, 2014 12:48:25 AM UTC-7, Vabz wrote:
>
> Hi can you share sample files...
>
> +
>
>
Here is what i have so far..present question imbedded
Dim Avar As String, Nvar As Integer
Dim Frow As Integer, Fcol As Integer
' Start row data entry
Frow = 9: Fcol = 1 ' aka "A"
On Saturday, October 18, 2014 8:16:05 PM UTC-7, Robert Baer wrote:
>
> Assume one has a spreadsheet with some titles and column headings, along
> with a row of data already filled out by an automated copy from a previous
> "journal".
> Pardon this is long; thin
Assume one has a spreadsheet with some titles and column headings, along
with a row of data already filled out by an automated copy from a previous
"journal".
Pardon this is long; think i have given all what i want out of this Excel
"program".
Assume previous journal (sheet) had a number,
We have a form we use at work to report client income/expenses which we
would like to modify, We have been able to make some modifications, but
other changes prompt a message indicating that the sheet is protected. When
we try to unprotect the sheet, we are prompted for a password.
Unfortunatel
You are a GENIUS!!!
On Fri, Nov 1, 2013 at 6:41 PM, Sam Mathai Chacko wrote:
> Are you looking for this?
>
> =COUNTIF($D$2:$D$15,"S")
>
> Regards,
> Sam Mathai Chacko
>
>
> On Sat, Nov 2, 2013 at 4:16 AM, Robert Barnes wrote:
>
>>
>>
>&g
First of all thank you. I am, at best, a novice user of excel. Even though
we use it for its most basic functions daily. I am attempting to go to the
next level with an inspection form that we use by allowing employees to use
tablets to complete. On the inspection we enter an s for satisfactor
Thanks in advance, experts!!
I have a PowerPoint presentation that has links to Excel charts that
need to be updated each time the Excel file is changed. I have
everything working fine (I can update, save, and close the Excel file,
open PP, and it prompts me to Update Links - I click yes, and
I guess I'm in over my head. I have no clue how to use what you just
attached. Thanks anyway.
On Sep 8, 9:30 pm, NOORAIN ANSARI wrote:
> Dear Robert,
>
> Please see attached add-in. It will be help to Compare Table.
>
> On Fri, Sep 9, 2011 at 12:29 AM, Ro
Thanks in advance, experts!
What I have:
2 worksheets in same Excel file, each has a table (Table1 on WS1,
Table2 on WS2) with the SAME headers/type of data.
As an example (only), BOTH tables have:
Invoice#Cat1SalesCat2SalesCat3Sales
TotalSales
The only difference is
> On Fri, Aug 26, 2011 at 2:13 PM, Daniel wrote:
> > Have a look at the page :
>
> >http://support.microsoft.com/kb/106359/en-us
>
> > Daniel
>
> > -Message d'origine-
> > De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.
Thanks in advance experts!!! This is very complicated to explain, but
I'll give it a go:
I have data (Invoice#, Invoice Year, Cat1 Sales, Cat2 Sales, Cat3
Sales), and need to find the percent of sales for each category, for
each year in my data.
For instance, if I have:
Invoice#Year
Well after a bit of searching, it's looking like the Report
filters are not dependent. No matter what you select in one report
filter, every record is still listed in the other filters, even if
they won't show any data when selected. Apparently there's no real
way to do this, other than upgra
hows all names now - if I click on a customer name that
doesn't belong to the currently selected sales territory, it just
shows a blank chart.
Help is appreciated Thanks!
On May 20, 11:37 pm, ashish koul wrote:
> can you attach the sample file
>
> On Sat, May 21,
Thank you in advance, experts! (also posted on Microsoft Excel
group, but not as many members, nor as many responses as I see here)
I have an Excel file with a couple of pivot tables. Everything works
perfectly, but I would like one more piece of functionality, if it's
possible.
My raw data
Is there a way to?
If B2 thru B8 is complete with all information then Delete info and send to
Sheet 2.
With B2 thru B8 now empty then more everything up. Keeping everything together.
Same thing with rest of info. For example if B18 thru B24 is Incomplete and B10
thru B16 is complete then Delete
Sorry for the multiple post, trying to send an attachment, not sure how to go
about this.
I have a strange sort question. In column B there is information
every
7 rows. Then you skip 1 row (Blank) Then there is the same
information
but with different dates in the next 7 rows and so on. Is it p
Thanks in advance to the expert that can help me
I have an excel document with thousands of records, each record has a
message associated with it that is listed on the row beneath that
record... i.e.
Record -SPR Office_Loc
123456 FS_FTW
234567
Message -
I created a file with a VB macro long time ago for the final at the
college and now i can't figure out what are the passwords i used: is
there a way i can recover them or wok something out to delete those
passwords without loosing the Macro?
--
Hi,
I have a data table like this in a sheet:
*Item* supplierItem1 ahoelting item2 cip item3 ahoelting item4 greko
item5 herroits
item6 cip item7 ahoelting
and I have a few other sheets named ahoelting, cip, etc. This table also has
a column named "In Stock" and this column is populated
I have a project I'd like to share on this discussion board, but every
time I click "New Post", there is not a place for me to attach a file
with my request. How can I do this?
--
--
Some important links for excel use
So I just got a side project dumped on my plate at work doing some VBA
stuff because I'm the only one there that knows anything about any
language (I do mostly web stuff). It kinda sucks because I am not
great with object oriented stuff (by that I mean I'm a noob). So I was
humbly wondering if you
Hi, I have the below VBA code that inserts a coloured row based on a
changing value in Cell 'C3' What I want to do is to have the macro let
the user input the cell ref themselves of 'Range("c3").Select' bit of
the code. How can I change the below code to help me do this?
Sub Insert_row()
Dim Num
Can anyone point me to a resource where I can read on cell
referencing? I.e., the address of the last match found in a column,
and be able to manipulate it so I can obtain the address of that
column, but one row deeper, or one column to the right? Possible?
Thank you.
Robert
, and closed it, I am having trouble
running it again. Oh, I can change the characters, but the colors are
not changing along with character changes. Could I have disabled VBA
somewhere? If that is the case, how do I make it run all the time
with this sheet (or workbook) is open?
Thank you.
Robert
,402,403,403, etc. I have different colors for
each value.
Ok, thanks for your help. You have no idea how much value it was to me.
Robert
At 2009-09-14 01:53 PM, you wrote:
>I missed your original post, but I went out and found it:
>Get value of AK40, call it "Supply"
- that is when
I debug it, it runs top to bottom but does not yield any results. I
was hoping someone might see something stupid I had done, and point
it out. I can repost if that is all right.
Thank you.
Robert
I must have an error in there somewhere. Is obvious to anyone
please? And no, it is not homework- I graduated college years ago.
Upon compiling, it does not return an error. I am just
33 matches
Mail list logo
